Return-Path: Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org Received: (qmail 70082 invoked from network); 29 Sep 2006 16:24:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Sep 2006 16:24:45 -0000 Received: (qmail 39731 invoked by uid 500); 29 Sep 2006 16:24:44 -0000 Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org Received: (qmail 39708 invoked by uid 500); 29 Sep 2006 16:24:44 -0000 Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: activemq-users@geronimo.apache.org Delivered-To: mailing list activemq-users@geronimo.apache.org Received: (qmail 39699 invoked by uid 99); 29 Sep 2006 16:24:44 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Sep 2006 09:24:44 -0700 Authentication-Results: idunn.apache.osuosl.org header.from=adborja@gmail.com; domainkeys=good X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE DomainKey-Status: good X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01 Received: from [64.233.184.233] ([64.233.184.233:41974] helo=wr-out-0506.google.com) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id D2/68-13110-7C84D154 for ; Fri, 29 Sep 2006 09:24:41 -0700 Received: by wr-out-0506.google.com with SMTP id i21so340974wra for ; Fri, 29 Sep 2006 09:24:36 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Gj/K8ZTWwwp3rVnbzc8k1t+rNaJzFet/WFouJ1+pMQih2977qGhFPu+Zt9vujkKHfGAV8WcVI7hAbcuCm5/Q5Er8JHfFxJnFnjfoFYsxVuC7SrcE0JUQNSDjbWsDvIdBzViQCYNHEN/u53gxNROWCZkN3M6FHbvjdVHpOj6yFO8= Received: by 10.90.78.1 with SMTP id a1mr1716149agb; Fri, 29 Sep 2006 09:24:36 -0700 (PDT) Received: by 10.90.115.2 with HTTP; Fri, 29 Sep 2006 09:24:36 -0700 (PDT) Message-ID: <8c46aa2a0609290924h41c6c7cfxb6f594e4d665a61d@mail.gmail.com> Date: Fri, 29 Sep 2006 11:24:36 -0500 From: "David Borja" To: activemq-users@geronimo.apache.org Subject: Re: Problems with activemq + c-jdbc In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31417_2097416.1159547076042" References: <8c46aa2a0609281400n27f9b6c5i1d56553352d3e644@mail.gmail.com> <8c46aa2a0609290630idafae48kbd1dcf096d3ebe3@mail.gmail.com> X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_31417_2097416.1159547076042 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 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 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 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 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/ > ------=_Part_31417_2097416.1159547076042--