Java tips

Probably not the most elegant script in the world but shows how to connect to an Oracle database using java.

See also :

https://www.durham.computer/2018/02/java-in-database.html

[oracle@CORA01 test_cub]$ cat status.java

import java.sql.*;

public class status {

public void printSuccess() {

System.out.println("Connection using - jdbc:oracle:thin:@cora-scan/1521:ods");

}

public void printdatafiles() {

System.out.println("End of script!");

}

public static void main(String[] args)

throws ClassNotFoundException, SQLException

{

Class.forName("oracle.jdbc.driver.OracleDriver");

// jdbc:oracle:thin:@host:port/service

String url = "jdbc:oracle:thin:@cora-scan:1521";

Connection conn =

DriverManager.getConnection( "jdbc:oracle:thin:@cora01:1521/ods","edw","edw");

conn.setAutoCommit(false);

Statement stmt = conn.createStatement();

ResultSet rset =

stmt.executeQuery("select BANNER from SYS.V_$VERSION");

while (rset.next()) { System.out.println (rset.getString(1)); }

stmt.close();

System.out.println (" Global Name");

Statement stmt2 = conn.createStatement();

ResultSet rset2 =

stmt2.executeQuery("select * from global_name");

while (rset2.next()) { System.out.println (rset2.getString(1)); }

stmt2.close();

System.out.println ("Test JDBC connection");

Statement stmt3 = conn.createStatement();

status mystatus=new status();

mystatus.printSuccess();

mystatus.printdatafiles();

}

}

[oracle@CORA01 test_cub]$ /u01/app/oracle/product/12.2.0/dbhome/jdk/bin/javac status.java

[oracle@CORA01 test_cub]$ /u01/app/oracle/product/12.2.0/dbhome/jdk/bin/java -cp /u01/app/oracle/product/12.2.0/dbhome/jdbc/lib/ojdbc8.jar:/home/oracle/test_cub status

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

PL/SQL Release 12.2.0.1.0 - Production

CORE    12.2.0.1.0      Production

TNS for Linux: Version 12.2.0.1.0 - Production

NLSRTL Version 12.2.0.1.0 - Production

Global Name

ODS

Test JDBC connection

Connection using - jdbc:oracle:thin:@cora-scan/1521:ods

End of script!