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 frequently
Best,
Dimitris
On Sat, Oct 5, 2013 at 3:06 PM, Dimitris Kontokostas <jimk...@gmail.com>wrote:
> 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 15-50 triples at a single insert query but
> could also get some pretty big peaks
>
> Cheers,
> Dimitris
>
>
> On Sat, Oct 5, 2013 at 6:47 AM, Hugh Williams <hwilli...@openlinksw.com>wrote:
>
>> 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 <testyear>;
>> sparql insert into graph <testyear> { <a> <b> "-0031-09-02"^^
>> <http://www.w3.org/2001/XMLSchema#date><http://www.w3.org/2001/XMLSchema#date>
>> };
>> sparql insert into graph <testyear> { <a> <b1> "-4800-04-06"^^
>> <http://www.w3.org/2001/XMLSchema#date><http://www.w3.org/2001/XMLSchema#date>
>> };
>> sparql insert into graph <testyear> { <a> <b2> "-4801-04-06"^^
>> <http://www.w3.org/2001/XMLSchema#date><http://www.w3.org/2001/XMLSchema#date>
>> };
>> sparql insert into graph <testyear> { <a> <b3> "-4802-04-06"^^
>> <http://www.w3.org/2001/XMLSchema#date><http://www.w3.org/2001/XMLSchema#date>
>> };
>> sparql select * from <testyear> {?s ?p ?o};
>>
>> Output:
>> Query result:s
>> ANYp
>> ANYo
>> ANY a b -031-09-02 a b1 -4800-04-06 a b2 -4801-04-06 a b3 -4623-09-11No.
>> of rows in result: 4
>> This looks better, but :
>>
>> -4623-09-11
>> should be
>> -4802-04-06
>>
>> It couldn't properly parse date like: "-4802-04-06"
>>
>> Can you peform this same test against the live.dbpedia.org endpoint ?
>>
>> 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 -- http://twitter.com/OpenLink
>> Google+ -- http://plus.google.com/100570109519069333827/
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> Universal Data Access, Integration, and Management Technology Providers
>>
>> On 3 Oct 2013, at 16:15, Dimitris Kontokostas <jimk...@gmail.com> wrote:
>>
>> 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.openlink.virtuoso/virtjdbc4/7.0.0
>> and use VOS 7.0.0. (stable release)
>>
>> the sparql code I use for insert/delete is
>> "INSERT DATA INTO" / "DELETE DATA FROM") + " <" + graph + "> {\n"
>> ... data in triples i.e.
>> <http://dbpedia.org/resource/Battle_of_Actium> <
>> http://dbpedia.org/ontology/date> "-0031-09-02"^^<
>> http://www.w3.org/2001/XMLSchema#date> .
>> " } "
>>
>> The code I use to run the update is here
>>
>> https://github.com/dbpedia/extraction-framework/blob/master/live/src/main/java/org/dbpedia/extraction/live/storage/JDBCUtil.java#L23
>>
>> and the JDBC url is here
>>
>> https://github.com/dbpedia/extraction-framework/blob/master/live/live.default.ini#L77
>>
>> Here are a few examples from DBpedia 3.9
>> <http://dbpedia.org/resource/Battle_of_Actium> <
>> http://dbpedia.org/ontology/date> "-0031-09-02"^^<
>> http://www.w3.org/2001/XMLSchema#date> .
>> <http://dbpedia.org/resource/Peloponnesian_War> <
>> http://dbpedia.org/ontology/date> "-0404-04-25"^^<
>> http://www.w3.org/2001/XMLSchema#date> .
>> <http://dbpedia.org/resource/Roman_Republic> <
>> http://dbpedia.org/ontology/dissolutionDate> "-0027-01-16"^^<
>> http://www.w3.org/2001/XMLSchema#date> .
>> <http://dbpedia.org/resource/Battle_of_Leuctra> <
>> http://dbpedia.org/ontology/date> "-0371-07-06"^^<
>> http://www.w3.org/2001/XMLSchema#date> .
>> <http://dbpedia.org/resource/Battle_of_Pydna> <
>> http://dbpedia.org/ontology/date> "-0168-06-22"^^<
>> http://www.w3.org/2001/XMLSchema#date> .
>> <http://dbpedia.org/resource/Battle_of_Cunaxa> <
>> http://dbpedia.org/ontology/date> "-0401-09-03"^^<
>> http://www.w3.org/2001/XMLSchema#date> .
>>
>> Thanks,
>> Dimitris
>>
>>
>> On Thu, Oct 3, 2013 at 5:57 PM, Hugh Williams
>> <hwilli...@openlinksw.com>wrote:
>>
>>> 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 <testyear> { <a> <b> "-80"^^
>>> <http://www.w3.org/2001/XMLSchema#gYear><http://www.w3.org/2001/XMLSchema#gYear>
>>> };
>>> sparql insert into graph <testyear> { <a> <b> "-120"^^
>>> <http://www.w3.org/2001/XMLSchema#gYear><http://www.w3.org/2001/XMLSchema#gYear>
>>> };
>>> sparql select * from <testyear> {?s ?p ?o}
>>>
>>> 2) via java code:
>>> ps = conn.prepareStatement("sparql insert into graph <testyear> {
>>> <a1> <b> `bif:__rdf_long_from_batch_params($?,$?,$?)` }");
>>> ps.setInt(1, 4); //value with dateType
>>> ps.setString(2, "-150");
>>> ps.setString(3,
>>> "http://www.w3.org/2001/XMLSchema#gYear";<http://www.w3.org/2001/XMLSchema#gYear>
>>> );
>>> boolean rc = ps.execute();
>>>
>>> Thus we need to know:
>>>
>>> 1) what kind of datatype was used,
>>> http://www.w3.org/2001/XMLSchema#gYear or other ?
>>> 2) example of triple/triples that exhibit the problem
>>> 3) the java code example that is used for insert data
>>> 4) The version of the JDBC Driver being used ( java -jar virtjdbcX.jar
>>> , where X is the numeric value 3 or 4 )
>>> 5) The version of Virtuoso being used (virtuoso-t -?)
>>>
>>> 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 -- http://twitter.com/OpenLink
>>> Google+ -- http://plus.google.com/100570109519069333827/
>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>> Universal Data Access, Integration, and Management Technology Providers
>>>
>>> On 3 Oct 2013, at 11:20, Hugh Williams <hwilli...@openlinksw.com> wrote:
>>>
>>> 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 -- http://twitter.com/OpenLink
>>> Google+ -- http://plus.google.com/100570109519069333827/
>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>> Universal Data Access, Integration, and Management Technology Providers
>>>
>>> On 2 Oct 2013, at 08:08, Dimitris Kontokostas <jimk...@gmail.com> wrote:
>>>
>>> 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 the date related code and I didn't find anything
>>> that could produce this error, and we are formatting all the dates with
>>> Java XMLGregorianCalendar.toXMLFormat().
>>> Could this be a VirtJDBC4 bug?
>>>
>>> Best,
>>> Dimitris
>>>
>>> --
>>> Kontokostas Dimitris
>>>
>>> ------------------------------------------------------------------------------
>>> October Webinars: Code for Performance
>>> Free Intel webinars can help you accelerate application performance.
>>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>>> from
>>> the latest Intel processors and coprocessors. See abstracts and register
>>> >
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk_______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> October Webinars: Code for Performance
>>> Free Intel webinars can help you accelerate application performance.
>>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>>> from
>>> the latest Intel processors and coprocessors. See abstracts and register
>>> >
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk_______________________________________________
>>> Virtuoso-users mailing list
>>> Virtuoso-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>
>>>
>>>
>>
>>
>> --
>> Kontokostas Dimitris
>>
>> ------------------------------------------------------------------------------
>> October Webinars: Code for Performance
>> Free Intel webinars can help you accelerate application performance.
>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>> from
>> the latest Intel processors and coprocessors. See abstracts and register >
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>
>>
>>
>
>
> --
> Kontokostas Dimitris
>
--
Kontokostas Dimitris
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
