Hibernate version: 0.9.1.2

Name and version of the database you are using: Oracle 10 g

I have written one stored procedure taht returns cursor.
In java bussiness class this storedprocedure is called as follows.

////////////////////////////
Session session = Util_Hibernate.getSession();
Connection con = session.connection();
CallableStatement callStmt = con.prepareCall("{call SPTEEST_VIEW(?,?)}");
callStmt.setInt(1,iPointerKey);
callStmt.registerOutParameter(2,OracleTypes.CURSOR);
callStmt.execute();
cursor = ((OracleCallableStatement)callStmt).getCursor(2);



//////////////////

But last line throws following class cast exception when i use c3p0 connection pooling
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.

But when I use hibernate default connection pooling, I am able to cast callStmt into OracleCallableStatement.

Plz tell me if anyone of you have come across this issue earlier. Is there any other workaround to return cursor from stored procedure using C3P0 connection.

Thanx in advance for suggestions.

I know it's been a while, but I have a solution to this problem.

As you said, when you use c3p0 connection pooling, the cursor should be a "NewProxyCallableStatement" and not an "OracleCallableStatement".
That is why you get this error.
I have had the same problem.

So to keep using c3p0, I have to use another way to get the cursor.
After calling:


You should call:


If you are sure the output of your stored procedure is a "Ref Cursor", it should solve the problem.