This discussion is archived
14 Replies Latest reply: Sep 19, 2011 12:33 PM by JorgeB-Oracle RSS

Oracle SPARQL Service Endpoint using Joseki not responding

887107 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    how can i check this ?
    thx a lot for your time
  • 7. Re: Oracle SPARQL Service Endpoint using Joseki not responding
    alwu Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    # 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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    Thanks! just one little observation, sdordf.jar should read sdordfclient.jar

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points