We have issue with connection pool in jboss. We are facing "No Managed Connections" issue. I can see some other also facing the same.
I guess, Connection pool workings well for normal cases.
But I have few queries,
1. Will connection return to pool if there connection got SQLException(Ex: be lock timeout)? We are closing resultset, statement & connection.
2. Do we need to take any extra pre-cautions when reading a "blob"(In Mysql "text) columns?
3. Is there any issue with jboss at destroying a connection and re-creating it? Like, when there are on-demand created connections, pool will destroy those and will create again when needed. I heard, Once a connection destroyed, jboss will hangup if attempt to create new connection. Is it right?