Every time my EJB (Stateless) requests a database connection a new database connection is created rather using it from the pool. Connection pooling is working fine with my web applications.
In EJB3.0 following is listed as one of the limitations.
XA Connection pool is not available yet.
Does that mean it does not support pooling at all. If so how can I close database connection immediately rather than returning it to pool ( I don't what to change the idle time out as the same JNDI is used by web apps also).
My mistake. I had a function which wasn't closing connection.