Hi Hiram ... But ActiveMQ is creating the ACTIVEMQ_MSG table each time that runs, this is not an ActiveMQ problem?, does`nt exist something like setAutoCreationTables(false)?
Thanx!! On 9/29/06, Hiram Chirino <[EMAIL PROTECTED]> wrote:
you might want to post this to the cjdbc guys. If they tell you what's causing the error, we may be able to help some more. On 9/28/06, David Borja <[EMAIL PROTECTED]> wrote: > *2006-09-28 16:02:16,806 WARN controller.RequestManager.myDBSQLException > while > executing distributed write request. > java.sql.SQLException: Request 0 failed: > BackendThread activemq1528 failed (Table/View 'ACTIVEMQ_MSGS' already exists > in > Schema 'ACTIVEMQ'.) > BackendThread activemq1527 failed (Table/View 'ACTIVEMQ_MSGS' already exists > in > Schema 'ACTIVEMQ'.) > > at > org.objectweb.cjdbc.common.exceptions.SQLExceptionFactory.getSQLExcep > tion(SQLExceptionFactory.java:94) > at > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe > quest(RAIDb1.java:582) > at > org.objectweb.cjdbc.controller.loadbalancer.raidb1.RAIDb1.execWriteRe > quest(RAIDb1.java:350) > at > org.objectweb.cjdbc.controller.requestmanager.RequestManager.loadBala > nceExecWriteRequest(RequestManager.java:689) > at > org.objectweb.cjdbc.controller.virtualdatabase.protocol.ExecWriteRequ > est.executeScheduledRequest(ExecWriteRequest.java:79) > at > org.objectweb.cjdbc.controller.virtualdatabase.DistributedVirtualData > base.handleMessageMultiThreaded(DistributedVirtualDatabase.java:831) > at org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run > (Multic > astRequestAdapterThread.java:79) > java.io.NotSerializableException: org.apache.derby.client.net.NetSqlca > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.writeObject(Unknown Source) > at java.util.ArrayList.writeObject(Unknown Source) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) > at java.lang.reflect.Method.invoke(Unknown Source) > at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.defaultWriteFields(Unknown Source) > at java.io.ObjectOutputStream.writeSerialData(Unknown Source) > at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) > at java.io.ObjectOutputStream.writeObject0(Unknown Source) > at java.io.ObjectOutputStream.writeObject(Unknown Source) > at org.objectweb.tribe.messages.ChannelMessage.getByteArray > (ChannelMessa > ge.java:173) > at org.objectweb.tribe.channel.JGroupsReliableChannelWithGms.send > (JGroup > sReliableChannelWithGms.java:245) > at org.objectweb.tribe.channel.ReliableGroupChannel.send > (ReliableGroupCh > annel.java:148) > at org.objectweb.tribe.adapters.PullPushAdapter.send( > PullPushAdapter.jav > a:158) > at org.objectweb.tribe.adapters.MulticastRequestAdapterThread.run > (Multic > astRequestAdapterThread.java:97) > > Any Ideas?? > > Alvaro David Borja > Solutions Architect > > * > > -- Regards, Hiram Blog: http://hiramchirino.com
