aspose file tools*
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
 
Consider Paul's rocket mass heater.
 
subject: how to configure persistence.xml - java persistence api - with apache commons pool