1 Reply Latest reply: Apr 17, 2012 9:30 AM by JamesSutherland RSS

    Error on Expression Query - java.sql.SQLException: DSRA9420E

    amehta5
      We are getting the below error when we execute an Expression query. Other queries seem to be working fine.
      Has anyone seen this error?
      Any help or suggestions are welcome.
      Thanks

      ERROR -
      java.sql.SQLException: DSRA9420E: Connection cannot be reassociated because child objects are still open.
      at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1376)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.reactivate(WSJdbcConnection.java:2201)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2070)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2039)
      at oracle.toplink.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1295)
      at oracle.toplink.queryframework.SQLCall.prepareStatement(SQLCall.java:185)
      at oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:635)
      at oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:506)
      at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(CallQueryMechanism.java:134)
      at oracle.toplink.internal.queryframework.CallQueryMechanism.executeCall(CallQueryMechanism.java:115)
      at oracle.toplink.internal.queryframework.CallQueryMechanism.executeSelectCall(CallQueryMechanism.java:197)
      at oracle.toplink.internal.queryframework.CallQueryMechanism.selectAllRows(CallQueryMechanism.java:567)
      at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:732)
      at oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:707)
      at oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:447)

      Edited by: amehta5 on Apr 12, 2012 12:13 PM