Jdbc adapter

, ,
1

hi

I use DB2 with the following configuration
Transaction Type:LOCAL_transaction
DataSource Class:com.ibm.db2.jcc.DB2Driver
serverName:55.2.7.76
user:ndeye
password:doudou
databaseName:bouchon
Enable Connection Pooling:true
portNumber:50000
Minimum Pool Size:0
Maximum Pool Size:10
Pool Increment Size:1
Block Timeout (msec):1000
Expire Timeout (msec):1000
Startup Retry Count:0
Startup Backoff Timeout (sec):10
and when I do Adapters> JDBC Adapter> Connections’ eereur have the following:

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SI2MBouchons.Connection: connection.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection SI2MBouchons.Connection: connection: after 1 attempt (s).
com.ibm.db2.jcc.DB2Driver

does anyone can help me

2

Hi,

Try adding appropriate DB2 jar file to IntegrationServer\lib\jars directory

HTH!

3

Already done

4

Hi,

Please try adding the below in the Other Properties of the JDBC Connection Properties
CHARSET=iso_1;HOSTNAME=MWAdapter;driverType=4;