14 Replies Latest reply: Sep 19, 2011 2:33 PM by JorgeB-Oracle RSS

    Oracle SPARQL Service Endpoint using Joseki not responding

    887107
      Hello, i have just installed Oracle Database Release 11.2 Enterprise Edition, jena-2.6.2, joseki-3.4.0.jar Jena Adapter for Oracle Database 11g Release 2 (11.2.0.2 ) and Oracle WebLogic Server 11gR1 (10.3.4)
      as the http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11828/sem_jena.htm says. but when i go to http://localhost:7001/joseki/ and i press Submit Query the page does nothing:"Connecting waiting for LocalHost"(Browser).from the http://localhost:7001/console i can see that the deployment receive the requests
      Name      Server      Application      Pending Requests      Completed Requests
      default     AdminServer     joseki     12     20.
      if anyone can help i would be greatfull.
      thx a lot
        • 1. Re: Oracle SPARQL Service Endpoint using Joseki not responding
          alwu-Oracle
          Hi,

          A couple of questions.

          1) Did you initialize the semantic network?

          2) Did you setup the OracleSemDS data source?

          Thanks,

          Zhe
          • 2. Re: Oracle SPARQL Service Endpoint using Joseki not responding
            887107
            Hi alwu, thx for the reply
            yes i install the semantic network and the OracleSemDS data source is active and running.
            • 3. Re: Oracle SPARQL Service Endpoint using Joseki not responding
              alwu-Oracle
              Hi,

              Is there any additional diagnostic information you can share? Are there relevant logs from WLS?

              Thanks,

              Zhe
              • 4. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                887107
                hi againa...
                i noticed one that
                Sep 9, 2011 10:47:02 PM EEST     netuix     Error     BEA-423137     There was an error loading the requested URI /jsp/core/domain/DomainMonitorHealthForm.jsp.
                Sep 9, 2011 10:47:32 PM EEST     netuix     Warning     BEA-423420     Redirect is executed in begin or refresh action. Redirect url is /console/console.portal?_nfpb=true&_pageLabel=DiagnosticsViewServerLogTablePage&DiagnosticsViewServerLogTablePortlethandle=com.bea.console.handles.LogDispatchHandle%28%22AdminServer%3BServerLog%22%29.

                Sep 9, 2011 10:47:02 PM EEST     Console     Error     BEA-240003     Console encountered the following error Exception during RequestDispatcher.include(). Throwable: javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: The element type "input" must be terminated by the matching end-tag "</input>". Stack Trace: javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: The element type "input" must be terminated by the matching end-tag "</input>". at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:719) at com.sun.org.apache.xalan.internal.xsltc.trax.TransformerImpl.transform(TransformerImpl.java:313) at com.bea.console.taglib.html.TemplateTag.doAfterBody(TemplateTag.java:105) at jsp_servlet._jsp._core._domain.__domainmonitorhealthform._jsp__tag5(__domainmonitorhealthform.java:543) at jsp_servlet._jsp._core._domain.__domainmonitorhealthform._jsp__tag4(__domainmonitorhealthform.java:489) at jsp_servlet._jsp._core._domain.__domainmonitorhealthform._jspService(__domainmonitorhealthform.java:145) at weblogic.servlet.jsp.JspBase.service(JspBase.java:35) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300) at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:417) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:326) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)

                AND SO ON

                Sep 9, 2011 10:47:02 PM EEST     netuix     Error     BEA-423405     An exception [javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: The element type "input" must be terminated by the matching end-tag "</input>".] was thrown while rendering the content at [jsp/core/domain/DomainMonitorHealthForm.jsp]. javax.servlet.ServletException: javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: com.sun.org.apache.xml.internal.utils.WrappedRuntimeException: The element type "input" must be terminated by the matching end-tag "</input>". at weblogic.servlet.jsp.PageContextImpl.handlePageException(PageContextImpl.java:417) at jsp_servlet._jsp._core._domain.__domainmonitorhealthform._jspService(__domainmonitorhealthform.java:334) at weblogic.servlet.jsp.JspBase.service(JspBase.java:34) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300) at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:417) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:326) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184) at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:523) at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:444) at org.apache.beehive.netui.pageflow.scoping.internal.ScopedRequestDispatcher.include(ScopedRequestDispatcher.java:119)

                AND SO ON

                     Sep 9, 2011 10:47:02 PM EEST     netuix     Error     BEA-423137     There was an error loading the requested URI /jsp/core/domain/DomainMonitorHealthForm.jsp.
                • 5. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                  alwu-Oracle
                  Hi,

                  That error message seems to be related to "/jsp/core/domain/DomainMonitorHealthForm.jsp"
                  Does that JSP use the Joseki endpoint? If not, then it may not be relevant.

                  Thanks,

                  Zhe
                  • 6. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                    887107
                    how can i check this ?
                    thx a lot for your time
                    • 7. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                      alwu-Oracle
                      Hi,

                      If you did not implement that jsp then chances are that is not relevant.

                      Does it help if you change localhost to the real IP, or 127.0.0.1, or the hostname?

                      If it does not help, then please share the data source configuration and your joseki-config.ttl.

                      Thanks,

                      Zhe
                      • 8. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                        887107
                        # This file is written in N3 / Turtle

                        @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#> .

                        ## --------------------------------------------------------------
                        ## This file is written in N3 / Turtle
                        ## It is an RDF graph - order of RDF triples does not matter
                        ## to the machine but it does help people who need to edit this file.

                        ## Note: web.xml must be in-step with this file.
                        ## for each service,

                        ## Note: adding rdfs:label to blank nodes will cause Joseki
                        ## to print that in log messages.

                        ## See also file:joseki-config-example.ttl


                        ## --------------------------------------------------------------
                        ## About this configuration

                        <> rdfs:label "Joseki Configuration File" .

                        ## --------------------------------------------------------------
                        ## About this server

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

                        ## --------------------------------------------------------------
                        ## Services

                        ## Services are the points that request are sent to.
                        ## serviceRef that will be used to match requests to services,
                        ## not some resource URI for the description.

                        ## Note that the service reference and the routing of incoming
                        ## requests by URI as defined by web.xml have to align.

                        # Service 1
                        # General purpose SPARQL processor, no dataset, expects the
                        # request to specify the dataset (either by parameters in the
                        # protocol request or in the query itself).

                        <#service1>
                        rdf:type joseki:Service ;
                        rdfs:label "service point" ;
                        joseki:serviceRef "sparql" ; # web.xml must route this name to Joseki
                        joseki:processor joseki:ProcessorSPARQL ;
                        .

                        # Service 2 - SPARQL processor only handling a given dataset
                        <#service2>
                        rdf:type joseki:Service ;
                        rdfs:label "SPARQL with Oracle Semantic Data Management" ;
                        joseki:serviceRef "oracle" ; # web.xml must route this name to Joseki
                        # dataset part
                        joseki:dataset <#oracle> ;
                        # Service part.
                        # This processor will not allow either the protocol,
                        # nor the query, to specify the dataset.
                        joseki:processor joseki:ProcessorSPARQL_FixedDS ;
                        .

                        ## ---- SPARQL/Update
                        ## A pair of services - one for SPARQL queries, one for SPARQL/Update
                        ## Previous web.xml must also be updated to include a defintion for the
                        ## servlet "SPARQL/Update service processor" and update requests must
                        ## be routed to this servlet.


                        ### <#serviceUpdate>
                        ### rdf:type joseki:Service ;
                        ### rdfs:label "SPARQL/Update" ;
                        ### joseki:serviceRef "update/service" ;
                        ### # dataset part
                        ### joseki:dataset <#oracle>;
                        ### # Service part.
                        ### # This processor will not allow either the protocol,
                        ### # nor the query, to specify the dataset.
                        ### joseki:processor joseki:ProcessorSPARQLUpdate
                        ### .
                        ###
                        ### <#serviceRead>
                        ### rdf:type joseki:Service ;
                        ### rdfs:label "SPARQL" ;
                        ### joseki:serviceRef "sparql/read" ;
                        ### # dataset part
                        ### joseki:dataset <#oracle> ; ## Same dataset
                        ### # Service part.
                        ### # This processor will not allow either the protocol,
                        ### # nor the query, to specify the dataset.
                        ### joseki:processor joseki:ProcessorSPARQL_FixedDS ;
                        ### .

                        ## --------------------------------------------------------------
                        ## Datasets
                        #
                        [] 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 "M1" ] .
                        # oracle:defaultModel [ oracle:firstModel "ABOX"; oracle:modelName "TBOX"; oracle:rulebaseName "OWLPRIME";
                        # oracle:useVM "TRUE"
                        # ] .


                        ## --------------------------------------------------------------
                        ## Processors

                        joseki:ProcessorSPARQL
                        rdfs:label "General SPARQL processor" ;
                        rdf:type joseki:Processor ;
                        module:implementation joseki:ImplSPARQL ;

                        # Parameters - this processor processes FROM/FROM NAMED
                        joseki:allowExplicitDataset "true"^^xsd:boolean ;
                        joseki:allowWebLoading "true"^^xsd:boolean ;
                        ## And has no locking policy (it loads data each time).
                        ## The default is mutex (one request at a time)
                        joseki:lockingPolicy joseki:lockingPolicyNone ;
                        .

                        joseki:ProcessorSPARQL_FixedDS
                        rdfs:label "SPARQL processor for fixed datasets" ;
                        rdf:type joseki:Processor ;
                        module:implementation joseki:ImplSPARQL ;

                        # This processor does not accept queries with FROM/FROM NAMED
                        joseki:allowExplicitDataset "false"^^xsd:boolean ;
                        joseki:allowWebLoading "false"^^xsd:boolean ;
                        joseki:lockingPolicy joseki:lockingPolicyMRSW ;
                        .

                        joseki:ProcessorSPARQLUpdate
                        rdfs:label "SPARQL Udpate processor" ;
                        rdf:type joseki:Processor ;
                        module:implementation joseki:ImplSPARQLUpdate ;
                        joseki:lockingPolicy joseki:lockingPolicyMRSW ;
                        .

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

                        joseki:ImplSPARQLUpdate
                        rdf:type joseki:ServiceImpl ;
                        module:className
                        <java:org.joseki.processors.SPARQLUpdate> .

                        # Local Variables:
                        # tab-width: 4
                        # indent-tabs-mode: nil
                        # End:
                        • 9. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                          887107
                          General Tab
                          Name:     OracleSemDS
                          JNDI Name: OracleSemDS
                          Stream Chunk Size:256
                          Connection Pool Tab
                          URL:jdbc:oracle:thin:@localhost:1521:orcl
                          Driver Class Name:     oracle.jdbc.OracleDriver
                          Properties:user=Kostas
                          Initial Capacity:1
                          Maximum Capacity:     15
                          Capacity Increment:1
                          Statement Cache Type:LRU
                          Statement Cache Size:10
                          In oracle tab nothing is selected
                          In ons tab the same
                          in Transcaction tab Supports Global Transactions is seleceted and One-Phase Commit
                          diagnostics tab
                          Profile Harvest Frequency Seconds:     300 and nothing is selected
                          • 10. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                            887107
                            Hi, i copy the information showing at cmd after opening the weblogic server and after opening and running Joseki Console
                            the first file is that with the startup http://www.fileserve.com/file/nU9CakN/start.txt
                            and the second is after running se query at Joseki form.
                            http://www.fileserve.com/file/HCjBBEW/after_joseki.txt

                            thx a lot for your Help!!!
                            • 11. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                              alwu-Oracle
                              Hi,

                              Could you please email me these two text files? It is easier for me to access behind Oracle firewall.
                              My email is alan dot wu at oracle dot com.

                              I have read your data source definition. I have two questions.

                              1) When you created the data source, there should be a button "Test Configuration" in WLS admin console, did you click on it? I noticed that you use "localhost" in your JDBC URL, so this means your DB and WLS are on the same machine?

                              2) In the last step of creating a data source, there is a Select Targets page. Did you choose a server to deploy the data source? Without it, the data source will be created but not deployed.


                              Thanks,

                              Zhe Wu
                              • 12. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                                887107
                                Hi!!
                                1)yes the DB and the Weblogic Server are in the same.I push the button "Test Configuration" and it says that it's ok!!!

                                2)at Select Targets page i choose AdminServer if this helps you!!


                                ps: i mail the files
                                thx a lot
                                • 13. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                                  887107
                                  First of all i would like to thanks Zhe and Jorge for the time and for helping me.
                                  i followed http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_jena.htm to install Oracle 11g and Semantic technologies with Jena adapter.
                                  i would like to metion one mistake that there is on the post.
                                  On 7.2 section the post says that we must have on the ./joseki.war/WEB-INF/lib: directory jena-2.6.2.jar and jenatest-2.6.2.jar.
                                  the correct files are jena-2.6.0.jar jenatest-2.6.0.jar.that is the one problem i had.The other problem is that i didn't enable the semantic technologies as it says at the http://download.oracle.com/docs/cd/E18283_01/appdev.112/e11828/sem_enable.htm#CHDHEABD chapter.
                                  Another problem is that at my autodeployment folder (previous versions i installed ) there was other version of sdordf.jar files. if you have problems like mine i would suggest you to search at Middleware folder for sdordf.jar and delete the other sdordf.jar that exist except from the one at your Joseki.war autodeployment.
                                  thx a lot Zhe and Jorge.
                                  • 14. Re: Oracle SPARQL Service Endpoint using Joseki not responding
                                    JorgeB-Oracle
                                    Thanks! just one little observation, sdordf.jar should read sdordfclient.jar