You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by Jeff Lerman <je...@invitae.com.INVALID> on 2019/07/24 02:28:02 UTC
possible to run a TDB2 DB with a fuseki GUI and still have
commandline query access?
Is there a recommended technique (or a HOWTO doc) to run a TDB2 DB managed
via the Feski web console, and still allows commandline querying?
I’ve realized that one can’t simply start up Fuseki, populate a TDB2 DB
with it, and then point the commandline tool tdb2.tdbquery at that DB -
that results in "org.apache.jena.dboe.DBOpEnvException: Failed to get a
lock: …”
Any guidance would be much appreciated; the docs at jena.apache.org don’t
seem to directly address this use-case, but I’m hoping I’m
missing something.
Thanks!
[image: email_sig_logo_vert.png]
Jeff Lerman
AI Scientist
Mobile: 510-495-4621
www.invitae.com
[image: email_sig_social_linkedin.png]
<https://www.linkedin.com/in/jefflerman/>
Re: possible to run a TDB2 DB with a fuseki GUI and still have
commandline query access?
Posted by Laura Morales <la...@mail.com>.
You can use any number of clients to query Fuseki, using the SPARQL Protocol (https://www.w3.org/TR/sparql11-protocol/) or the SPARQL Graph Store HTTP Protocol (https://www.w3.org/TR/sparql11-http-rdf-update/). Under fuseki/bin there are also some CLI tools called SOH (https://jena.apache.org/documentation/fuseki2/soh.html) for querying Fuseki.
With the TDB CLI tools you manage the database directory directly whereas with Fuseki you access them indirectly, through Fuseki. In terms of querying I don't think there's much difference. The main difference is that with the CLI programs you can do more administration tasks such as "tdbcompact" for compacting a database, "tdbloader" for creating a new database from a file of triples, or "tdbquery" has an option "--explain" that I don't think you can trigger with Fuseki. I don't think Fuseki has any UI options for this kind of maintenance tasks.
> Sent: Wednesday, July 24, 2019 at 5:55 AM
> From: "Jeff Lerman" <je...@invitae.com.INVALID>
> To: users@jena.apache.org
> Subject: Re: possible to run a TDB2 DB with a fuseki GUI and still have commandline query access?
>
> Hmm. What about submitting queries against the SPARQL endpoint, using a
> different client? Would that work? If I do that, would there be any loss of
> functionality compared to what I could get by using the tdbquery tool?
>
> --Jeff
>
> On Tue, Jul 23, 2019, 8:15 PM Laura Morales <la...@mail.com> wrote:
>
> > As far as I know it's not possible to run the CLI commands on a live
> > dataset. You have to stop Fuseki first.
> >
> >
> > > Sent: Wednesday, July 24, 2019 at 4:28 AM
> > > From: "Jeff Lerman" <je...@invitae.com.INVALID>
> > > To: users@jena.apache.org
> > > Subject: possible to run a TDB2 DB with a fuseki GUI and still have
> > commandline query access?
> > >
> > > Is there a recommended technique (or a HOWTO doc) to run a TDB2 DB
> > managed
> > > via the Feski web console, and still allows commandline querying?
> > >
> > > I’ve realized that one can’t simply start up Fuseki, populate a TDB2 DB
> > > with it, and then point the commandline tool tdb2.tdbquery at that DB -
> > > that results in "org.apache.jena.dboe.DBOpEnvException: Failed to get a
> > > lock: …”
> > >
> > > Any guidance would be much appreciated; the docs at jena.apache.org
> > don’t
> > > seem to directly address this use-case, but I’m hoping I’m
> > > missing something.
> > >
> > > Thanks!
> > >
> > >
> > > [image: email_sig_logo_vert.png]
> > >
> > > Jeff Lerman
> > >
> > > AI Scientist
> > >
> > > Mobile: 510-495-4621
> > >
> > > www.invitae.com
> > >
> > > [image: email_sig_social_linkedin.png]
> > > <https://www.linkedin.com/in/jefflerman/>
> > >
> >
>
Re: possible to run a TDB2 DB with a fuseki GUI and still have
commandline query access?
Posted by Jeff Lerman <je...@invitae.com.INVALID>.
Hmm. What about submitting queries against the SPARQL endpoint, using a
different client? Would that work? If I do that, would there be any loss of
functionality compared to what I could get by using the tdbquery tool?
--Jeff
On Tue, Jul 23, 2019, 8:15 PM Laura Morales <la...@mail.com> wrote:
> As far as I know it's not possible to run the CLI commands on a live
> dataset. You have to stop Fuseki first.
>
>
> > Sent: Wednesday, July 24, 2019 at 4:28 AM
> > From: "Jeff Lerman" <je...@invitae.com.INVALID>
> > To: users@jena.apache.org
> > Subject: possible to run a TDB2 DB with a fuseki GUI and still have
> commandline query access?
> >
> > Is there a recommended technique (or a HOWTO doc) to run a TDB2 DB
> managed
> > via the Feski web console, and still allows commandline querying?
> >
> > I’ve realized that one can’t simply start up Fuseki, populate a TDB2 DB
> > with it, and then point the commandline tool tdb2.tdbquery at that DB -
> > that results in "org.apache.jena.dboe.DBOpEnvException: Failed to get a
> > lock: …”
> >
> > Any guidance would be much appreciated; the docs at jena.apache.org
> don’t
> > seem to directly address this use-case, but I’m hoping I’m
> > missing something.
> >
> > Thanks!
> >
> >
> > [image: email_sig_logo_vert.png]
> >
> > Jeff Lerman
> >
> > AI Scientist
> >
> > Mobile: 510-495-4621
> >
> > www.invitae.com
> >
> > [image: email_sig_social_linkedin.png]
> > <https://www.linkedin.com/in/jefflerman/>
> >
>
Re: possible to run a TDB2 DB with a fuseki GUI and still have
commandline query access?
Posted by Laura Morales <la...@mail.com>.
As far as I know it's not possible to run the CLI commands on a live dataset. You have to stop Fuseki first.
> Sent: Wednesday, July 24, 2019 at 4:28 AM
> From: "Jeff Lerman" <je...@invitae.com.INVALID>
> To: users@jena.apache.org
> Subject: possible to run a TDB2 DB with a fuseki GUI and still have commandline query access?
>
> Is there a recommended technique (or a HOWTO doc) to run a TDB2 DB managed
> via the Feski web console, and still allows commandline querying?
>
> I’ve realized that one can’t simply start up Fuseki, populate a TDB2 DB
> with it, and then point the commandline tool tdb2.tdbquery at that DB -
> that results in "org.apache.jena.dboe.DBOpEnvException: Failed to get a
> lock: …”
>
> Any guidance would be much appreciated; the docs at jena.apache.org don’t
> seem to directly address this use-case, but I’m hoping I’m
> missing something.
>
> Thanks!
>
>
> [image: email_sig_logo_vert.png]
>
> Jeff Lerman
>
> AI Scientist
>
> Mobile: 510-495-4621
>
> www.invitae.com
>
> [image: email_sig_social_linkedin.png]
> <https://www.linkedin.com/in/jefflerman/>
>