Hugh,
thanks for your answer.
My virtuoso version is:
Virtuoso Open Source Edition (multi threaded)
Version 6.1.3.3127-pthreads as of Aug 1 2011
Compiled for Linux (x86_64-unknown-linux-gnu)
Copyright (C) 1998-2011 OpenLink Software
In the meantime, I could resolve problem deleting a whole graph and everything
works as expected. Currently I automated the process using this small isql-file
(so luckily these are the steps to solve my problem):
sparql drop silent graph <URI>;
delete from db.dba.load_list where ll_graph like '%URI%';
ld_dir_all ('/usr/local/virtuoso-opensource/load','*','URI');
rdf_loader_run ();
For the second problem I still have no idea how to do this:
I will need to update and delete triples selectively by subject-URI. I will
probably get the updates as a RDF-File containing the updated triples for some
of the stored RDF-Resources and the deletes as a separate file (e.g. a list of
URIs). Is there a sensible way to do that?
Thanks for any hints
Andreas
-------- Original-Nachricht --------
> Datum: Fri, 5 Aug 2011 13:19:49 +0100
> Von: Hugh Williams <hwilli...@openlinksw.com>
> An: Andreas Kahl <andreas_k...@gmx.net>
> CC: andreas.radin...@ebusiness-unibw.org, virtuoso-users@lists.sourceforge.net
> Betreff: Re: [Virtuoso-users] How to delete all triples from a named graph /
> for a given subject?
> Hi Andreas,
>
> Please provide details of the Virtuoso version being used (virtuoso-t -?),
> and also a simple test case showing the steps to reproduce the problem you
> are seeing, so we can attempt recreation locally ...
>
> 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 5 Aug 2011, at 10:33, Andreas Kahl wrote:
>
> > Hello again,
> >
> > now, after deleting the graph, I loaded new data into the graph and the
> old triples are there again (in addition to the old ones). It seems, they
> were not really deleted.
> > Is there some restriction that I must not reuse a graph- or subject-URI
> after having deleted it previously?
> >
> > Andreas
> >
> > -------- Original-Nachricht --------
> >> Datum: Fri, 05 Aug 2011 11:05:15 +0200
> >> Von: "Andreas Kahl" <andreas_k...@gmx.net>
> >> An: Andreas Radinger <andreas.radin...@ebusiness-unibw.org>
> >> CC: virtuoso-users@lists.sourceforge.net
> >> Betreff: Re: [Virtuoso-users] How to delete all triples from a named
> graph / for a given subject?
> >
> >> Hello Andreas,
> >>
> >> thanks a lot for your hint - now the data seems to be deleted from the
> >> graph. (the Interactive SQL said: "Drop silent graph <URI> -- nothing
> to do"
> >> , but the data is not returned by SPARQL SELECTs any more).
> >>
> >> I am still interested how to update data about a single RDF-Subject
> >> (preferably via SPARQL Update).
> >>
> >> Andreas
> >>
> >>
> >>
> >> -------- Original-Nachricht --------
> >>> Datum: Fri, 05 Aug 2011 10:55:24 +0200
> >>> Von: Andreas Radinger <andreas.radin...@ebusiness-unibw.org>
> >>> An: Andreas Kahl <andreas_k...@gmx.net>
> >>> CC: virtuoso-users@lists.sourceforge.net
> >>> Betreff: Re: [Virtuoso-users] How to delete all triples from a named
> >> graph / for a given subject?
> >>
> >>> On 8/5/11 10:43 AM, Andreas Kahl wrote:
> >>>> Hello,
> >>>>
> >>>> I loaded some data into Virtuoso OSE 6.1.3 using the BulkLoader. For
> >>> every dataset I defined a named graph.
> >>>> How can I now delete all Triples from one of those graphs?
> >>>>
> >>>> I tried 'sparql clear graph <URI>' in conductor's interactive SQL (as
> >>> user dba), the system said it executed the query successfully. But
> after
> >>> that, I still can retrieve the data from this graph via SPARQL Select.
> >>>>
> >>>> Alternatively I tried 'sparql drop graph <URI>'. But this lead to an
> >>> error saying: "Message: SPARUL_DROP() failed: graph <URI> has not been
> >>> explicitly created before."
> >>>>
> >>>> So is there another command I should use?
> >>> Hi Andreas,
> >>>
> >>> try 'sparql drop silent graph <URI>;'
> >>> as described at [1] for graphs that are not created explicitly.
> >>>
> >>> Best,
> >>> Andreas
> >>>
> >>> [1]
> >>>
> >>
> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideCreateGraph
> >>>>
> >>>> Another question to is how to update data describing a single
> >>> RDF-Subject. How could I issue commands to delete all Triples having a
> >> certain URI as
> >>> RDF-Subject? (and then bulk load the new data).
> >>>>
> >>>> Thanks for your help.
> >>>>
> >>>> Andreas
> >>>>
> >>>>
> >>>
> >>
> ------------------------------------------------------------------------------
> >>>> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
> >>>> The must-attend event for mobile developers. Connect with experts.
> >>>> Get tools for creating Super Apps. See the latest technologies.
> >>>> Sessions, hands-on labs, demos & much more. Register early & save!
> >>>> http://p.sf.net/sfu/rim-blackberry-1
> >>>> _______________________________________________
> >>>> Virtuoso-users mailing list
> >>>> Virtuoso-users@lists.sourceforge.net
> >>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> >>>
> >>
> >>
> ------------------------------------------------------------------------------
> >> BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
> >> The must-attend event for mobile developers. Connect with experts.
> >> Get tools for creating Super Apps. See the latest technologies.
> >> Sessions, hands-on labs, demos & much more. Register early & save!
> >> http://p.sf.net/sfu/rim-blackberry-1
> >> _______________________________________________
> >> Virtuoso-users mailing list
> >> Virtuoso-users@lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> >
> >
> ------------------------------------------------------------------------------
> > BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
> > The must-attend event for mobile developers. Connect with experts.
> > Get tools for creating Super Apps. See the latest technologies.
> > Sessions, hands-on labs, demos & much more. Register early & save!
> > http://p.sf.net/sfu/rim-blackberry-1
> > _______________________________________________
> > Virtuoso-users mailing list
> > Virtuoso-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
