Hi James ... Where can i set that property ???? in broker URL ??
String borkerURL = "tcp://localhost:61616?createTablesOnStartup=false" or something like that?? Thanx ! On 9/29/06, James Strachan <[EMAIL PROTECTED]> wrote:
ActiveMQ tries to auto-create tables on startup but as you say you can disable that if you wish via the createTablesOnStartup property. On 9/29/06, David Borja <[EMAIL PROTECTED]> wrote: > 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 > > > > -- James ------- http://radio.weblogs.com/0112098/
