All - (let me apologize if this goes out multiple times, the first attempt was caught up in the ether)
We are currently attempting to submit several objects made up of several RDF nodes from a Tomcat server into Virtuoso and are eventually getting the "Too many open statements" error. Our objects are not too large - approximately 20 triples for each. Everything works just fine until just after the 150th object, when we receive the "jdbc4.VirtuosoException: SR491: Too many open statements" error from Virtuoso (same notice appears in the Virtuoso logs) - at which point we must restart Tomcat. The effect appears cumulative - we can import 100 objects just fine, but if we try a second time, we receive the error. We are using BoneCP for connection pooling. The code running the inserts uses the UpdateDataInsert Jena class. Initially we ran it for each object - thinking that this might relate to connections, we consolidated and ran a single UpdateDataInsert update containing a large number - but we received the same errors. We have run this against external Virtuoso servers and run both Tomcat and Virtuoso on the same server - the same results. Does anyone have any suggestions? We have searched the archives but the suggestions on this error haven't helped us at all. Thanks, William Puschmann ------------------------------------------------------------------------------ Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce. Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
