activemq-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ilya Shipitsin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMQ-6904) custom sql statements for SqlServer
Date Sat, 24 Feb 2018 18:52:00 GMT

    [ https://issues.apache.org/jira/browse/AMQ-6904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16375731#comment-16375731
] 

Ilya Shipitsin commented on AMQ-6904:
-------------------------------------

I created a PR https://github.com/apache/activemq/pull/276

> 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)

Mime
View raw message