You should keep the BoneCP connections number / concurrent connections low.
I had the same problem with DBpedia Live (and BoneCP) and noticed that
keeping the concurrent threads below 7 was working fine.
Above that number I started getting the same error
Best,
Dimitris
On Tue, Sep 9, 2014 at 4:52 PM, William Puschmann <bpuschm...@sapient.com>
wrote:
> 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
>
--
Kontokostas Dimitris
------------------------------------------------------------------------------
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
