You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@activemq.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/02/24 18:47:00 UTC
[jira] [Commented] (AMQ-6904) custom sql statements for SqlServer
[ https://issues.apache.org/jira/browse/AMQ-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16375730#comment-16375730 ]
ASF GitHub Bot commented on AMQ-6904:
-------------------------------------
GitHub user chipitsine opened a pull request:
https://github.com/apache/activemq/pull/276
AMQ-6904 add overrides for ms sql
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/chipitsine/activemq master
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/activemq/pull/276.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #276
----
commit ee9921bd970e84a1ef1dc7497f152b5fc23754e7
Author: Ilya Shipitsin <ch...@...>
Date: 2018-02-24T18:45:10Z
AMQ-6904 add overrides for ms sql
----
> 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
> Priority: Major
>
> 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
(v7.6.3#76005)