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

Hi My program that runs outside the jboss environment opens a db connection using Jboss connection pool setting(data sources). It is able to execute sqls and stored procedures correctly. However if a stored procedure has output parameter defined as REF CURSOR, then it fails to execute that procedure and reports Proxy$4 exception without any details. I suspect there is a missing mapping in standardjbosscmp-jdbc.xml for REF CURSOR. Could someone advice if that indeed is the problem and how to configure this mapping? <java-type>java.sql.resultset</java-type> <jdbc-type>?? <sql-type>?? thanks RK View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4023033#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...