activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yair <y...@sundaysky.com>
Subject activemq and sql server 2008
Date Wed, 20 Jan 2010 07:39:54 GMT

Hi all
I'm trying to configure a master/slave conf with JDBC. I can't get the JDBC
to work with sql server 2008:

18:02:45,875 [main] WARN  JDBCPersistenceAdapter - Database driver NOT
recognized: [microsoft_sql_server_jdbc_driver_2_0].  Will use default JDBC
implementation.
18:02:46,125 [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 BLOB, PRIMARY KEY ( ID ) ) Message: Column,
parameter, or variable #6: Cannot find data type BLOB. SQLState: S0007
Vendor code: 2715
18:02:46,203 [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: Cannot find the object
"ACTIVEMQ_MSGS" because it does not exist or you do not have permissions.
SQLState: S00012 Vendor code: 1088
18:02:46,203 [main] WARN  DefaultJDBCAdapter - Could not create JDBC tables;
they could already exist. Failure was: CREATE INDEX ACTIVEMQ_MSGS_CIDX ON
ACTIVEMQ_MSGS (CONTAINER) Message: Cannot find the object "ACTIVEMQ_MSGS"
because it does not exist or you do not have permissions. SQLState: S00012
Vendor code: 1088
18:02:46,203 [main] WARN  DefaultJDBCAdapter - Could not create JDBC tables;
they could already exist. Failure was: CREATE INDEX ACTIVEMQ_MSGS_EIDX ON
ACTIVEMQ_MSGS (EXPIRATION) Message: Cannot find the object "ACTIVEMQ_MSGS"
because it does not exist or you do not have permissions. SQLState: S00012
Vendor code: 1088
18:02:46,265 [main] ERROR DefaultDatabaseLocker - Failed to acquire lock:
com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: FOR UPDATE clause
allowed only for DECLARE CURSOR.

I read around that this (the last line at least) is a known issue with sql
server 2005. Is there a fix for sql server 2008?

Thanks,
Yair
-- 
View this message in context: http://old.nabble.com/activemq-and-sql-server-2008-tp27237830p27237830.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.


Mime
View raw message