Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

Virtuoso sesame connector drops timezone information #111

Open
Rahien opened this Issue Dec 2, 2013 · 2 comments

Comments

Projects
None yet
3 participants

Rahien commented Dec 2, 2013

Hi,

I have a query that returns the correct timezone information in both the html interface and the isql interface, but that drops the timezone when used in the virtuoso sesame connector.

The query is:

SELECT ?date WHERE { 
   GRAPH <http://localhost/edcat/testsearchgraph> {
      <http://lod2.tenforce.com/wp8/dataset/testdatasetforsearch> a  <http://www.w3.org/ns/dcat#Dataset> . 
      <http://lod2.tenforce.com/wp8/dataset/testdatasetforsearch> <http://purl.org/dc/terms/modified> ?date . 
} }

and returns: "2013-10-30T14:37:00+01:00"

However, the timezone is gone when the query is performed through the virtuoso sesame connector: "2013-10-30T14:37:00Z"

When I use the debugger to inspect the internals, I see that the information is available in the virtuoso result set, so it should not be difficult to fix:
virtuoso-datetime

Some context:

TupleQueryResult result = this.connection.prepareTupleQuery(QueryLanguage.SPARQL, query).evaluate();

I am using Virtuoso 07.00.3203 on Linux with the virtuoso driver for sesame 2.7.3 build 1.12 and the virtuoso jdbc4 driver build 3.62

Collaborator

HughWilliams commented Dec 3, 2013

Hi Karel,

This is a know issue already reported to development, so I have logged this as another occurrence and requested it be looked into, thus will let you know when there is a fix ...

Rahien commented Dec 5, 2013

Hi Hugh,

Ok, thanks. Some additional information I found out and that may help out the development team: the information is not available in the internals after all. The +0100 visible in the screenshot results from my actual timezone. It is not contained in the internals of the java object because the java.sql.Timestamp class is used. This class does not support timezones. Maybe switching to another class would be an option?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment