[
https://issues.apache.org/jira/browse/AMQ-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16976660#comment-16976660
]
ASF subversion and git services commented on AMQ-6904:
------------------------------------------------------
Commit 0b28cb5aee1cf47b1e81437fc953552c9a018004 in activemq's branch
refs/heads/activemq-5.15.x from Ilya Shipitsin
[ https://gitbox.apache.org/repos/asf?p=activemq.git;h=0b28cb5 ]
AMQ-6904 add overrides for ms sql
(cherry picked from commit ee9921bd970e84a1ef1dc7497f152b5fc23754e7)
> custom sql statements for SqlServer
> -----------------------------------
>
> Key: AMQ-6904
> URL: https://issues.apache.org/jira/browse/AMQ-6904
> Project: ActiveMQ
> Issue Type: Improvement
> Components: JDBC
> Affects Versions: 5.15.3
> Reporter: Ilya Shipitsin
> Assignee: Jean-Baptiste Onofré
> Priority: Major
> Fix For: 5.16.0, 5.15.11
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> ms sql syntax is different, so we need custom statements
>
> {code:java}
> <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>{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
