This is an automated email from the ASF dual-hosted git repository.
clebertsuconic pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/activemq-artemis.git
The following commit(s) were added to refs/heads/master by this push:
new 4cf8f43 ARTEMIS-2729 JdbcLeaseLock won't work on SQL Server
new 8e3d85f This closes #3097
4cf8f43 is described below
commit 4cf8f43e46c88b5a4596c0f3c7a400eeb8953632
Author: Francesco Nigro <[email protected]>
AuthorDate: Tue Apr 21 16:17:12 2020 +0200
ARTEMIS-2729 JdbcLeaseLock won't work on SQL Server
---
artemis-jdbc-store/src/main/resources/journal-sql.properties | 2 ++
1 file changed, 2 insertions(+)
diff --git a/artemis-jdbc-store/src/main/resources/journal-sql.properties
b/artemis-jdbc-store/src/main/resources/journal-sql.properties
index 7b1421a..831d4bd 100644
--- a/artemis-jdbc-store/src/main/resources/journal-sql.properties
+++ b/artemis-jdbc-store/src/main/resources/journal-sql.properties
@@ -97,4 +97,6 @@ table-names-case.db2=upper
# MSSQL SQL statements
create-file-table.mssql=CREATE TABLE %s (ID BIGINT NOT NULL IDENTITY, FILENAME
VARCHAR(255), EXTENSION VARCHAR(10), DATA VARBINARY(max), PRIMARY KEY(ID))
create-journal-table.mssql=CREATE TABLE %s(id BIGINT,recordType
SMALLINT,compactCount SMALLINT,txId BIGINT,userRecordType SMALLINT,variableSize
INTEGER,record VARBINARY(max),txDataSize INTEGER,txData
VARBINARY(max),txCheckNoRecords INTEGER,seq BIGINT NOT NULL, PRIMARY KEY(seq))
+create-node-manager-store-table.mssql=CREATE TABLE %s (ID INT NOT NULL,
HOLDER_ID VARCHAR(128), HOLDER_EXPIRATION_TIME DATETIME, NODE_ID CHAR(36),STATE
CHAR(1), PRIMARY KEY(ID))
+current-timestamp.mssql=SELECT CURRENT_TIMESTAMP
max-blob-size.mssql=2147483647
\ No newline at end of file
