Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-26 Thread Dimitris Kontokostas
Hi Hugh, any progress on this? I am getting many other date wrong date errors as well JDBC fails due to wrong dates such as day 31 in months like june, Sep, ... I checked my code for possible cases and created a post-date-validator to ensure this is not my fault, however inserts fail quite freque

Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-04 Thread Dimitris Kontokostas
Hi Hugh, I can confirm this error on live.dbpedia.org (Version: 07.00.320) although conductor doesn't complain maybe jdbc is more strict and throws an exception if it makes sense, you could add a few triples before and after the date to simulate dbpedia live better the number is usually between 1

Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-04 Thread Hugh Williams
Hi Dimitar, We have tried nserts and querys of similar data to what you provided VOS7.00.3203 via conductor and can still get past -100: sparql clear graph ; sparql insert into graph { "-0031-09-02"^^ }; sparql insert into graph { "-4800-04-06"^^

Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-03 Thread Dimitris Kontokostas
Hi Hugh, According to the error I sent you (Cannot convert 0-46-04-06 to datetime : Incorrect year value) it should be xsd:date: "-0046-04-06"^^< http://www.w3.org/2001/XMLSchema#date> I use the jdbc4 version copied at the time of VOS7.0.0 release http://maven.aksw.org/archiva/browse/com.openlin

Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-03 Thread Hugh Williams
Hi Dimitris, We have tested the following scenarios for testing insertion and querying of data, which work: 1) via conductor interface: sparql insert into graph { "-80"^^ }; sparql insert into graph { "-120"^^

Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-03 Thread Hugh Williams
Hi Dimitris, We are checking this and will report back ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter

[Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-02 Thread Dimitris Kontokostas
Hi, I get errors when I try to insert triples with negative year above -100 e.g.: "Cannot convert 0-46-04-06 to datetime : Incorrect year value" I am working with data streams (DBpedia Live) and it's hard to debug this kind of errors on the server or reproduce them locally. I checked through all