2 Replies Latest reply: May 2, 2012 9:12 AM by yaqoobj RSS

    migrating application from oc4j into weblogic 10.3

    776459
      Hello,
      while migrating the bc4j application from oc4j into weblogic 10.3, we have got the following problem:

      When fetching several times from the same view, exception is thrown:
      [1488] QueryCollection.createColumnList(2673) Column count: 12
      [1489] ViewObjectImpl.getPreparedStatement(8275) ViewObject: <..application view name..> Reusing defined prepared Statement
      [1490] ViewObjectImpl.bindParametersForCollection(13862) Bind params for ViewObject: <..application view name..>
      [1491] ViewObjectImpl.bindParametersForCollection(13866) For RowSet : MagmaRowSet6
      [1492] BaseSQLBuilderImpl.bindParamValue(1839) Binding param 1: 3
      [1493] ViewObjectImpl.freeStatement(8387) ViewObject: <..application view name..> close single-use prepared statements
      [1494] QueryCollection.buildResultSet(957) QueryCollection.executeQuery failed...
      [1495] Diagnostic.printStackTrace(410) java.sql.SQLException: Missing defines
           at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
           at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
           at oracle.jdbc.driver.OracleStatement.checkAccessorsUsable(OracleStatement.java:1020)
           at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:846)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
           at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)
           at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
           at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
           at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3751)
           at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
           at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
           at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
           at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)

      we use dynamic binding, and the fetch fails at the sixth time (the previous five times it works fine).

      Thanks.