PostgreSQL JDBC for Integration Server 9.8

Rahmat_Yanuar · August 24, 2016, 6:12am

Hello Guys,
Which jdbc I use for Integration Server 98 ? Is that true, if I put the jdbc file on /mydirectory/IS98/IntegrationServer/packages/WmJDBCAdapter/code/jars/ ?

I was tried to use any version for postgre jdbc, but still error :

Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource company.adapter.conn:postgresql1.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.619] Configuration file not loaded succesfully. Please check the configuration file of NOSUPPORT
java.lang.NullPointerException

Regard,
Yanuar

Holger_von_Thomsen · August 24, 2016, 12:13pm

Hi Rahmat,

which version of JDBC Adpater (6.5 or 9.0) with which Fixes applied are you using?

Try to get the most recent jdbc driver for PostgreSQL.

Regards,
Holger

Mahesh_K_Sreenivas · August 24, 2016, 6:29pm

Have a look at “webMethods_Adapters_System_Requirements” before setting up JDBC connection.

Holger_von_Thomsen · August 24, 2016, 6:48pm

Hi Rahmat,

which version of Postgre SQL are you on?

You can download a driver from here:
https://jdbc.postgresql.org/download.html

Regards,
Holger

Rahmat_Yanuar · August 25, 2016, 5:19am

I have try :

postgresql-9.0-802.jdbc4.jar
postgresql-9.1-901-1.jdbc4.jar
postgresql-9.3-1103.jdbc3.jar

Holger_von_Thomsen · August 25, 2016, 6:57pm

Hi Rahmat,

what is the version of your PostgreSQL Server then?

Driver version should either match the server version or newer than this.

Regards,
Holger