All - 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 ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
