I am trying to set up SQL server 2005 with messaging 1.2.0 GA,
mssql-persistence-service.xml provided in src/etc is used.
Below is the exception when tries to start up:
---------------------------------------------------------------------------------------
16:58:12,824 WARN [ServiceController] Problem starting service
jboss.messaging:service=Po
stOffice
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the
keyword 'CLUSTE
RED'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown S
ource)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unk
nown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatem
ent(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecut
ionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown So
ExceptionSe
looks like it does not like "CLUSTERED" to be used as a column name.
<mbean code="org.jboss.messaging.core.plugin.DefaultPostOfficeService"
name="jboss.messaging:service=PostOffice"
xmbean-dd="xmdesc/DefaultPostOffice-xmbean.xml">
<depends
optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer
jboss.jca:service=DataSourceBinding,name=DefaultDS
<depends
optional-attribute-name="TransactionManager">jboss:service=TransactionManager
JMS
java:/DefaultDS
true
<![CDATA[
CREATE_POSTOFFICE_TABLE=CREATE TABLE JBM_POSTOFFICE (POSTOFFICE_NAME
VARCHAR(255), NODE_ID SMALLINT, QUEUE_NAME VARCHAR(1023), COND VARCHAR(1023),
SELECTOR VARCHAR(1023), CHANNEL_ID INTEGER, CLUSTERED CHAR(1))
INSERT_BINDING=INSERT INTO JBM_POSTOFFICE (POSTOFFICE_NAME, NODE_ID,
QUEUE_NAME, COND, SELECTOR, CHANNEL_ID, CLUSTERED) VALUES (?, ?, ?, ?, ?, ?, ?)
DELETE_BINDING=DELETE FROM JBM_POSTOFFICE WHERE POSTOFFICE_NAME=? AND NODE_ID=?
AND QUEUE_NAME=?
LOAD_BINDINGS=SELECT NODE_ID, QUEUE_NAME, COND, SELECTOR, CHANNEL_ID, CLUSTERED
FROM JBM_POSTOFFICE WHERE POSTOFFICE_NAME = ?
]]>
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4026019#4026019
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4026019
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
