activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DavidField <david.fi...@uk.bnpparibas.com>
Subject ActiveMQ and Sybase
Date Thu, 29 Jun 2006 11:24:57 GMT

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.


Mime
View raw message