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)