Unable to Connect Postgres DB using JDBC Adapter

, ,
1

I have IS 6.1 running and Postgre 8.1.

Configured the JDBC Adapter Connection with following details…

Transaction Type: LOCAL_TRANSACTION
DataSource Class: org.postgresql.jdbc3.Jdbc3PoolingDataSource
serverName : xxx.xxx.xxx.xxx
user : uuuuuuu
password : ppppppp
dataBaseName : test
portNumber : 5432

Get error message when tried to Enable the adapter.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource postgres:postgresConn.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
javax/sql/DataSource

I have copied postgres jdbc driver jar postgresql-8.0.309.jdbc3.jar to c:\wm6\IntegrationServer\lib\jars folder

Please let me know if I am missing something…

2

I’m getting the same problem, except I think there is a important error which is:

[ADA.1.200] The JDBC DataSource class “org.postgresql.ds.PGConnectionPoolDataSource” cannot be located.
In my case I’m trying to use org.postgresql.ds.PGConnectionPoolDataSource. And I have both jdbc3 and jdbc4 jars inside
IntegrationServer\packages\WmJDBCAdapter\code\jars

3

okay I was able to get this working in the end. I used:

DataSource Class= org.postgresql.ds.PGConnectionPoolDataSource

I also re-install the JDBC adapters and re-enable them in order for changes to be picked up.