wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes how to configure persistence.xml - java persistence api - with apache commons pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "how to configure persistence.xml - java persistence api - with apache commons pool" Watch "how to configure persistence.xml - java persistence api - with apache commons pool" New topic
Author

how to configure persistence.xml - java persistence api - with apache commons pool

Johnny SmithyJr
Greenhorn

Joined: Mar 03, 2010
Posts: 7
how to configure persistence.xml - java persistence api - with apache commons pool

I first configured it with c3p0 but have an issue with large results sets where c3p0 doesn't close the connection
ie:
try
{
}
finally
{
em.close();
}

I set max connections to 1 and if I try two queries on large result set em.close() keps the connnections managed in c3p0 - clearly a c3p0 issue, so I want to switch to apache commons pool and see if I get the same issue
 
jQuery in Action, 2nd edition
 
subject: how to configure persistence.xml - java persistence api - with apache commons pool
 
Similar Threads
EJB3 JPA implementation
No Persistence provider for EntityManager named helloworld
Spring Framework and Hibernate
Hibernate Connection Pooling.
How to configure c3p0 connection pool weblogic ??