4 Replies Latest reply on Apr 28, 2006 2:36 PM by oliverhrdz

    Cannot send messages using Oracle PM

    oliverhrdz

      Help, I'm getting the following error on the server, JBoss 4.0.3SP1, when I try to send a message:

      10:49:36,789 ERROR [ChannelSupport] Failed to handle message
      java.sql.SQLException: ORA-01036: illegal variable name/number
      
       at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
       at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2355)
       at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1698)
       at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1921)
      
       at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
      va:2181)
       at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
      a:2063)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
      nt.java:2922)
       at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
      edStatement.java:644)
       at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdat
      e(WrappedPreparedStatement.java:227)
       at org.jboss.messaging.core.plugin.JDBCPersistenceManager.addReference(J
      DBCPersistenceManager.java:1664)
       at org.jboss.messaging.core.ChannelState.addReference(ChannelState.java:
      211)
       at org.jboss.messaging.core.ChannelSupport.handle(ChannelSupport.java:12
      9)
       at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(Se
      rverConnectionEndpoint.java:744)
       at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessio
      nEndpoint.java:366)
       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)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
       at org.jboss.jms.server.container.ServerLogInterceptor.invoke(ServerLogI
      nterceptor.java:105)
       at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.
      java:101)
       at org.jboss.aop.Advisor.dynamicInvoke(Advisor.java:719)
       at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:99)
       at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSSe
      rverInvocationHandler.java:126)
       at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:831)
       at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:680)
       at org.jboss.remoting.transport.socket.ServerThread.processInvocation(Se
      rverThread.java:414)
       at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.j
      ava:498)
       at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.jav
      a:240)
      10:49:36,839 ERROR [ServerConnectionEndpoint] The message was not acknowledged b
      y destination CoreQueue[2]
      



      I'm using the Oracle PM configuration posted earlier on this forum. My client of course errors out stating it failed to send a message. TIA!