File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Johnny SmithyJr
Greenhorn
Posts: 7
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic