Virtuoso Jena Provider查询日期型数据的bug修正

（该bug在使用virt_jena2.jar时出现，在使用virt_jena3.jar时则不会出现该bug，所以另一种避免该bug的方式是使用新版本的Virtuoso Jena Provider ）

现象：用jenaAPI检索出的与日期相关的literal（主要是datatype为date或year的literal），检索出来的值比原始值推迟5天；

例如：

Virtuoso中原始数据为：（实体<http://dbpedia.org/resource/James_Shillaker>）

http://dbpedia.org/ontology/birthDate	1870-01-28
http://dbpedia.org/ontology/birthYear	"1870"^^<http://www.w3.org/2001/XMLSchema#gYear>
http://dbpedia.org/ontology/deathDate	1943-07-20
http://dbpedia.org/ontology/deathYear	"1943"^^<http://www.w3.org/2001/XMLSchema#gYear>

用Jena检索，出bug的结果为（用virt_jena2.jar时的输出）：

item:  ( ?p = <http://dbpedia.org/ontology/birthDate> ) ( ?o = "1870-02-02"^^xsd:date ) ( ?graph = <summeval.dbpedia2015-10.org> )

item:  ( ?p = <http://dbpedia.org/ontology/birthYear> ) ( ?o = "1870-01-06"^^xsd:gYear ) ( ?graph = <summeval.dbpedia2015-10.org> )

item:  ( ?p = <http://dbpedia.org/ontology/deathDate> ) ( ?o = "1943-07-25"^^xsd:date ) ( ?graph = <summeval.dbpedia2015-10.org> )

item:  ( ?p = <http://dbpedia.org/ontology/deathYear> ) ( ?o = "1943-01-06"^^xsd:gYear ) ( ?graph = <summeval.dbpedia2015-10.org> )

正确结果应该为（用virt_jena3.jar时的输出）：

item:  ( ?p = <http://dbpedia.org/ontology/birthDate> ) ( ?o = "1870-01-28"^^xsd:date ) ( ?graph = <summeval.dbpedia2015-10.org> )

item:  ( ?p = <http://dbpedia.org/ontology/birthYear> ) ( ?o = "1870"^^xsd:gYear ) ( ?graph = <summeval.dbpedia2015-10.org> )

item:  ( ?p = <http://dbpedia.org/ontology/deathDate> ) ( ?o = "1943-07-20"^^xsd:date ) ( ?graph = <summeval.dbpedia2015-10.org> )

item:  ( ?p = <http://dbpedia.org/ontology/deathYear> ) ( ?o = "1943"^^xsd:gYear ) ( ?graph = <summeval.dbpedia2015-10.org> )

版本信息：

jena：3.4.0；

virtjdbc：virtjdbc4.jar；

virt_jena：采用virt_jena2.jar时会出现上述bug，virt_jena3.jar时则一切正常；

处理方案：

处理方案：

对于出bug的情况，可通过以下代码对已检索出的结果进行调整（将日期重新提前5天）（要用到joda-time）：

publicstaticPairList<String,Node>getFeaturesFowardWithoutSameAs(String eUri,VirtGraph vgraph,booleanneedConvert){

    String qstr = "select ?p ?o where {<" + eUri + "> ?p ?o. }" ;   //  示例查询

    Query qIn = QueryFactory . create ( qstr );

    VirtuosoQueryExecution vqeIn = VirtuosoQueryExecutionFactory . create ( qIn , vgraph );

    ResultSet rs = vqeIn . execSelect ();

    PairList < String , Node > pvList = new PairList < String , Node >();

     while ( rs . hasNext ()){ //逐个处理查出来的triple（若当前使用的是virt_jena2.jar，则这些triple中date相关的literal值存在错误，会进行修改，）

        QuerySolution soln = rs . next ();

        RDFNode prs = soln . get ( "?p" );

        Node ors = soln . get ( "?o" ). asNode ();  //例如"1725-04-02"^^<http://www.w3.org/2001/XMLSchema#date>

         if ( needConvert && ors . isLiteral ()) {

//          Literal lit = ors.getLiteral();

            RDFDatatype dt = ors . getLiteralDatatype (); //lit.getDatatype();

             if ( dt != null && dt . getURI (). equals ( "http://www.w3.org/2001/XMLSchema#date" )){ //若是date型数值，将日期提前5天

//              System.out.println(lit.getLexicalForm()+"\t"+lit.getValue()+"\t");

                String [] str = ors . getLiteralLexicalForm (). split ( "-" ); //lit.getLexicalForm().split("-");

                DateTime date = new DateTime ( Integer . valueOf ( str [ 0 ]), Integer . valueOf ( str [ 1 ]), Integer . valueOf ( str [ 2 ]), 0 , 0 , 0 , 0 );

                date = date . minus ( Period . days ( 5 )); //将由jena检索出的日期值向前提5天

                DateTimeFormatter fmt = DateTimeFormat . forPattern ( "yyyy-MM-dd" );

                String dateStr = fmt . print ( date ); //date.getYear()+"-"+date.getMonthOfYear()+"-"+date.getDayOfMonth();

                ors = ResourceFactory . createTypedLiteral ( dateStr , dt ). asNode ();

//              System.out.println(date+"\t"+ors);

             } else if ( dt != null && dt . getURI (). equals ( "http://www.w3.org/2001/XMLSchema#gYear" )){ //若是year型数值，则日期提前5天并只留下年份

//              System.out.println(lit.getLexicalForm()+"\t"+lit.getValue()+"\t");

                String [] str = ors . getLiteralLexicalForm (). split ( "-" ); //.getLexicalForm().split("-");

                DateTime date = new DateTime ( Integer . valueOf ( str [ 0 ]), Integer . valueOf ( str [ 1 ]), Integer . valueOf ( str [ 2 ]), 0 , 0 , 0 , 0 );

                date = date . minus ( Period . days ( 5 )); //将由jena检索出的日期值向前提5天

                String dateStr = date . getYear ()+ "" ; //只留下年份

                ors = ResourceFactory . createTypedLiteral ( dateStr , dt ). asNode ();

//              System.out.println(date+"\t"+lit);

             }       

         }

System.out.println("item:\t"+prs.asResource().getURI()+"\t"+ors);          

pvList . add ( prs . asResource (). getURI (), ors );

     }

    vqeIn . close ();

     return pvList ;

}

本文内容为原创，转载请注明出处：http://blog.csdn.net/xiao_xia_/article/details/78005047