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

[sirji]

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);

OR

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