Hi Bharath,
I doubt the data is being loaded incorrectly but sounds as an index on the
RDF_QUAD table might be corrupt, which case you could try dropping and
recreating them as detailed at:
http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html#rdfperfrdfscheme
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 2 May 2011, at 08:14, Bharath V wrote:
> Hi,
> I am using the below code snippet to load a rdf/xml file into virtuoso. It
> loads the data correctly, but while deleting(clear graph
> <http://www.load.org>) the graph gives
>
> Error : " SQLState: 42S12 Message: SR201: Primary key not found in delete"
> .Is this a problem with the way the data is being loaded into virtuoso or a
> different problem.
>
> Code:
> Model model = ModelFactory.createDefaultModel();
> model.read("file:\\load.xml");
> StmtIterator stmtIterator = model.listStatements();
> List<Triple> triples = new LinkedList<Triple>();
> while (stmtIterator.hasNext()) {
> triples.add(stmtIterator.nextStatement().asTriple());}
> VirtGraph virtGraph = new VirtGraph("http://www.load.org";, DB_URL, "dba",
> "dba");
> BulkUpdateHandler bulkUpdateHandler = virtGraph.getBulkUpdateHandler();
> TransactionHandler transactionHandler = virtGraph.getTransactionHandler();
> transactionHandler.begin();
> bulkUpdateHandler.add(triples);
> transactionHandler.commit();
>
>
> Thank You,
> Bharath
>
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network
> management toolset available today. Delivers lowest initial
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
