When trying to use Sybase XA drivers as persistence for and ActiveMQ 5.1.0
Sybase throws the error 'Invalid column name 'time'. I assume I have
configured something wrong - anyone have suggestions where my error could
be?
Here are the relevant Spring configurations
<!-- lets create an embedded ActiveMQ Broker-->
<amq:broker useJmx="false" persistent="true" id="broker">
<amq:persistenceAdapter>
<amq:journaledJDBC dataDirectory="${activemq.base}/data"
dataSource="#xaDataSource">
<amq:adapter>
<bean
class="org.apache.activemq.store.jdbc.adapter.SybaseJDBCAdapter" />
</amq:adapter>
</amq:journaledJDBC>
</amq:persistenceAdapter>
<amq:transportConnectors>
<amq:transportConnector
uri="vm://localhost:61616?marshal=false"/>
</amq:transportConnectors>
</amq:broker>
<bean id="xaDataSource" destroy-method="close"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.sybase.jdbc3.jdbc.SybXADataSource"/>
<property name="url"
value="jdbc:sybase:Tds:localhost:5000/cithaeron"/>
<property name="username" value="developer"/>
<property name="password" value="developer"/>
<property name="defaultTransactionIsolation" value="2"/>
</bean>
Here is the log
Connected to server
INFO [http-8080-1] (LocalSessionFactoryBean.java:689) - Building new
Hibernate SessionFactory
WARN [http-8080-1] (DefaultJDBCAdapter.java:100) - Could not create JDBC
tables; they could already exist. Failure was: INSERT INTO ACTIVEMQ_LOCK(ID)
VALUES (1) Message: The column TIME in table ACTIVEMQ_LOCK does not allow
null values.
SQLState: 23000 Vendor code: 233
ERROR: ''
ERROR [ActiveMQ Cleanup Timer] (DefaultDatabaseLocker.java:109) - Failed to
update database lock: com.sybase.jdbc3.jdbc.SybSQLException: Invalid column
name 'time'.
com.sybase.jdbc3.jdbc.SybSQLException: Invalid column name 'time'.
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.updateLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at
org.apache.activemq.store.jdbc.DefaultDatabaseLocker.keepAlive(DefaultDatabaseLocker.java:104)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.databaseLockKeepAlive(JDBCPersistenceAdapter.java:458)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter$3.run(JDBCPersistenceAdapter.java:260)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at
java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)
WARN [ActiveMQ Cleanup Timer] (JDBCPersistenceAdapter.java:476) - Failed to
stop broker
--
View this message in context:
http://www.nabble.com/Invalid-column-name-%27time%27-when-using-Sybase-XA-tp17872586p17872586.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.
