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
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: how to configure persistence.xml - java persistence api - with apache commons pool