We have the same issue here with our project. I'm interested to hear what the experts have to say
Vincent Vu Nguyen -----Original Message----- From: Nicolas Hervé [mailto:[email protected]] Sent: Wednesday, September 26, 2012 11:08 AM To: [email protected] Subject: [fcrepo-user] SQL connection not returned to the pool Hi, I'm having troubles with FindObjects() queries. If I choose to retrieve only the first result of a query : FindObjects findObjectsQuery = new FindObjects().query(query).maxResults(1).pid(); but the query has potentially more than one result, then on the server side the org.fcrepo.server.search.FieldSearchResultSQLImpl is cached for later use. As it keeps the underlying SQL connection, the pool is quickly exhausted. Is there any way to invalidate this object when we explicitly don't plan to access it anymore ? The workaround is to retrieve all results, but it's quite painful. Regards, Nicolas HERVE ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users ------------------------------------------------------------------------------ How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how slow your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219672;13503038;z? http://info.appdynamics.com/FreeJavaPerformanceDownload.html _______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
