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! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3940186#3940186 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3940186 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
