ODBC/JDBC

[Rich Goldman]

Not sure if this is a dumb question, but is there a JDBC/ODBC way of interfacing with my sesame server?

[Ted Thibodeau Jr]

On Oct 7, 2016, at 07:15 AM, Rich Goldman <ri...@umbc.edu> wrote:
>
> Not sure if this is a dumb question, but is there a JDBC/ODBC way of interfacing with my sesame server?

Yes and no.

To my knowledge, there's no ODBC or JDBC interface to the basic
built-in RDF4J store, but there are other options.

You can use ODBC or JDBC (as well as ADO.NET, OLE DB, or XMLA)
against Virtuoso, which features what we call "SPASQL" or
"SPARQL-in-SQL". [1] (Basically, the SPARQL keyword in Virtuoso
SQL makes Virtuoso treat what follows as a SPARQL query.)

You can then use the SERVICE keyword/function of SPARQL, to run
a Federated SPARQL query against your Sesame server's SPARQL
endpoint.

If you're already using Virtuoso as your store, then you don't
need the extra layer of SPARQL Federation (SERVICE).

Results of SPASQL queries are generally returned as tabular data,
just as normal SQL. Adding the `define output:format` pragma to
the query allows retrieval of results serialized as an RDF/XML
or Turtle document.

There is some additional documentation for ODBC [2] and other
developers [3].

I hope this is helpful.

Ted


[1] http://docs.openlinksw.com/virtuoso/rdfsparqlinline/
[2] http://docs.openlinksw.com/virtuoso/odbcimplementationext/
[3] http://docs.openlinksw.com/virtuoso/virtclientrefprogrammersguide/



--
A: Yes. http://www.idallen.com/topposting.html
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?

Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Senior Support & Evangelism // mailto:tthib...@openlinksw.com
// http://twitter.com/TallTed
OpenLink Software, Inc. // http://www.openlinksw.com/
10 Burlington Mall Road, Suite 265, Burlington MA 01803
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

[Jeen Broekstra]

I'm not sure exactly what your use case is, but the RDF4J Repository API, while not strictly ODBC-compliant, is loosely based on JDBC. It will look quite familiar to JDBC programmers, and, like JDBC, it's vendor-neutral and supported by most commercial triplestores.

So if it's just a matter of using an API that can do the kind of things JDBC can do, give the Repository API a go.

Jeen
--
sent from my phone

On 7/10/2016 10:15 PM, "Rich Goldman" <ri...@umbc.edu> wrote:

Not sure if this is a dumb question, but is there a JDBC/ODBC way of interfacing with my sesame server?

--
You received this message because you are subscribed to the Google Groups "RDF4J Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rdf4j-users+unsubscribe@googlegroups.com.
To post to this group, send email to rdf4j...@googlegroups.com.
Visit this group at https://groups.google.com/group/rdf4j-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/rdf4j-users/CAKpSeJDbpTUVTUn2sgyQjZ5Mbv4qXG%3DTVrSMW28pFS9m-EZVSQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.