ActiveMQ jdbc persistence with Sybase SQL Anywhere

[Xiao-fei Song <xf...@yahoo.com>]

Hi,

I just have 

  <bean id="sybase-asa-ds" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
    <property name="driverClassName"
value="com.sybase.jdbc3.jdbc.SybDriver"/>
    <property name="url" value="jdbc:sybase:Tds:localhost:4000"/>
    <property name="username" value="dba"/>
    <property name="password" value="sql"/>
    <property name="poolPreparedStatements" value="true"/>
  </bean>

in my activemq-nojournal.xml and during activemq starts up I saw:

2007-07-13 20:12:03,220 [MQ ShutdownHook] INFO  BrokerService                 
- ActiveMQ Message Broker (localhost,
ID:xfsong-laptop-16320-1184328363290-1:0) is shutting down
2007-07-13 20:12:09,455 [MQ ShutdownHook] INFO  TransportConnector            
- Connector default Stopped
2007-07-13 20:12:14,456 [MQ ShutdownHook] INFO  TransportConnector            
- Connector stomp Stopped
2007-07-13 20:12:14,487 [MQ ShutdownHook] INFO  BrokerService                 
- ActiveMQ JMS Message Broker (localhost,
ID:xfsong-laptop-16320-1184328363290-1:0) stopped
2007-07-13 20:12:17,972 [main           ] INFO  BrokerService                 
- ActiveMQ 4.1.1 JMS Message Broker (localhost) is starting
2007-07-13 20:12:17,987 [main           ] INFO  BrokerService                 
- For help or more information please see:
http://incubator.apache.org/activemq/
2007-07-13 20:12:18,206 [main           ] INFO  JDBCPersistenceAdapter        
- Database driver recognized: [jconnect__tm__for_jdbc__tm_]
2007-07-13 20:12:18,222 [main           ] WARN  DefaultJDBCAdapter            
- Could not create JDBC tables; they could already exist. Failure was:
CREATE TABLE ACTIVEMQ_MSGS(ID INTEGER NOT NULL, CONTAINER VARCHAR(250),
MSGID_PROD VARCHAR(250), MSGID_SEQ INTEGER, EXPIRATION BIGINT, MSG IMAGE,
PRIMARY KEY ( ID ) ) Message: SQL Anywhere Error -110: Item 'ACTIVEMQ_MSGS'
already exists SQLState: 52010 Vendor code: 12006
2007-07-13 20:12:18,222 [main           ] WARN  DefaultJDBCAdapter            
- Could not create JDBC tables; they could already exist. Failure was:
CREATE INDEX ACTIVEMQ_MSGS_MIDX ON ACTIVEMQ_MSGS (MSGID_PROD,MSGID_SEQ)
Message: SQL Anywhere Error -111: Index name 'ACTIVEMQ_MSGS_MIDX' not unique
SQLState: 52W04 Vendor code: 1921
2007-07-13 20:12:18,222 [main           ] WARN  DefaultJDBCAdapter            
- Could not create JDBC tables; they could already exist. Failure was:
CREATE INDEX ACTIVEMQ_MSGS_CIDX ON ACTIVEMQ_MSGS (CONTAINER) Message: SQL
Anywhere Error -111: Index name 'ACTIVEMQ_MSGS_CIDX' not unique SQLState:
52W04 Vendor code: 1921
2007-07-13 20:12:18,222 [main           ] WARN  DefaultJDBCAdapter            
- Could not create JDBC tables; they could already exist. Failure was:
CREATE INDEX ACTIVEMQ_MSGS_EIDX ON ACTIVEMQ_MSGS (EXPIRATION) Message: SQL
Anywhere Error -111: Index name 'ACTIVEMQ_MSGS_EIDX' not unique SQLState:
52W04 Vendor code: 1921
2007-07-13 20:12:18,222 [main           ] WARN  DefaultJDBCAdapter            
- Could not create JDBC tables; they could already exist. Failure was:
CREATE TABLE ACTIVEMQ_ACKS(CONTAINER VARCHAR(250) NOT NULL, CLIENT_ID
VARCHAR(250) NOT NULL, SUB_NAME VARCHAR(250) NOT NULL, SELECTOR
VARCHAR(250), LAST_ACKED_ID INTEGER, PRIMARY KEY ( CONTAINER, CLIENT_ID,
SUB_NAME)) Message: SQL Anywhere Error -110: Item 'ACTIVEMQ_ACKS' already
exists SQLState: 52010 Vendor code: 12006
2007-07-13 20:12:18,222 [main           ] WARN  DefaultJDBCAdapter            
- Could not create JDBC tables; they could already exist. Failure was:
CREATE TABLE ACTIVEMQ_LOCK( ID BIGINT NOT NULL, TIME BIGINT, BROKER_NAME
VARCHAR(250), PRIMARY KEY (ID) ) Message: SQL Anywhere Error -131: Syntax
error near 'TIME' on line 1 SQLState: 42W04 Vendor code: 102
2007-07-13 20:12:18,847 [JMX connector  ] INFO  ManagementContext             
- JMX consoles can connect to
service:jmx:rmi:///jndi/rmi://localhost:1099/jmxrmi
2007-07-13 20:12:18,862 [main           ] INFO  TransportServerThreadSupport  
- Listening for connections at: tcp://xfsong-laptop:61616
2007-07-13 20:12:18,878 [main           ] INFO  TransportConnector            
- Connector default Started
2007-07-13 20:12:18,878 [main           ] INFO  TransportServerThreadSupport  
- Listening for connections at: stomp://xfsong-laptop:61613
2007-07-13 20:12:18,878 [main           ] INFO  TransportConnector            
- Connector stomp Started


When I am sending messages using DeliveryMode.PERSISTENT tag in my message
producer to a queue I didn't find any messages actually persisted to my
database. I found the table ACTIVEMQ_MSGS was already created by activemq
but there is no data in it.

My consumer can consume those messages but after I restart activemq all the
messages are gone. Can anybody tell me anything wrong?

Thanks,
Chris
-- 
View this message in context: http://www.nabble.com/ActiveMQ-jdbc-persistence-with-Sybase-SQL-Anywhere-tf4073989s2354.html#a11578387
Sent from the ActiveMQ - User mailing list archive at Nabble.com.