Re: [Virtuoso-users] Accessing SPARQL result sets via JDBC

2011-05-06 Thread Hugh Williams
Hi Timo,

Yes you can access SPARQL results sets via the JDBC driver using the 
ExtendedString etc method as detailed in section 7.4.3.5. Extension datatype 
for RDF”  of the online documentation at:

http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html

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 4 May 2011, at 12:08, Timo Westkämper wrote:

 Hi.
 
 Is it possible to access SPARQL results via JDBC using proper Node 
 representation (ExtendedString, RdfBox etc) and not the SQL types?
 
 I did not yet manage to do this via the output:valmode.
 
 My use case is to get the persisted timezone offset of an xsd:dateTime 
 literal. When accessing the literal via the java.sql.Timestamp instance, 
 it is not possible.
 
 Br,
 Timo Westkämper
 
 --
 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




Re: [Virtuoso-users] Accessing SPARQL result sets via JDBC

2011-05-06 Thread Timo Westkämper

Hi Hugh.

Is it possible to enforce Virtuoso to return VirtuosoRdfBoxes for all 
literal instances? It seems for most non-String literals the Java type 
is preferred (e.g. Number subclasses, java.sql.Timestamp, java.sql.Date, 
java.sql.Time etc).


I am able to access VirtuosRdfBox instances correctly, the problem is 
that I don't want any SQL types, since they don't have the timezone 
offset preserved.


Trying different output:valmode options didn't help.

Br,
Timo Westkämper

On 05/06/2011 02:38 PM, Hugh Williams wrote:

Hi Timo,

Yes you can access SPARQL results sets via the JDBC driver using the ExtendedString 
etc method as detailed in section 7.4.3.5. Extension datatype for RDF”  of the 
online documentation at:

http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html

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 4 May 2011, at 12:08, Timo Westkämper wrote:


Hi.

Is it possible to access SPARQL results via JDBC using proper Node
representation (ExtendedString, RdfBox etc) and not the SQL types?

I did not yet manage to do this via the output:valmode.

My use case is to get the persisted timezone offset of an xsd:dateTime
literal. When accessing the literal via the java.sql.Timestamp instance,
it is not possible.

Br,
Timo Westkämper

--
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