Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: activemq-users@geronimo.apache.org
Received-SPF: pass (asf.osuosl.org: domain of james.strachan@gmail.com
 designates 66.249.92.168 as permitted sender)
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:content-transfer-encoding:content-disposition:references;
        b=XD9/7i4I6Yb62GTbo9ndkT/Njwn4X7yWVpr72Fu+nVGIdYcRdmH27iF+DlK+xe0Wp3gZfwLIxYLTLFvCvvDo75dbUinSKYtbsfbYdfUMRRsCuKiMotEtPl3oYkdHtMr+VTl/lEKZARrmkyUvgJlWAjrUF1hbVL1vTLAMhyh8Hyg=
Message-ID: <ec6e67fd0606290446o572d35f5jc3d390b492f8d8b7@mail.gmail.com>
Date: Thu, 29 Jun 2006 12:46:53 +0100
From: "James Strachan" <james.strachan@gmail.com>
To: activemq-users@geronimo.apache.org
Subject: Re: ActiveMQ and Sybase
In-Reply-To: <5100991.post@talk.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <5100991.post@talk.nabble.com>

It actually looks like things are working; its just on startup it
tries to create the various tables required by ActiveMQ.

BTW I'd recommend you upgrade to 4.0.1 as 3.x is pretty old now.


On 6/29/06, DavidField <david.field@uk.bnpparibas.com> wrote:
>
> Does anyone have example code from activemq.xml for when peristing messages
> using Sybase ASE?
>
> I'm getting the following errors:
> 12:22:14 INFO  ActiveMQ 3.2.2 JMS Message Broker
> (ID:LONW00050832-4829-115158013
> 0381-0:0) is starting
> 12:22:14 INFO  For help or more information please see:
> http://www.logicblaze.co
> m
> 12:22:15 INFO  Database driver recognized: [jconnect__tm__for_jdbc__tm_]
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: CREATE TABLE ACTIVEMQ_MSGS(ID INTEGER NOT NULL, CONTAINER VARCHAR(250),
> MSGI
> D VARCHAR(250), MSG IMAGE, PRIMARY KEY ( ID ) ) Message: There is already an
> obj
> ect named 'ACTIVEMQ_MSGS' in the database.
>  SQLState: ZZZZZ Vendor code: 2714
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: CREATE INDEX ACTIVEMQ_MSGS_MIDX ON ACTIVEMQ_MSGS (MSGID) Message: There
> is a
> lready an index on table 'ACTIVEMQ_MSGS' named 'ACTIVEMQ_MSGS_MIDX'
>  SQLState: ZZZZZ Vendor code: 1913
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: CREATE INDEX ACTIVEMQ_MSGS_CIDX ON ACTIVEMQ_MSGS (CONTAINER) Message:
> There
> is already an index on table 'ACTIVEMQ_MSGS' named 'ACTIVEMQ_MSGS_CIDX'
>  SQLState: ZZZZZ Vendor code: 1913
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: CREATE TABLE ACTIVEMQ_TXS(XID VARCHAR(250) NOT NULL, PRIMARY KEY ( XID
> )) Me
> ssage: There is already an object named 'ACTIVEMQ_TXS' in the database.
>  SQLState: ZZZZZ Vendor code: 2714
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: CREATE TABLE ACTIVEMQ_ACKS(SUB VARCHAR(250) NOT NULL, CONTAINER
> VARCHAR(250)
>  NOT NULL, LAST_ACKED_ID INTEGER, SE_ID INTEGER, SE_CLIENT_ID VARCHAR(250),
> SE_C
> ONSUMER_NAME VARCHAR(250), SE_SELECTOR VARCHAR(250), PRIMARY KEY ( SUB,
> CONTAINE
> R )) Message: There is already an object named 'ACTIVEMQ_ACKS' in the
> database.
>  SQLState: ZZZZZ Vendor code: 2714
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: CREATE INDEX ACTIVEMQ_ACKS_CIDX ON ACTIVEMQ_ACKS (CONTAINER) Message:
> There
> is already an index on table 'ACTIVEMQ_ACKS' named 'ACTIVEMQ_ACKS_CIDX'
>  SQLState: ZZZZZ Vendor code: 1913
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: ALTER TABLE ACTIVEMQ_MSGS ADD EXPIRATION BIGINT Message: Can't find type
> 'BI
> GINT'.
>  SQLState: ZZZZZ Vendor code: 2715
> 12:22:15 INFO  Could not create JDBC tables; they could already exist.
> Failure w
> as: ALTER TABLE ACTIVEMQ_MSGS ADD SENT_TO_DEADLETTER CHAR(1) Message: ALTER
> TABL
> E 'ACTIVEMQ_MSGS' failed. Default clause is required in order to add
> non-NULL co
> lumn 'SENT_TO_DEADLETTER'.
>  SQLState: ZZZZZ Vendor code: 4997
> 12:22:15 INFO  Opening journal.
> 12:22:15 INFO  Opened journal: Active Journal: using 2 x 20.0 Megs at:
> ..\var\jo
> urnal666
> 12:22:15 INFO  Journal Recovery Started.
> 12:22:15 INFO  Journal Recovered: 0 message(s) in transactions recovered.
> 12:22:15 INFO  Listening for connections at: tcp://LONW00050832:61616
> 12:22:15 INFO  ActiveMQ connector started:
> TcpTransportServerChannel@tcp://LONW0
> 0050832:61616
> 12:22:15 INFO  ActiveMQ JMS Message Broker
> (ID:LONW00050832-4829-1151580130381-0
> :0) has started
>
> Here is the relevant part of the configuration:
>   <bean id="sybase-ds"
>         class="org.apache.commons.dbcp.BasicDataSource"
>         destroy-method="close">
>     <property name="driverClassName">
>       <value>com.sybase.jdbc3.jdbc.SybDriver</value>
>     </property>
>     <property name="url">
>       <value>jdbc:sybase:Tds:------:----</value>
>     </property>
>     <property name="username">
>       <value>d_field</value>
>     </property>
>     <property name="password">
>       <value>shifty</value>
>     </property>
>     <property name="poolPreparedStatements">
>       <value>true</value>
>     </property>
>   </bean>
>
> Thanks
> --
> View this message in context: http://www.nabble.com/ActiveMQ-and-Sybase-tf1866950.html#a5100991
> Sent from the ActiveMQ - User forum at Nabble.com.
>
>


-- 

James
-------
http://radio.weblogs.com/0112098/