[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Mapping of Oracle REF CURSOR in standardjbosscmp-jdbc.xm

sirji do-not-reply at jboss.com
Thu Aug 23 14:33:30 EDT 2007

Hi all,

We are using JBoss 4.0.5 and Oracle 9i. and have exactly similar scenario where we are getting the connection object through Data source lookup and executing a stored procedure have ref cursor.

We are also getting following error:-

java.lang.ClassCastException: $Proxy2

Code snippet:

boolean success = stmt.execute();
ResultSet rsRawData = ((OracleCallableStatement)stmt).getCursor(7);


boolean success = stmt.execute();
ResultSet rsRawData = ((ResultSet)stmt).getCursor(7);

But if we don't use JBoss datasource and create a connection using DriverManager then it works perfectly fine.

Any assistance on this will be helpful.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4077481#4077481

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4077481

More information about the jboss-user mailing list