We getting this error message when running the schedule job. We think it could due to the job used up all the connection available.
2008-06-18 23:23:08 EST [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occured when connecting to resource CA111_common_JDBC_v1.connection:CA111_common_adapter.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource CA111_common_JDBC_v1.connection:CA111_common_adapter.
The pool doesn’t have a connection available for the request.
Current JDBC Maximum Pool Size setting is 100. We are planning to increase the Pool Size to 200. Is anyone know is there is any limit for JDBC Maximum Pool Size or is it advisable to increase the pool size to 200? Is it too much?
We using webMethods 6.1 and JDBC Adapter 6.1.
Thanks a lot for help.