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
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.