2 Replies Latest reply on Apr 11, 2003 6:43 AM by Edwin Litterst

    problem using oracle ref cursor

    Edwin Litterst Newbie

      Hi,
      I am trying to port an existing application to Jboss. I created an oracle connection according to the example oracle-service.xml, which works just fine. But when I am calling a stored procedure which is using a ref cursor an exception is thrown when I am trying to access this cursor with
      ResultSet rs = ((OracleCallableStatement)stmt).getCursor(9);
      The exception is:
      2003-04-10 17:47:44,571 INFO [STDOUT] Exception: org.jboss.resource.adapter.jdbc.local.LocalCallableStatement
      2003-04-10 17:47:44,573 INFO [STDOUT] java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.local.LocalCallableStatement
      2
      which is called by the statement above.

      Are there any known problems?

      Another small problem: To get my EJB running I had to change the string for JNDI lookup of the oracle connection. Is this normal?

      Eddie