JDBC Adapter for PostGreSQL

Vital_Thyot · July 16, 2020, 12:50pm

I’m trying to use JDBC Adapter for PostGre SQL. I download the driver on :
https://jdbc.postgresql.org/download.html

I want use the PostgreSQL JDBC 4.2 Driver, 42.2.14 file.

First of all, I’m always lost to put the file in the good place. I copy and past the file on the following folders (without knowing the good one) :

\IntegrationServer\packages\WmJDBCAdapter\code\jars\static
\IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars
\IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars\static
\IntegrationServer\instances\default\lib\jars\custom

And after that I refresh tje JDBC Adapter package.

According to the JDBC Adapters documentation I use the org.postgresql.ds.PGSimpleDataSource source class.

But when I try to connect, I have the following error :

[ADA.1.200] The JDBC DataSource class “org.postgresql.ds.PGSimpleDataSource” cannot be located.
org.postgresql.ds.PGSimpleDataSource

What I miss ?

Thanks for your reply

Kalpesh_Shah1 · July 16, 2020, 1:03pm

Hi Vital,

Please place jar under \IntegrationServer\instances\default\lib\jars\custom. This is the recommended place as during migration, it will pick jars from this location to the new installation. Once you place the jars in this folder, restart of IS is required for classes to be visible in IS.

Regards,
-Kalpesh.

Holger_von_Thomsen · July 16, 2020, 1:23pm

Hello,

I would prefer of having it here:
\IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars

And if you want it automatically to be provided to newly generated instances here:
\IntegrationServer\packages\WmJDBCAdapter\code\jars

In this case a reload of the package WmJDBCAdapter is sufficient to enable new versions of the jars.

static folder is only needed when the jars have a native part (a dll or shared lib) which should be located under \IntegrationServer\lib and \IntegrationServer\instances\default\lib
In this case a restart of IS is required to activate the new versions of the jars and libs.

When placing the jar under lib\jars\custom it is visible to the whole IntegrationServer, when placing under packages\WmJDBCAdapter\code\jars, it will only be visible to JDBC Adapter itself and packages which are marked to be dependent on WmJDBCAdapter package.

Regards,
Holger

Vital_Thyot · July 16, 2020, 1:52pm

Thanks Holger,
It’s clear but when I try it doesn’t work but I refresh the JDBCAdapter Package

Holger_von_Thomsen · July 16, 2020, 3:43pm

It should be avoided to have the same jar at different locations of the same instance as this might cause class loading issues when they have different versions of the same class.

Which JDBC Adapter are you using and which Fix is applied to it?

Vital_Thyot · July 16, 2020, 7:04pm

Hi Holger,
The exact message is
org.postgresql.Driver cannot be cast to javax.sql.DataSource

JDBC 10.3 FIX 9 for IS 10.5 Java 1.8.0_242 (52.0)

And I tried Driver
postgresql-42.2.14

arulchristhuraj_alphonse · July 17, 2020, 12:23am

Hi Vital,
webMethods adapter system requirement document says -PostgreSQL jar file postgresql-42.2.5.jar is required in the classpath for 10.3 JDBC adapter

Can you try with this jar version for postgresql connectivity?

maah · July 17, 2020, 4:03am

Hi Vital,

Follow below steps,

Place your driver jar under below folder and remove from other places
\IntegrationServer\instances\default\packages\WmJDBCAdapter\code\jars
restart Integration Server
Create adapter connection with below configurations
1. DataSource : org.postgresql.ds.PGSimpleDataSource
2. Fill in your DB details for server name, user,password,database name and port
3. save changes
  4)Enable Connection.

Vital_Thyot · July 17, 2020, 10:08am

Hello Alphonse,
I tried with version postgresql-42.2.5.jar with data source org.postgresql.Driver and I have still same error :
org.postgresql.Driver cannot be cast to javax.sql.DataSource

Vital_Thyot · July 17, 2020, 10:27am

Hi Mansoor,

I did it
Accourding to what Holger said to me (and after trying), it is not necessary, Reloadng package WMJDBCAdapter is enough. (Even I can see, if I do that, Adapter Connection are disabled and after enable them, I have some strange behaviour).
I use DataSource : org.postresql.Driver according to the editor doc.

But I have the same error

Vital_Thyot · July 17, 2020, 10:28am

Sorry Mansoor,
It’s work : it’s juste the “ds” between org.postgresql.ds.PGSimpleDataSource I didn’t saw in source class

Abhijith_P · March 12, 2021, 3:06pm

Hi All,

I am trying to configure JDBC adapter for postgre connectivity.

I have downloaded the jar and placed it in /webm/IntegrationServer/instances/default/lib/jars/postgresql-42.2.16.jar and my
connection parameters are

Transaction Type - LOCAL_TRANSACTION
DataSource Class - org.postgresql.ds.PGSimpleDataSource
Network Protocol - tcp
Other Properties - driverType=thin

When I am saving this details and enabling the connection I am getting the error as

[ART.118.5063] Adapter Runtime (Connection): Unable to start connection abhijith:testpostgre: after 1 attempt(s).
[ADA.1.204] Cannot connect to the database with DataSource class “org.postgresql.ds.PGSimpleDataSource”.
The connection attempt failed.

Am I missing anything. I have restarted the server too after placing the jar file.

Holger_von_Thomsen · March 12, 2021, 7:01pm

Hi Abhijith.

the jar should go to /webm/IntegrationServer/instances/default/packages/WmJDBCAdapter/code/jars.
Any PostgreSQL jar under /webm/IntegrationServer/instances/default/lib/jars/ can be removed.
Restart the IS once more and for next updates of the jat it is enough to just reload the WmJDBCAdapter package.

I think that driverType=thin is limited to Oracle databases.

There should be a more detailed error message why starting the connection fails.
The error message does not contain any informations about that.

Regards,
Holger

Abhijith_P · March 12, 2021, 7:20pm

Hi Holger

Thank you for your reply. I have two test environments in one of them i placed in intergration/libljars and in another environment i have removed the jars from lib/jars and placed in WmJDBCAdapter and reloaded the package too.

I am getting the same error which i have mentioned above. There is no specific error written anywhere other than connection not established.

coming to driverType=Thin i have removed that and tried with jdbc:postgre and the error is still the same

Holger_von_Thomsen · March 15, 2021, 4:50pm

Hi Abijith,

please check your connection configuration if there are any leading/trailing spaces in the fields.

Did you check the wrapper.log of IS or the Database logs if there is any information about the connection attempt?
Additionally you can try to tweak the logging settings of ART and JDBC Adapter to see if there will be some more helpful information then.

Regards,
Holger

system · June 13, 2021, 4:50pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Configuring JDBC Adapter Connection with PostgreSQL [SOLVED] webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	6	4026	April 2, 2021
Can't see logs in Integration service. JDBC connection issue webMethods , Service-Designer , Integration-Server-and-ESB	11	1202	March 26, 2023
jdbc adapter connection webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	40	27809	April 2, 2021
JDBC Adapter. (85.02) in WebMethods Integration Server 10.11 webMethods , Integration-Server-and-ESB	14	1085	October 27, 2022
JDBC Adapter 6.0.3 New connection Configuration Error webMethods , Integration-Server-and-ESB , Adapters-and-E-Standards	22	8180	April 2, 2021

JDBC Adapter for PostGreSQL

Related topics