Marcio Kikuti - 2008-05-14

I'm having some issues using p6spy to analyze a BC4J app (deployed in oc4j). When I start oc4j a startup servlet in my app runs a query in an oracle database, but since I'm using p6spy as my connection driver I'm having a ClassCastException.

My guess is that inside BC4J we'll find many specific casts from JDBC entities to Oracle implementations, so P6SPY implementations will always cause ClassCast.

Does any one have problems like this?

Error StackTrace :

java.lang.ClassCastException
    at oracle.jbo.server.OracleSQLBuilderImpl.doStatementSetRowPrefetch(OracleSQLBuilderImpl.java:919)
    at oracle.jbo.server.DBTransactionImpl.createPreparedStatement(DBTransactionImpl.java:3001)
    at oracle.jbo.server.DBTransactionImpl2.createPreparedStatement(DBTransactionImpl2.java:418)
    at oracle.jbo.server.DBTransactionImpl.createReUsePreparedStatement(DBTransactionImpl.java:3773)
    at oracle.jbo.server.ViewObjectImpl.getPreparedStatement(ViewObjectImpl.java:7018)
    at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:524)
    at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3049)
    at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:539)
    at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:586)
    at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3013)
    at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3000)
    at br.com.myapp.view.MyViewImpl.myQuery(MyViewImpl.java:558)