2 Replies Latest reply on Nov 12, 2009 7:55 PM by 733920

    PLS-00302: component 'REFRESH_QUERY_STATE' must be declared

    733920
      I get the following error while running Test.java along with jena adaptor.

      my code looks like this

      String szJdbcURL = "jdbc:oracle:thin:@192.168.4.35:1521:rdfowl";
      String szUser = "testuser";
      String szPasswd = "testuser";
      String szModelName = "family";
           
      Oracle oracle = new Oracle(szJdbcURL, szUser, szPasswd);
      Model model = ModelOracleSem.createOracleSemModel(
      oracle, szModelName);
      model.close();
      oracle.dispose();

      here is the complete stack trace:
      12 Nov, 2009 1:29:43 PM oracle.spatial.rdf.client.jena.SimpleLog error
      SEVERE: Could not close
      java.sql.SQLException: ORA-06550: line 1, column 16:
      PLS-00302: component 'REFRESH_QUERY_STATE' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

           at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
           at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3840)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086)
           at oracle.spatial.rdf.client.jena.GraphOracleSem.invalidateCursor(GraphOracleSem.java:3045)
           at oracle.spatial.rdf.client.jena.GraphOracleSem.flushAdd(GraphOracleSem.java:1412)
           at oracle.spatial.rdf.client.jena.GraphOracleSem.closeWithoutCommit(GraphOracleSem.java:1293)
           at oracle.spatial.rdf.client.jena.GraphOracleSem.close(GraphOracleSem.java:1353)
           at com.hp.hpl.jena.rdf.model.impl.ModelCom.close(ModelCom.java:1172)
           at Test.main(Test.java:24)


      Any idea why? and what will be work around. I am using Jena 2.5.7

      thanks