activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Strachan" <james.strac...@gmail.com>
Subject Re: ActiveMQ and Sybase
Date Thu, 29 Jun 2006 11:46:53 GMT
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/

Mime
View raw message