we just upgraded webMethods 6.1 to 6.5 recently. everything was working fine except the JDBC Adapter. it was giving the follwoing error
[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service IFC_OIL.Oracle:getOutboundTransaction.
[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource IFCJDBCAdapters:OracleEAI.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource IFCJDBCAdapters:OracleEAI.
A connection was not available for request in pool IFCJDBCAdapters:OracleEAI
i tried couple of Adapter services. I created one dynamic SQL and executed it perfectly without any errors. But when i was trying to execute the stored procedure it was giving the above error. Here are configuration settings.
Connection Type JDBC Adapter Connection
Package Name IFCJDBCAdapters
Transaction Type LOCAL_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
Other Properties driverType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 0
Maximum Pool Size 5
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 600000
Startup Retry Count
Startup Backoff Timeout (sec)
Can anyone hllp me regarding this…?