java.sql.SQLException: ORA-00936: missing expression
janekclaus Apr 20, 2003 11:09 PMI just starting to dive into the JBoss CMP features, but the simplest task fails already.
I deployed an entity bean with just a single findByPrimaryKey method.
I double checked the deployment descriptors and my entity bean. The deployment works fine, but as soon as I try to access an entity from a test session bean I get above mentioned exception from Oracle.
We're using Oracle 8i (8.1.6) and my jbosscmp-jdbc uses the mapping for Oracle8. It looks like JBoss is not using the right statement to find my entity. Could the mapping be the problem?
Thanks, Janek
p.s.: The full output looks like this:
22:53:22,450 ERROR [STDERR] javax.ejb.FinderException: Find failed: java.sql.SQLException: ORA-00936: missing expression
22:53:22,450 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:194)
22:53:22,450 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:91)
22:53:22,450 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:44)
22:53:22,450 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:591)
22:53:22,450 ERROR [STDERR] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:312)
22:53:22,450 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:301)
22:53:22,450 ERROR [STDERR] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:685)
22:53:22,460 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
22:53:22,460 ERROR [STDERR] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998)
22:53:22,460 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
22:53:22,460 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188)
22:53:22,480 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
22:53:22,480 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
22:53:22,540 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
22:53:22,550 ERROR [STDERR] at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477)
22:53:22,550 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:694)
22:53:22,550 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
22:53:22,550 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
22:53:22,550 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
22:53:22,550 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
22:53:22,550 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:88)
22:53:22,550 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
22:53:22,550 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
22:53:22,550 ERROR [STDERR] at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:175)
22:53:22,550 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:82)
22:53:22,550 ERROR [STDERR] at $Proxy42.findByPrimaryKey(Unknown Source)
22:53:22,550 ERROR [STDERR] at bean.JBossSessionBean.getName(Unknown Source)
22:53:22,550 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
22:53:22,550 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:629)
22:53:22,550 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
22:53:22,550 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322)
22:53:22,560 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:674)
22:53:22,560 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
22:53:22,560 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
22:53:22,560 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
22:53:22,560 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:359)
22:53:22,560 ERROR [STDERR] at java.lang.reflect.Method.invoke(Native Method)
22:53:22,560 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:236)
22:53:22,560 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.java:147)
22:53:22,560 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native Method)
22:53:22,560 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Transport.java:143)
22:53:22,560 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
22:53:22,560 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
22:53:22,560 ERROR [STDERR] at java.lang.Thread.run(Thread.java:479)
22:53:22,610 INFO [STDOUT] Returning: Find failed: java.sql.SQLException: ORA-00936: missing expression