This discussion is archived
2 Replies Latest reply: May 2, 2012 7:12 AM by yaqoobj RSS

migrating application from oc4j into weblogic 10.3

776459 Newbie
Currently Being Moderated
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.

Legend

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