[jboss-user] [JBoss Messaging] - Error with messaging-1.2.0.GA and MS SQL Server 2005

[garyetcc]

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