[AMQ-6904] custom sql statements for SqlServer

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.15.3
• Fix Version/s: 5.15.11, 5.16.0
• Component/s: JDBC
• Assignee: Jean-Baptiste Onofré
• Reporter: Ilya Shipitsin
• Created: 24/Feb/18 18:44
• Updated: 18/Nov/19 16:03
• Resolved: 18/Nov/19 16:03

Description

ms sql syntax is different, so we need custom statements

 

        <persistenceAdapter>
            <jdbcPersistenceAdapter dataSource="#mssql-ds" createTablesOnStartup="true"   >
              <statements>
                 <statements binaryDataType ="VARBINARY(MAX)" lockCreateStatement= "SELECT * FROM ACTIVEMQ_LOCK WITH (UPDLOCK, ROWLOCK) WHERE ID=1"/>
              </statements>
            </jdbcPersistenceAdapter>
        </persistenceAdapter>

Issue Links

• links to: GitHub Pull Request #276
• links to: GitHub Pull Request #276