No, I don't have transactions turned off. Should I do so and remove the begin() and commit() calls from my code then?
Roberto García http://rhizomik.net/~roberto 2011/11/11 Hugh Williams <hwilli...@openlinksw.com>: > Hi Roberto, > > Do you have transactions turned of when performing this bulk load operation, > using the Virtuoso “log_enable” function as SPARUL operations are no > transactional as detailed at: > > > http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfsparul > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideTransactionLogControl > > Hence the transaction errors you are encountering ... > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > On 11 Nov 2011, at 11:25, Roberto García wrote: > >> Dear all, >> >> I've started testing version 6.1.4 but I've having the same problems >> with transactions when doing a bulk update. Concretely I get the >> following exception: >> >> com.hp.hpl.jena.shared.JenaException: Couldn't create >> transaction:com.hp.hpl.jena.shared.JenaException: rethrew: >> java.sql.BatchUpdateException: SR175: Uniqueness violation : Violating >> unique index RDF_QUAD_POGS on table DB.DBA.RDF_QUAD. Transaction >> killed. >> >> This is the code I use for the upload: >> >> VirtGraph graph = new VirtGraph (DATA_URI, DB_URL, DB_USER, DB_PASSWD); >> ... >> graph.getTransactionHandler().begin(); >> graph.getBulkUpdateHandler().add(jenaModel.getModel().getGraph()); >> graph.getTransactionHandler().commit(); >> ... >> >> It seems to work well at the beginning but as I'm trying to load a >> quite big dataset (I'm regenerating the Semantic XBRL dataset) at some >> point it starts throwing this exception for most of the attempts to >> load an RDF model. >> >> Best, >> >> Roberto García >> http://rhizomik.net/~roberto >> >> ------------------------------------------------------------------------------ >> RSA(R) Conference 2012 >> Save $700 by Nov 18 >> Register now >> http://p.sf.net/sfu/rsa-sfdev2dev1 >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users > >
