You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@activemq.apache.org by "Ilya Shipitsin (JIRA)" <ji...@apache.org> on 2018/02/24 18:45:00 UTC
[jira] [Created] (AMQ-6904) custom sql statements for SqlServer
Ilya Shipitsin created AMQ-6904:
-----------------------------------
Summary: 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
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)