activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fazle Khan <fazlesk...@gmail.com>
Subject Invalid column name 'time' when using Sybase XA
Date Mon, 16 Jun 2008 20:21:28 GMT

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.


Mime
View raw message