1 Reply Latest reply on Oct 6, 2004 1:18 AM by bill.burke

    porting workbook examples 04_01 from jboss/hsqldb to jboss/m

    robinbajaj

      i have configured the mysql 4 to work with jboss 4.0
      Can Bill/Sacha kindly tell me what corresponding change do i need to make in the ant script as that it works with mysql.
      I have tried to make the ex_04_01 work with this config.
      it gives me the following error when i run this 2nd time.
      (it works first time. then i do
      ant clean
      ant clean.db
      then it works for second time onwards for hypersonic db
      but not for mysql db
      )
      I know its been pointed out by you guys on page 598 of workbook
      that i have to run ant clean.db task before running the client 2nd time.
      but the ant clean.db deletes ..\data\hypersonic folder only .
      how can i change it to delete the corresponding data for mysql.
      i have checked the corresponding folders in ..\data there is no mysql folder being made after default ant task completes , as is the case with
      jboss +hsqldb configuration.



      A side pointer to this Question would be :
      Where does the mySQL data get stored in jBoss 4.0
      Certainly not in ..\data folder acc. to my observation.


      run.client_41a:
       [java] javax.ejb.DuplicateKeyException: Entity with primary key 1 already e
      xists
       [java] at org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.befo
      reInsert(JDBCInsertPKCreateCommand.java:90)
       [java] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.exec
      ute(JDBCAbstractCreateCommand.java:137)
       [java] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(
      JDBCStoreManager.java:565)
       [java] at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPP
      ersistenceManager.java:222)
       [java] at org.jboss.resource.connectionmanager.CachedConnectionIntercep
      tor.createEntity(CachedConnectionInterceptor.java:269)
       [java] at org.jboss.ejb.EntityContainer.createHome(EntityContainer.java
      :768)
       [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
      sorImpl.java:39)
       [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
      hodAccessorImpl.java:25)
       [java] at java.lang.reflect.Method.invoke(Method.java:324)
       [java] at org.jboss.invocation.Invocation.performCall(Invocation.java:3
      45)
       [java] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
      (EntityContainer.java:1111)
       [java] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(Abstract
      Interceptor.java:90)
       [java] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke
      Home(EntitySynchronizationInterceptor.java:194)
       [java] at org.jboss.resource.connectionmanager.CachedConnectionIntercep
      tor.invokeHome(CachedConnectionInterceptor.java:214)
       [java] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(Abstract
      Interceptor.java:90)
       [java] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(En
      tityInstanceInterceptor.java:113)
       [java] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(Entity
      LockInterceptor.java:61)
       [java] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(En
      tityCreationInterceptor.java:28)
       [java] at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(Ca
      llValidationInterceptor.java:41)
       [java] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstra
      ctTxInterceptor.java:109)
       [java] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(Tx
      InterceptorCMT.java:316)
       [java] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxIntercept
      orCMT.java:129)
       [java] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(Security
      Interceptor.java:106)
       [java] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogIntercepto
      r.java:120)
       [java] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHom
      e(ProxyFactoryFinderInterceptor.java:93)
       [java] at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContai
      ner.java:516)
       [java] at org.jboss.ejb.Container.invoke(Container.java:893)
       [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
      sorImpl.java:39)
       [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
      hodAccessorImpl.java:25)
       [java] at java.lang.reflect.Method.invoke(Method.java:324)
       [java] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(Reflected
      Dispatcher.java:141)
       [java] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
       [java] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
       [java] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBean
      Invoker.java:230)
       [java] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.ja
      va:642)
       [java] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvok
      er.java:352)
       [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       [java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
      sorImpl.java:39)
       [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
      hodAccessorImpl.java:25)
       [java] at java.lang.reflect.Method.invoke(Method.java:324)
       [java] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.jav
      a:261)
       [java] at sun.rmi.transport.Transport$1.run(Transport.java:148)
       [java] at java.security.AccessController.doPrivileged(Native Method)
       [java] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
       [java] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTranspor
      t.java:460)
       [java] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPT
      ransport.java:701)
       [java] at java.lang.Thread.run(Thread.java:534)
       [java] at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServe
      r(StreamRemoteCall.java:247)
       [java] at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCa
      ll.java:223)
       [java] at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:133)
       [java] at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unkn
      own Source)
       [java] at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(
      JRMPInvokerProxy.java:135)
       [java] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterce
      ptor.java:96)
       [java] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInte
      rceptor.java:46)
       [java] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityIntercepto
      r.java:45)
       [java] at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.ja
      va:169)
       [java] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:8
      6)
       [java] at $Proxy0.create(Unknown Source)
       [java] at com.titan.clients.Client_1.main(Client_1.java:22)