6 Replies Latest reply on Jun 12, 2006 2:08 PM by Tim Fox

    Error when using Oracle 9i in 1.0.1.CR2:  Missing IN or OUT

    Sudhir Prakash Newbie

      I setup Persistence using Oracle 9i. It works with 1.0 GA, however with 1.0.1.CR2 I get this error:

      12:22:51,253 ERROR [ChannelSupport] Failed to handle message
      java.sql.SQLException: Missing IN or OUT parameter at index:: 16
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
      :111)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
      :145)
      at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(Or
      aclePreparedStatement.java:1680)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
      aredStatement.java:3279)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
      edStatement.java:3367)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdat
      e(WrappedPreparedStatement.java:251)
      at org.jboss.messaging.core.plugin.JDBCPersistenceManager.addReference(J
      DBCPersistenceManager.java:1645)
      at org.jboss.messaging.core.ChannelState.addReference(ChannelState.java:
      209)
      at org.jboss.messaging.core.ChannelSupport.handle(ChannelSupport.java:12
      9)
      at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(Se
      rverConnectionEndpoint.java:769)
      at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessio
      nEndpoint.java:376)
      at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$se
      rver$endpoint$advised$SessionAdvised$send$aop(SessionAdvised.java:75)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:112)
      at org.jboss.jms.server.container.SecurityAspect.handleSend(SecurityAspe
      ct.java:150)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
      java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
      sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:
      130)