Cannot send messages using Oracle PM
oliverhrdz Apr 28, 2006 11:51 AMHelp, 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!