Hi Roberto, Yes, you can remove these as there is nothing to commit ...
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 15:27, Roberto García wrote: > 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 >> >> > > ------------------------------------------------------------------------------ > 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
smime.p7s
Description: S/MIME cryptographic signature