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

[rkhurana]

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#4023033

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