4 Replies Latest reply on Dec 19, 2016 8:23 PM by alwu-Oracle

    Problem querying in <Oracle SPARQL Service Endpoint using Joseki> after to Setup the file 'joseki-config.ttl'

    yenier

      Hi:

      I need to run an Oracle SPARQL Service Endpoint using Joseki. I'm using JBOSS EAP 7.1 and configured the Application Server as https://docs.oracle.com/database/121/RDFRM/GUID-A18AD59B-10B6-41E3-8791-EF9A8DE4A1F6.htm#RDFRM745.

       

      I execute the JBOSS Application Server without problems, but when I configure the file joseki-config.ttl with the model name and I try to execute a query, the query does not return and in logs it's possible read the following:

       

      13:27:56,834 INFO  [org.joseki.Configuration] (http--127.0.0.1-8080-1) ==== Initialize datasets ====

      13:27:57,040 INFO  [oracle.spatial.rdf.client.jena.OracleQueryProgressMonitor] (http--127.0.0.1-8080-1) startMonitor: starts

      13:27:57,560 WARN  [org.joseki.Configuration] (http--127.0.0.1-8080-1) Failed to build dataset from description (service name: update/service): caught: java.sql

      .SQLSyntaxErrorException: ORA-01031: insufficient privileges: com.hp.hpl.jena.assembler.exceptions.AssemblerException: caught: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

       

       

        doing:   

      root: file:///C:/Users/Yenier/joseki-config.ttl#oracle with type: http://www.oracle.com/2009/05/orardf/jena-joseki-ns#Dataset assembler class: class oracle.spatial.rdf.client.jena.assembler.OracleDatasetAssembler

       

       

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.openBySpecificType(AssemblerGroup.java:138) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.open(AssemblerGroup.java:117) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$ExpandingAssemblerGroup.open(AssemblerGroup.java:81) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerBase.open(AssemblerBase.java:52) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerBase.open(AssemblerBase.java:48) [jena-core-2.11.2.jar:2.11.2]

              at org.joseki.DatasetDesc.newDataset(DatasetDesc.java:101) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.DatasetDesc.initialize(DatasetDesc.java:93) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Configuration.processModel(Configuration.java:125) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Configuration.<init>(Configuration.java:99) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Dispatcher.setConfiguration(Dispatcher.java:140) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Dispatcher.initServiceRegistry(Dispatcher.java:112) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.http.Servlet.init(Servlet.java:121) [joseki-3.4.4-oraclebuild.jar:]

              at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:952) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:188) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489) [jbossweb-7.0.13.Final.jar:]

              at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

       

       

              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

              at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

              at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

              at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

              at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]

      Caused by: com.hp.hpl.jena.shared.JenaException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges:

              at oracle.spatial.rdf.client.jena.Oracle.<init>(Oracle.java:173) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.assembler.OracleConnectionAssembler.open(OracleConnectionAssembler.java:114) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.assembler.OracleDatasetAssembler.open(OracleDatasetAssembler.java:73) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.assembler.OracleDatasetAssembler.open(OracleDatasetAssembler.java:51) [sdordfclient_12c.jar:]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.openBySpecificType(AssemblerGroup.java:130) [jena-core-2.11.2.jar:2.11.2]

              ... 25 more

      Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges:

       

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:205) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1043) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4755) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378) [ojdbc6.jar:11.2.0.4.0]

              at oracle.spatial.rdf.client.jena.Oracle.executeCall(Oracle.java:813) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.OracleSqlGenerator.loadPackages(OracleSqlGenerator.java:119) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.OracleUtils.addHelperFunctions(OracleUtils.java:1176) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.Oracle.<init>(Oracle.java:170) [sdordfclient_12c.jar:]

              ... 29 more

       

       

      13:27:57,650 WARN  [org.joseki.Configuration] (http--127.0.0.1-8080-1) Failed to build dataset from description (service name: oracle): caught: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges: com.hp.hpl.jena.assembler.exceptions.AssemblerException: caught: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges:

       

       

        doing:

          root: file:///C:/Users/Yenier/joseki-config.ttl#oracle with type: http://www.oracle.com/2009/05/orardf/jena-joseki-ns#Dataset assembler class: class oracle.

      spatial.rdf.client.jena.assembler.OracleDatasetAssembler

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.openBySpecificType(AssemblerGroup.java:138) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.open(AssemblerGroup.java:117) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$ExpandingAssemblerGroup.open(AssemblerGroup.java:81) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerBase.open(AssemblerBase.java:52) [jena-core-2.11.2.jar:2.11.2]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerBase.open(AssemblerBase.java:48) [jena-core-2.11.2.jar:2.11.2]

              at org.joseki.DatasetDesc.newDataset(DatasetDesc.java:101) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.DatasetDesc.initialize(DatasetDesc.java:93) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Configuration.processModel(Configuration.java:125) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Configuration.<init>(Configuration.java:99) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Dispatcher.setConfiguration(Dispatcher.java:140) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.Dispatcher.initServiceRegistry(Dispatcher.java:112) [joseki-3.4.4-oraclebuild.jar:]

              at org.joseki.http.Servlet.init(Servlet.java:121) [joseki-3.4.4-oraclebuild.jar:]

              at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1202) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:952) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:188) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:489) [jbossweb-7.0.13.Final.jar:]

              at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

       

       

              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

              at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

              at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

              at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

              at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79]

      Caused by: com.hp.hpl.jena.shared.JenaException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges:

       

       

              at oracle.spatial.rdf.client.jena.Oracle.<init>(Oracle.java:173) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.assembler.OracleConnectionAssembler.open(OracleConnectionAssembler.java:114) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.assembler.OracleDatasetAssembler.open(OracleDatasetAssembler.java:73) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.assembler.OracleDatasetAssembler.open(OracleDatasetAssembler.java:51) [sdordfclient_12c.jar:]

              at com.hp.hpl.jena.assembler.assemblers.AssemblerGroup$PlainAssemblerGroup.openBySpecificType(AssemblerGroup.java:130) [jena-core-2.11.2.jar:2.11.2]

              ... 25 more

      Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges:

       

       

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:205) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1043) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4755) [ojdbc6.jar:11.2.0.4.0]

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378) [ojdbc6.jar:11.2.0.4.0]

              at oracle.spatial.rdf.client.jena.Oracle.executeCall(Oracle.java:813) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.OracleSqlGenerator.loadPackages(OracleSqlGenerator.java:119) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.OracleUtils.addHelperFunctions(OracleUtils.java:1176) [sdordfclient_12c.jar:]

              at oracle.spatial.rdf.client.jena.Oracle.<init>(Oracle.java:170) [sdordfclient_12c.jar:]

              ... 29 more

       

       

      13:27:57,699 INFO  [org.joseki.Configuration] (http--127.0.0.1-8080-1) ==== EndConfiguration ====

      13:27:57,701 INFO  [org.joseki.Dispatcher] (http--127.0.0.1-8080-1) Loaded datasource configuration: joseki-config.ttl

      What can I do?

       

      Thank you so much,

       

      Yenier