[jboss-user] [JCA/JBoss] - Re: Thread BLOCKED on registerConnection/unregisterConnectio

vickyk do-not-reply at jboss.com
Fri Sep 7 03:07:16 EDT 2007


There seems to be couple of possibilities 
1) Long running genuine SQL's 
2) Untuned SQL's which are taking longer time to get execute thus making the connection unavailable to pool for longer time .
For the "long running SQL's " you would have to configure the pool with larger number of connections and for the latter case you got to optimize the application code (fine tune SQL's) .

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4081953#4081953

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4081953



More information about the jboss-user mailing list