This discussion is archived
2 Replies Latest reply: Nov 22, 2011 12:34 PM by 796925 RSS

strange error straight after model creation

796925 Newbie
Currently Being Moderated
Hi

we are having a problem with one of our customers who has two similarly set up Oracle 11.1.0.7 RAC systems (development and production).

The version of the Oracle Jena adapter being used is one we received from Oracle on 3/18/11, including a file labelled timestamp_build_20110208

In this particular customer setup (as for most of our deployments) it is hard to update to the latest driver because of Jena incompatibilities.

They are using some code from us that calls the Oracle Jena adapter - the code works on the development system, and not on the production system.

We create a new OracleGraph using

new GraphOracleSem(oracle, modelName, erase)

and then to sanity check, perform a simple find against it using

ExtendedIterator<Triple> dit =
graph.find(null, RDF.type.asNode(), OWL.Ontology.asNode());
dit.close();


on one of the systems this works fine, as expected; on the other we get a JenaException, wrapping an SQLException as below, and our code gives up.


Please advise as to what the error message means, and what we should do about it, and how the two systems might differ.
Thanks

Jeremy


!STACK 0

java.sql.SQLException: ORA-20000: RDF_MATCH Query pattern must be a non-null compile-time constant.

ORA-06512: at "MDSYS.RDF_MATCH_IMPL_T", line 63

ORA-06512: at line 4

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

at oracle.spatial.rdf.client.jena.Oracle.executeQuery(Oracle.java:430)

at oracle.spatial.rdf.client.jena.Oracle.executeQuery(Oracle.java:374)

at oracle.spatial.rdf.client.jena.Oracle.executeQuery(Oracle.java:366)

at oracle.spatial.rdf.client.jena.Oracle.executeQuery(Oracle.java:354)

at oracle.spatial.rdf.client.jena.Oracle.executeQuery(Oracle.java:339)

at oracle.spatial.rdf.client.jena.Oracle.executeQuery(Oracle.java:314)

at oracle.spatial.rdf.client.jena.GraphOracleSem.executeFindQuery(GraphOracleSem.java:4169)

at oracle.spatial.rdf.client.jena.GraphOracleSem.graphBaseFind(GraphOracleSem.java:3181)

at oracle.spatial.rdf.client.jena.GraphOracleSem.graphBaseFind(GraphOracleSem.java:2475)

at oracle.spatial.rdf.client.jena.GraphOracleSem.graphBaseFind(GraphOracleSem.java:2479)

at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:240)

at com.hp.hpl.jena.graph.impl.GraphBase.graphBaseFind(GraphBase.java:260)

at org.topbraid.oracle.graph.OracleGraph.graphBaseFind(OracleGraph.java:158)

at com.hp.hpl.jena.graph.impl.GraphBase.find(GraphBase.java:257)

at org.topbraid.oracle.modules.importOracleRDFDatabase.ImportOracleRDFDatabaseModule.isInitialized(ImportOracleRDFDatabaseModule.java:105)

at org.topbraid.oracle.modules.importOracleRDFDatabase.ImportOracleRDFDatabaseModule.basicOpenGraph(ImportOracleRDFDatabaseModule.java:144)

at org.topbraid.oracle.modules.importOracleRDFDatabase.ImportOracleRDFDatabaseModule.createDatabaseGraph(ImportOracleRDFDatabaseModule.java:163)

at org.topbraidcomposer.oracle.wizards.create.CreateOracleWizard$1.run(CreateOracleWizard.java:90)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
  • 1. Re: strange error straight after model creation
    alwu Pro
    Currently Being Moderated
    Hi Jeremy,

    Could you please login to these two databases as SYSDBA as do the following?

    SQL> conn / as sysdba
    Connected.

    SQL> show parameters cursor_sharing ;

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    cursor_sharing string EXACT

    Please let us know if there is any difference.

    Thanks,

    Zhe
  • 2. Re: strange error straight after model creation
    796925 Newbie
    Currently Being Moderated
    Hi Zhe

    yes this was the problem

    The functioning set up had EXACT
    The non-functioning set up had SIMILAR

    I am trying to work out how we can guard against this and improve our error messages, I will get back to you if I would like some more help with this

    Jeremy

Legend

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