Hello,

I am using oracle 10g as database and it was good/up.Now I am trying to connect with JDBC Adapter from webMethods,Intially i have added classes12.jar,Class12.zip and ojdbc14.jar and restarted server

Now in JDBC Adapter page.I have given following parameters.Please find attached confi image and error image.Please some let me know with reason?

Paramaeters

Connection Type JDBC Adapter Connection
Package Name OracleJdbc
Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName 192.168.10.68
user wmadmin82
password ******
databaseName orcl
portNumber 1521
networkProtocol tcp
Other Properties driverType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 1
Startup Backoff Timeout (sec) 10

Error:

Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Adapters:TestConnection.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
null

There are 2 issues in this case:

1.:
dependend on JVM your are running your IS in you will only need either ojdbc5.jar (for JDK/JVM 1.5) or ojdbc6.jar (for JDK/JVM 1.6).
It should be placed und WmJDBCAdapter/code/jars. In this case it will be loaded upon loading/reloading the Adapter package.
Restarting IS is not neccessary in this case.

You can use the newest available driver from OTN for Oracle 11g, which can connect to any Oracle database down to 9i R2.
It has much better LOB support in Thin-Mode than the earlier drivers.

2.:
please check the values for any non-printable characters. most likely you have a whitespace in one of them.

I m also facing similar error,

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Databasetest:Integrationtest3.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection Databasetest:Integrationtest3: after 1 attempt(s).
[ADA.1.200] The JDBC DataSource class “oracle.jdbc.pool.OracleDataSource” cannot be located.
oracle.jdbc.pool.OracleDataSource

Can any one help on this?

jdbc Jars are not placed in IS file system. Kindly check