10 Replies Latest reply: Sep 20, 2011 5:00 PM by 791225 RSS

    Trouble with DESCRIBE SPARQL queries

    791225
      Hi,

      I'm experiencing some strange behavior when it comes to DESCRIBE queries on my Joseki server with Oracle Spatial backend. When the Weblogic server is newly started the first DESCRIBE query runs through returning the correct result. However after that it only returns an empty graph. SELECTs and CONSTRUCT queries behave deterministic as expected. The SELECTs has been running for a while, but it is first recently that I discovered that I cannot do DESCRIBEs.

      Just for an additional test I copied the Joseki.war to create a second contect Joseki-new.war. When restarting I can run both of these once before they both returns the empty graph.

      I've searched through the logs, but cannot find any indication of what's going on. Help, or indications of where to look, will be highly appreciated.

      Oracle Database Release 11.2 Enterprise Edition, arq-2.8.8.jar, jena-2.6.4.jar, joseki-3.4.4.jar Jena Adapter for Oracle Database 11g Release 2 and Oracle WebLogic Server 11gR1 (10.3.2.0)

      - David
        • 1. Re: Trouble with DESCRIBE SPARQL queries
          alwu-Oracle
          Dear David,

          Could you please go back to the following supported versions for Oracle DB 11.2.0.2?

          ARQ 285, Jena 263, Joseki 3.4.2

          This document has details.
          http://download.oracle.com/docs/cd/E16338_01/appdev.112/e11828/sem_jena.htm

          Please let us know if the same problem exists using the above versions.

          Thanks,

          Zhe Wu
          • 2. Re: Trouble with DESCRIBE SPARQL queries
            791225
            Hi Zhe,

            Thanks for your advices. Unfortunately that did not help. In my second installation I had this exact configuration. Below are a list of my jar files

            arq-2.8.5.jar, iri-0.8-sources.jar, jetty-util-6.1.10.jar, sdb-1.3.2.jar, slf4j-log4j12-1.5.8.jar, arq-2.8.5-sources.jar, jena-2.6.3.jar, joseki-3.4.2.jar, sdordfclient.jar, stax-api-1.0.1.jar
            arq-2.8.5-tests.jar, jena-2.6.3-sources.jar, junit-4.5.jar, sdordf.jar, tdb-0.8.7.jar, arq-2.8.5-test-sources.jar, jena-2.6.3-tests.jar, log4j-1.2.14.jar, servlet-api-2.5-6.1.10.jar, wstx-asl-3.2.9.jar,
            icu4j-3.4.4.jar, jena-2.6.3-test-sources.jar, lucene-core-2.3.1.jar, servlet-api-2.5.jar, xercesImpl-2.7.1.jar, iri-0.8.jar, jetty-6.1.10.jar, ojdbc6.jar, slf4j-api-1.5.8.jar

            My intital query (after restarting weblogic) and the response is

            Davids-MacBook-Pro:local dn$ curl "http://opendata.computas.no:7001/joseki/oracle?query=DESCRIBE+%3Chttp%3A%2F%2Fopendata.computas.no%2Fdata%2Ftellus%2Fprodukt%2F228688%3E"
            <?xml version="1.0"?>
            <rdf:RDF
            xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
            xmlns:j.0="http://opendata.computas.no/voc/tellus/"
            xmlns:j.1="http://purl.org/dc/terms/"
            xmlns:j.2="http://www.w3.org/2006/vcard/"
            xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#">
            <j.0:Product rdf:about="http://opendata.computas.no/data/tellus/produkt/228688">
            <j.1:description xml:lang="en">It is increasingly popular to spend some time and money to indulge onself in a spa or wellness centre. Several places in Oslo offer a wide selection of treatments and facilities.

            In Oslo you can find both day spas and spas in connection with hotels where packages are available.

            Escape from the busy city life and recharge your batteries in luxurious surroundings!</j.1:description>
            <rdfs:seeAlso rdf:resource="http://opendata.computas.no/data/tellus/produkt/2"/>
            <j.1:subject rdf:resource="http://opendata.computas.no/data/tellus-categories/4_935"/>
            <rdfs:seeAlso rdf:resource="http://opendata.computas.no/data/tellus/produkt/1"/>
            <j.1:subject rdf:resource="http://opendata.computas.no/data/tellus-categories/4"/>
            <j.1:description xml:lang="no">Det er stadig mer populært å unne seg en stund med velvære og i Oslo finnes det flere steder som tilbyr et bredt utvalg av behandlinger og fasiliteter.

            Noen av behandlingssentrene er frittstående SPA og velværesentre, mens andre har tilbud i forbindelse med byens hoteller.

            Lad batteriene med et lite avbrekk fra storbyens pulserende liv!
            </j.1:description>
            <j.1:title>Spa og velvære i Oslo</j.1:title>
            <j.2:nsadr rdf:parseType="Resource">
            </j.2:nsadr>
            </j.0:Product>
            </rdf:RDF>

            Then

            Davids-MacBook-Pro:local dn$ curl "http://opendata.computas.no:7001/joseki/oracle?query=DESCRIBE+%3Chttp%3A%2F%2Fopendata.computas.no%2Fdata%2Ftellus%2Fprodukt%2F228688%3E"
            <?xml version="1.0"?>
            <rdf:RDF
            xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
            </rdf:RDF>

            and

            Davids-MacBook-Pro:local dn$ curl "http://opendata.computas.no:7001/joseki/oracle?query=DESCRIBE+%3Chttp%3A%2F%2Fopendata.computas.no%2Fdata%2Ftellus%2Fprodukt%2F228688%3E"
            <?xml version="1.0"?>
            <rdf:RDF
            xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
            </rdf:RDF>

            The logs

            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Servlet.java:67) - -------- Joseki
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:81) - ==== Configuration ====
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:162) - Loading : </usr/weblogic/user_projects/domains/test_domain/autodeploy/joseki.war/joseki-config.ttl>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (ServiceInitSimple.java:25) - Init: Example initializer
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:100) - ==== Datasets ====
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:608) - New dataset: <file:///usr/weblogic/user_projects/domains/test_domain/autodeploy/joseki.war/joseki-config.ttl#oracle>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:102) - ==== Services ====
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:380) - Service reference: "oracle"
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:388) - Class name: org.joseki.processors.SPARQL
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:58) - SPARQL processor
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:103) - Locking policy: none
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:114) - Dataset description: true // Web loading: true
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:486) - Dataset: <file:///usr/weblogic/user_projects/domains/test_domain/autodeploy/joseki.war/joseki-config.ttl#oracle>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:104) - ==== Bind services to the server ====
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:519) - Service: <oracle>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:106) - ==== Initialize datasets ====
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SimpleLog.java:63) - startMonitor: starts
            <Sep 20, 2011 9:27:11 PM CEST> <Info> <Common> <BEA-000628> <Created "1" resources for pool "OracleSemDS", out of which "1" are available and "0" are unavailable.>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (DatasetDesc.java:57) - Pool size 1 for dataset <file:///usr/weblogic/user_projects/domains/test_domain/autodeploy/joseki.war/joseki-config.ttl#oracle>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Configuration.java:120) - ==== End Configuration ====
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Dispatcher.java:133) - Loaded data source configuration: /usr/weblogic/user_projects/domains/test_domain/autodeploy/joseki.war/joseki-config.ttl
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Servlet.java:164) - [84.215.161.106] Service URI = <oracle>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:229) - Query: DESCRIBE <http://opendata.computas.no/data/tellus/produkt/228688>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:330) - OK/describe: DESCRIBE <http://opendata.computas.no/data/tellus/produkt/228688>
            <Sep 20, 2011 9:27:21 PM CEST> <Info> <Health> <BEA-310002> <85% of the total memory in the server is free>
            INFO [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] (Servlet.java:164) - [84.215.161.106] Service URI = <oracle>
            INFO [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:229) - Query: DESCRIBE <http://opendata.computas.no/data/tellus/produkt/228688>
            INFO [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:330) - OK/describe: DESCRIBE <http://opendata.computas.no/data/tellus/produkt/228688>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (Servlet.java:164) - [84.215.161.106] Service URI = <oracle>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:229) - Query: DESCRIBE <http://opendata.computas.no/data/tellus/produkt/228688>
            INFO [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:330) - OK/describe: DESCRIBE <http://opendata.computas.no/data/tellus/produkt/228688>


            The only difference I see is the "<Sep 20, 2011 9:27:21 PM CEST> <Info> <Health> <BEA-310002> <85% of the total memory in the server is free>" never shows up after the first query.

            Any construct query returns the correct result and the log shows

            INFO [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:229) - Query: CONSTRUCT {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o} WHERE {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o}
            INFO [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:322) - OK/construct: CONSTRUCT {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o} WHERE {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o}
            INFO [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] (Servlet.java:164) - [84.215.161.106] Service URI = <oracle>
            INFO [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:229) - Query: CONSTRUCT {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o} WHERE {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o}
            INFO [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] (SPARQL.java:322) - OK/construct: CONSTRUCT {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o} WHERE {<http://opendata.computas.no/data/tellus/produkt/228688> ?p ?o}

            Hope you can help me.

            Regards,
            David

            Edited by: user10789242 on Sep 20, 2011 1:20 PM
            • 3. Re: Trouble with DESCRIBE SPARQL queries
              791225
              Just to add to this, my joseki.ttl is


              @prefix oracle: <http://www.oracle.com/2009/05/orardf/jena-joseki-ns#> .
              @prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
              @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
              @prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
              @prefix module: <http://joseki.org/2003/06/module#> .
              @prefix joseki: <http://joseki.org/2005/06/configuration#> .
              @prefix ja: <http://jena.hpl.hp.com/2005/11/Assembler#> .



              <> rdfs:label "Joseki Configuration File" .

              <#server> rdf:type joseki:Server ;
              joseki:initialization
              [ module:implementation
              [ module:className <java:org.joseki.util.ServiceInitSimple> ;
              rdfs:label "Example initializer" ; ]
              ] ;
              .

              <#service2>
              rdf:type joseki:Service ;
              rdfs:label "SPARQL with Oracle Semantic Data Management" ;
              joseki:serviceRef "oracle" ; # web.xml must route this name to Joseki
              joseki:dataset <#oracle> ;
              joseki:processor joseki:ProcessorSPARQL ;
              .

              [] ja:loadClass "oracle.spatial.rdf.client.jena.assembler.OracleAssemblerVocab" .

              oracle:Dataset rdfs:subClassOf ja:RDFDataset .

              <#oracle> rdf:type oracle:Dataset;
              joseki:poolSize 1 ; ## Number of concurrent connections allowed to this dataset.
              oracle:connection
              [ a oracle:OracleConnection ;
              ];
              oracle:defaultModel [ oracle:firstModel "TOURISM_1";
              oracle:modelName "EEA_RIVERS";
              oracle:modelName "BYGGESAK_OSLO";
              oracle:modelName "BYGNINGER";
              oracle:modelName "FOURSQUARE_TOPICS";
              oracle:modelName "TELLUS";
              oracle:modelName "LADESTASJONER";
              oracle:modelName "FOURSQUARE_VENUES";
              oracle:modelName "ARTSOBSERVASJONER";
              oracle:modelName "BLAASKJELL";
              oracle:modelName "SURVEILANCE";
              oracle:modelName "GRASROTANDELEN";
              oracle:modelName "BORGERKANALEN";
              oracle:modelName "PORSGRUNN_MINGATE";
              oracle:modelName "NFR_PROSJEKTARKIV";
              oracle:modelName "DIFI_LOS";
              oracle:modelName "DIFI_TJENESTEMANN";
              oracle:modelName "TURISTFORENINGEN";
              oracle:modelName "NORAD";
              oracle:modelName "PEOPLE";
              oracle:useVM "TRUE" ] ;
              oracle:namedModel [ oracle:namedModelURI <http://opendata.computas.no/dataset/byggesak_oslo>;  oracle:firstModel "BYGGESAK_OSLO"  ] ;
              oracle:namedModel [ oracle:namedModelURI <http://opendata.computas.no/dataset/tourism_1>; oracle:firstModel "TOURISM_1"    ] ;
              oracle:namedModel [ oracle:namedModelURI <http://opendata.computas.no/dataset/eea_rivers>; oracle:firstModel "EEA_RIVERS"    ] ;
              oracle:namedModel [ oracle:namedModelURI <http://opendata.computas.no/dataset/bygninger>; oracle:firstModel "BYGNINGER"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/tellus>; oracle:firstModel "TELLUS"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/ladestasjoner>; oracle:firstModel "LADESTASJONER"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/foursquare_venues>; oracle:firstModel "FOURSQUARE_VENUES"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/artsobservasjoner>; oracle:firstModel "ARTSOBSERVASJONER"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/blaaskjell>; oracle:firstModel "BLAASKJELL"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/surveilance>; oracle:firstModel "SURVEILANCE"     ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/grasrotandelen>; oracle:firstModel "GRASROTANDELEN"     ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/foursquare_topics>; oracle:firstModel "FOURSQUARE_TOPICS"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/borgerkanalen>; oracle:firstModel "BORGERKANALEN"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/porsgrunn_mingate>; oracle:firstModel "PORSGRUNN_MINGATE"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/nfr_prosjektarkiv>; oracle:firstModel "NFR_PROSJEKTARKIV"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/difi_los>; oracle:firstModel "DIFI_LOS"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/difi_tjenestemannsregisteret> ; oracle:firstModel "DIFI_TJENESTEMANN"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/turistforeningen> ; oracle:firstModel "TURISTFORENINGEN"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/norad> ; oracle:firstModel "NORAD"    ] ;
              oracle:namedModel [oracle:namedModelURI <http://opendata.computas.no/dataset/people> ; oracle:firstModel "PEOPLE"    ] .

              joseki:ProcessorSPARQL
              rdfs:label "General SPARQL processor" ;
              rdf:type joseki:Processor ;
              module:implementation joseki:ImplSPARQL ;
              joseki:allowExplicitDataset "true"^^xsd:boolean ;
              joseki:allowWebLoading "true"^^xsd:boolean ;
              joseki:lockingPolicy joseki:lockingPolicyNone ;
              .

              joseki:ImplSPARQL
              rdf:type joseki:ServiceImpl ;
              module:className
              <java:org.joseki.processors.SPARQL> .


              - David
              • 4. Re: Trouble with DESCRIBE SPARQL queries
                791225
                Hi again,

                I decided to try to make a pure Java example as well, building on the example from the documentation (Example 7-12 SPARQL DESCRIBE Query) [1] to take the query as an additional argument:

                java -cp .:WEB-INF/lib/arq-2.8.5.jar:WEB-INF/lib/icu4j-3.4.4.jar:WEB-INF/lib/iri-0.8.jar:WEB-INF/lib/jena-2.6.3.jar:WEB-INF/lib/joseki-3.4.2.jar:WEB-INF/lib/log4j-1.2.14.jar:WEB-INF/lib/ojdbc6.jar:WEB-INF/lib/sdordfclient.jar:WEB-INF/lib/slf4j-api-1.5.8.jar:WEB-INF/lib/slf4j-log4j12-1.5.8.jar:WEB-INF/lib/xercesImpl-2.7.1.jar TestDescribe jdbc:oracle:thin:@localhost:1521:lod semantic2 AliBaba_04 TELLUS "DESCRIBE <http://opendata.computas.no/data/tellus/produkt/415586>"

                describe result = <ModelCom {-c80b51:13283b73add:-5d3 @http://www.w3.org/TR/owl-time#hasEnd -c80b51:13283b73add:-5d1; -c80b51:13283b73add:-5d3 @http://www.w3.org/TR/owl-time#hasBeginning -c80b51:13283b73add:-5d2; -c80b51:13283b73add:-5d3 @http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.w3.org/TR/owl-time#Interval; -c80b51:13283b73add:-5cf @http://www.w3.org/TR/owl-time#inXSDDateTime "20:00"; -c80b51:13283b73add:-5cf @http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.w3.org/TR/owl-time#Instance; -c80b51:13283b73add:-5d1 @http://www.w3.org/TR/owl-time#inXSDDateTime "04.10.2011"; -c80b51:13283b73add:-5d1 @http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.w3.org/TR/owl-time#Instance; -c80b51:13283b73add:-5d6 @http://www.w3.org/2003/01/geo/wgs84_pos#lat "60.3888679"; -c80b51:13283b73add:-5d6 @http://www.w3.org/2003/01/geo/wgs84_pos#long "5.3273686999"; -c80b51:13283b73add:-5d6 @http://www.w3.org/2000/01/rdf-schema#label "Edvard Griegsplass 1"; -c80b51:13283b73add:-5d6 @http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://dbpedia.org/ontology/Place; -c80b51:13283b73add:-5d6 @http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://www.w3.org/2003/01/geo/wgs84_pos#Point; -c80b51:13283b73add:-5cd @http://purl.org/goodrelations/v1#hasCurrencyValue "250,00"; -c80b51:13283b73add:-5cd @http://purl.org/goodrelations/v1#validFrom "04.10.2011"; -c80b51:13283b73add:-5cd @http://purl.org/goodrelations/v1#validThrough "04.10.2011"; -c80b51:13283b73add:-5cd @http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://purl.org/goodrelations/v1#PriceSpecification; -c80b51:13283b73add:-5cd @http://purl.org/goodrelations/v1#hasCurrency "NOK"...} | >

                java -cp .:WEB-INF/lib/arq-2.8.5.jar:WEB-INF/lib/icu4j-3.4.4.jar:WEB-INF/lib/iri-0.8.jar:WEB-INF/lib/jena-2.6.3.jar:WEB-INF/lib/joseki-3.4.2.jar:WEB-INF/lib/log4j-1.2.14.jar:WEB-INF/lib/ojdbc6.jar:WEB-INF/lib/sdordfclient.jar:WEB-INF/lib/slf4j-api-1.5.8.jar:WEB-INF/lib/slf4j-log4j12-1.5.8.jar:WEB-INF/lib/xercesImpl-2.7.1.jar TestDescribe jdbc:oracle:thin:@localhost:1521:lod semantic2 AliBaba_04 TELLUS "DESCRIBE <http://opendata.computas.no/data/tellus/produkt/415586>"

                describe result = <ModelCom {} | >

                Again the same result, first try gives the expected results, second returns an empty model.

                Hope someone can put me in the right direction.

                Best Regards,
                David


                [1] Jena Adapter for Oracle Database, http://download.oracle.com/docs/cd/E16338_01/appdev.112/e11828/sem_jena.htm#CBBCDBJH
                • 5. Re: Trouble with DESCRIBE SPARQL queries
                  791225
                  One additional relevant information; I found out that we were running Oracle EE 11.2.0.1.0.

                  - David
                  • 6. Re: Trouble with DESCRIBE SPARQL queries
                    alwu-Oracle
                    Hi David,

                    I cannot reproduce.

                    In my local Joseki setup, I run the following many times and each time I got the same, non-empty response.

                    http://127.0.0.1:7001/joseki/oracle?query=describe+%3Chttp%3A%2F%2Flocalhost%3A7001%2Ffiles%2Foverstock%2Fproduct.html%23product%3E%0D%0A&stylesheet=%2Fjoseki%2Fxml-to-html.xsl

                    Thanks,

                    Zhe Wu
                    • 7. Re: Trouble with DESCRIBE SPARQL queries
                      791225
                      Hi agin Zhe,

                      That's too bad. At least based on the stand-alone example I can rule out WebLogic and Joseki configuration. Could it be related to the version of the database I'm running? Would you recommend that I upgrade? Otherwise I guess I'll have to reinstall Oracle anew :/.

                      - David
                      • 8. Re: Trouble with DESCRIBE SPARQL queries
                        alwu-Oracle
                        Also, I run the following Java test code multiple times.

                        public void testMultiDescribe(String jdbcUrl, String user,
                        String password, String modelName,
                        PrintStream psOut)
                        throws SQLException
                        {
                        Oracle oracle = new Oracle(jdbcUrl, user, password);

                        // GraphOracleSem graph = new GraphOracleSem(oracle, modelName);
                        GraphOracleSem graph = new GraphOracleSem(oracle, modelName, false);
                        ModelOracleSem model = new ModelOracleSem(graph);

                        Node sub = Node.createURI("http://sub/a");
                        Node pred = Node.createURI("http://pred/a");
                        Node obj = Node.createURI("http://obj/a");

                        Triple triple = Triple.create(sub, pred, obj);
                        graph.add(triple);

                        obj = Node.createURI("http://obj/ayyy");
                        triple = Triple.create(sub, pred, obj);
                        graph.add(triple);

                        {
                        String queryString = " DESCRIBE <http://sub/a> ";

                        for (int repeat = 1; repeat <= 3; repeat++ ) {
                        Query query = QueryFactory.create(queryString);
                        QueryExecution qexec = QueryExecutionFactory.create(query, model);
                        Model m = qexec.execDescribe();
                        psOut.println("testDescribe 1: " + m.toString());
                        }
                        }

                        graph.close();
                        oracle.dispose();
                        }

                        Execution results:

                        testDescribe 1: <ModelCom {http://sub/a @http://pred/a http://obj/a; http://sub/a @http://pred/a http://obj/ayyy} | >
                        testDescribe 1: <ModelCom {http://sub/a @http://pred/a http://obj/a; http://sub/a @http://pred/a http://obj/ayyy} | >
                        testDescribe 1: <ModelCom {http://sub/a @http://pred/a http://obj/a; http://sub/a @http://pred/a http://obj/ayyy} | >


                        Again, the results are consistent.
                        • 9. Re: Trouble with DESCRIBE SPARQL queries
                          alwu-Oracle
                          Hi David,

                          Please upgrade to Oracle Database Release 11.2.0.2. It is required for the version of Jena Adapter you are using.

                          Thanks,

                          Zhe Wu
                          • 10. Re: Trouble with DESCRIBE SPARQL queries
                            791225
                            Thanks, I'll give it a try.

                            - david