Friday, 7 March 2014

javax.resource.spi.applicationserverinternalexception unable to create a connection

Very Often when we try to connect with Database from Bpel to perform any operations may be :insert or update or delete we face the below error :

"
JCA Binding Component was unable to establish an outbound JCA CCI connection due to the following issue: javax.resource.spi.ApplicationServerInternalException: Unable to get a connection for pool.weblogic.common.resourcepool.ResourceLimitException: Configured maximum limit of (0) on number of threads allowed to wait for a resource reached for pool :eis/db/Testjndi. Please make sure that the JCA connection factory and any dependent connection factories have been configured with a sufficient limit for max connections. Please also make sure that the physical connection to the backend EIS is available and the backend itself is accepting connections. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution."

 Solution to the above error  is explained below :

1> Go to weblogic  console,example : http://host:port/console

2> Go to Environment->Services -> Data Sources

3> Select Your Data Source

4> From Top select Connection Pool tab

5> Go to  bottom of the page and see there is option called maximum capacity. Increase its value for example if its current is : 200 make it 500.Screenshot for sample shown below :



6> Click on save button at bottom..
7> Go back to home page of weblogic console
8> Select Deployments-> DB Adapter checkbox
9> Select option Update-> follow steps one by one default to finish and update.

Run your code this time it will not throw the above error.Hope it helps in solving!!!

Happy programming!!!!!

2 comments:

  1. you are going to open max o 1600 connection to db , dba wont like it
    it is a over kill assume this is cluster of fouor server then it is going to be
    4 * 1600 db is toast
    i agree with the part of increasing the db connection but that has to be done in more reasonable way

    ReplyDelete
  2. Respect and I have a nifty offer you: How Much Budget For House Renovation renovate my home

    ReplyDelete