-
1. Re: Unable to get managed connection for Datasource
abhinav.gupta01 Mar 20, 2015 8:14 AM (in response to mylos78)I am not sure , but a pool size of 500 is way too big.
I suspect your application might be have some connection leak. Did you try investigating from leak perspective ?
-
2. Re: Unable to get managed connection for Datasource
f_marchioni Mar 26, 2015 11:16 AM (in response to mylos78)You are consuming lots of time to create your connections. Try to increase the blocking-timeout-wait and see if this is the root of the problem:
/subsystem=datasources/data-source=YourDS/:write-attribute(name=blocking-timeout-wait-millis,value=60000)
Also I'd suggest in this scenario to set a min pool size with pool prefill to true in order to create your database connections at server startup.
/subsystem=datasources/data-source=YourDS/:write-attribute(name=min-pool-size,value=350)
/subsystem=datasources/data-source=YourDS/:write-attribute(name=pool-prefill,value=true)
-
3. Re: Unable to get managed connection for Datasource
jesper.pedersen Mar 26, 2015 9:56 AM (in response to f_marchioni)use-strict-min should only be used if you don't want to validate min-pool-size for time outs, broken, ... So, leave that off
-
4. Re: Unable to get managed connection for Datasource
f_marchioni Mar 26, 2015 10:07 AM (in response to jesper.pedersen)yes, beg your pardon. Thanks for pointing it out
-
5. Re: Unable to get managed connection for Datasource
mylos78 Mar 26, 2015 11:14 AM (in response to f_marchioni)Thanks! the error has disappeared! thanks!!!!