1 Reply Latest reply on Nov 23, 2005 2:53 AM by Joachim Van der Auwera

    ejb 2 cmp error

    Naveen Kumar Newbie

      Iam Naveen ,when iam working with ejb2(CMP)usingjboss4.0,MySQL as
      backend,i got an excepion table doesn't existinspiteof creating table in
      the database.plz help me .The erroris

      ----------------------------------

      xception in thread"main"javax.ejb.CreateException: Error checkingif
      entityexists:java.sql.SQLException: Table 'jboss.xuser' doesn,texist

      atorg.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:92)

      atorg.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)

      atorg.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:572)

      atorg.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:222)

      atorg.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:266)
      atorg.jboss.ejb.EntityContainer.createHome(EntityContainer.java:766)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

      atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      atjava.lang.reflect.Method.invoke(Method.java:585)
      atorg.jboss.invocation.Invocation.performCall(Invocation.java:345)

      atorg.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1113)

      atorg.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:90)

      atorg.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:192)

      atorg.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:212)

      atorg.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:90)

      atorg.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:117)

      atorg.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)

      atorg.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)

      atorg.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:41)

      atorg.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:109)

      atorg.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)

      atorg.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:146)

      atorg.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:116)

      atorg.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:121)

      atorg.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)

      atorg.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:508)
      at org.jboss.ejb.Container.invoke(Container.java:894)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

      atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      atjava.lang.reflect.Method.invoke(Method.java:585)

      atorg.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      atorg.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      atorg.jboss.mx.server.Invocation.invoke(Invocation.java:72)

      atorg.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:249)

      atorg.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)

      atorg.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:805)

      atorg.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:406)
      atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)

      atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

      atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      atjava.lang.reflect.Method.invoke(Method.java:585)

      atsun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
      at sun.rmi.transport.Transport$1.run(Transport.java:153)
      atjava.security.AccessController.doPrivileged(Native Method)
      atsun.rmi.transport.Transport.serviceCall(Transport.java:149)

      atsun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)

      atsun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
      at java.lang.Thread.run(Thread.java:595)

      atsun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)

      atsun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
      at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:126)
      at
      org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(UnknownSource)

      atorg.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:118)