Wednesday 20 September 2023

How to make datasource test-connection to Oracle DB Instance.

 Required Tool and Software: 

  • OpenJDK / Oracle JAVA 
  • dbconnect.jar
  • ojdbc8.jar

Download link for dbconnect.jar and ojdbc8.jar and other .jar’s

TEST Connection for Oracle,


/usr/bin/java -cp /opt/test/dbConnect.jar:/opt/test/ojdbc8.jar com.sid.dbConnect jdbc:oracle:thin:@123.789.123.456/SERVICENAME “$username”  ‘$Password’ oracle.jdbc.driver.OracleDriver

FYI , Class Name to be used on Datasource for  application servers to connect respective Oracle DB (11g / 12c / 19c ) :

 oracle.jdbc.xa.client.OracleXADataSource   (for 19c and 12c DB , ojdbc8.jar with JDK8 complied)

oracle.jdbc.pool.OracleConnectionPoolDataSource  (for 11g with minimum jDK7, JDK8 complied)

New JDBC String : LOADBALANCER and failover for ORACLE Datasource


Add below parameter on JVM arguments if you were facing SSL_protcol_Handshake issue on WebSphere Application server / WebSphere liberty.

Thanks :-)

No comments:

Post a Comment