postgresql adapter setting

, ,
1

I am creating a new adapter postgresql, however it was unable to connect.
I got the following error:

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource bossiniIntranet.adapters:Intranet.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
null

I guess there is something wrong with my settings.

my setting:
Transaction Type:

2

my Setting:

Transaction Type: LOCAL_TRANACTION
DataSource Class : org.postgresql.Driver
networkProtocol:
Other Properties:

do i need to set networkprotocol and other properties?

Thanks alot

3

hi
I think this adapter is not support for in jdbc. only jdbc support 8 databases only. same problem i faced in my porject also. we done some services on that time. we can configure postgres adapter also but you gave data source class name is wrong.you need postgresql-8[1].2dev-503.jdbc2ee.jar u need to store in integration server- lib -jars …you need to put that jar file.

regards
sagar

4

You’ve put Driver instead of DataSource. Try org.postgresql.ds.PGPoolingDataSource.
Any way, webMethods JDBC Adapter does not support this database although it works fine as I tested.