1 Reply Latest reply on May 26, 2004 8:27 AM by ironbird

    Error on calling create(primary_key) fun from client

    Nischal Sharma Newbie

      hi

      I have created cmp bean and when i call create(primaryKey) method from the ejb client. i getting this error message on jboss console

      i think the error is here but i dont know how to remove this error
      as create() fun itself handle the insert query.

      <<< Error checking if entity exists
      java.sql.SQLException: ORA-00921: unexpected end of SQL command

      >>>


      ..............................................

      3.2.3/server/default/deploy/ESP.ear
      16:29:55,031 INFO [EjbModule] Deploying CandidateAdd
      16:29:55,046 INFO [EjbModule] Deploying StatelessEJB
      16:29:57,531 INFO [CandidateAdd] Table 'CANDIDATE_ADD' already exists
      16:29:57,718 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateAddHome,plugin=pool,service=EJB
      16:29:57,718 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateAddHome,service=EJB
      16:29:57,765 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=StatelessEJBHome,plugin=pool,service=EJB
      16:29:57,765 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=StatelessEJBHome,service=EJB
      16:29:57,765 INFO [EjbModule] Started jboss.j2ee:module=ESP.jar,service=EjbModule
      16:29:57,765 INFO [EJBDeployer] Deployed: file:/C:/jboss-3.2.3/server/default/tmp/deploy/tmp19034ESP.ear-contents/ESP.jar
      16:29:57,796 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      16:29:57,812 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      16:35:08,281 INFO [EjbModule] Stopping jboss.j2ee:module=ESP.jar,service=EjbModule
      16:35:08,281 INFO [StatelessSessionContainer] Stopping jboss.j2ee:jndiName=StatelessEJBHome,service=EJB
      16:35:08,281 INFO [StatelessSessionInstancePool] Stopping jboss.j2ee:jndiName=StatelessEJBHome,plugin=pool,service=EJB
      16:35:08,296 INFO [EntityContainer] Stopping jboss.j2ee:jndiName=CandidateAddHome,service=EJB
      16:35:08,296 INFO [EntityInstancePool] Stopping jboss.j2ee:jndiName=CandidateAddHome,plugin=pool,service=EJB
      16:35:08,296 INFO [EARDeployer] Undeploying J2EE application, destroy step: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      16:35:08,312 INFO [EJBModule] destroy(), remove EJB-Module: jboss.management.local:J2EEApplication=ESP.ear,J2EEServer=Local,j2e
      16:35:08,312 WARN [DeploymentInfo] Could not delete file:/C:/jboss-3.2.3/server/default/tmp/deploy/tmp19034ESP.ear restart will
      16:35:08,312 INFO [MainDeployer] Starting deployment of package: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      16:35:08,328 INFO [EARDeployer] Init J2EE application: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      16:35:08,750 INFO [EjbModule] Deploying CandidateAdd
      16:35:08,765 INFO [EjbModule] Deploying StatelessEJB
      16:35:09,078 INFO [EntityInstancePool] Started jboss.j2ee:jndiName=CandidateAddHome,plugin=pool,service=EJB
      16:35:09,078 INFO [EntityContainer] Started jboss.j2ee:jndiName=CandidateAddHome,service=EJB
      16:35:09,125 INFO [StatelessSessionInstancePool] Started jboss.j2ee:jndiName=StatelessEJBHome,plugin=pool,service=EJB
      16:35:09,125 INFO [StatelessSessionContainer] Started jboss.j2ee:jndiName=StatelessEJBHome,service=EJB
      16:35:09,125 INFO [EjbModule] Started jboss.j2ee:module=ESP.jar,service=EjbModule
      16:35:09,125 INFO [EJBDeployer] Deployed: file:/C:/jboss-3.2.3/server/default/tmp/deploy/tmp19035ESP.ear-contents/ESP.jar
      16:35:09,156 INFO [EARDeployer] Started J2EE application: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      16:35:09,156 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.2.3/server/default/deploy/ESP.ear
      16:38:08,750 ERROR [CandidateAdd] Error checking if entity exists
      java.sql.SQLException: ORA-00921: unexpected end of SQL command

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
      at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:83)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
      at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
      at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:737)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:297)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
      at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
      at org.jboss.ejb.Container.invoke(Container.java:720)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      at sun.rmi.transport.Transport$1.run(Transport.java:148)
      at java.security.AccessController.doPrivileged(Native Method)
      at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      at java.lang.Thread.run(Thread.java:536)
      16:51:58,625 ERROR [CandidateAdd] Error checking if entity exists
      java.sql.SQLException: ORA-00921: unexpected end of SQL command

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
      at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:83)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
      at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
      at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:737)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
      at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
      at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
      at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:297)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
      at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
      at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
      at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
      at org.jboss.ejb.Container.invoke(Container.java:720)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:367)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
      at sun.rmi.transport.Transport$1.run(Transport.java:148)
      at java.security.AccessController.doPrivileged(Native Method)
      at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
      at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
      at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)


      if any one knows about this then please hepl me

      with regards
      nischal