Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization 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
  • Likes 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