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

 

Required Tool and Software: 

• OpenJDK / Oracle JAVA 
• dbconnect.jar
• postgresql-42.6.0.jar

Download link for dbconnect.jar and postgresql-42.6.0.jar

https://drive.google.com/drive/folders/1H0UI62dmVnAQmKmPSRMrztmzrq1y49to?usp=drive_link

TEST Connection for POSTGRESQL,

Command:

/usr/bin/java -cp /home/app/test/dbConnect.jar:/home/app/test/postgresql-42.6.0.jar com.sid.dbConnect jdbc:postgresql://123.456.123.789:1234/postgres  “$username” ‘$Password’  org.postgresql.Driver

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

-Dcom.ibm.jsse2.overrideDefaultTLS=true

Thanks :-)