activemq-artemis git commit: ARTEMIS-2202 Improve MSSQL support for JDBC storage

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

activemq-artemis git commit: ARTEMIS-2202 Improve MSSQL support for JDBC storage

jbertram
Repository: activemq-artemis
Updated Branches:
  refs/heads/2.6.x cec5bbdfd -> 4256b2f7d


ARTEMIS-2202 Improve MSSQL support for JDBC storage

(cherry picked from commit 158227fcf369e86fdc2ce742bf19860db70f4b23)


Project: http://git-wip-us.apache.org/repos/asf/activemq-artemis/repo
Commit: http://git-wip-us.apache.org/repos/asf/activemq-artemis/commit/4256b2f7
Tree: http://git-wip-us.apache.org/repos/asf/activemq-artemis/tree/4256b2f7
Diff: http://git-wip-us.apache.org/repos/asf/activemq-artemis/diff/4256b2f7

Branch: refs/heads/2.6.x
Commit: 4256b2f7dcd5d35d3aa3c5f0d8311648a19b29a5
Parents: cec5bbd
Author: Francesco Nigro <[hidden email]>
Authored: Tue Dec 11 16:51:20 2018 +0100
Committer: Justin Bertram <[hidden email]>
Committed: Thu Dec 13 13:59:06 2018 -0600

----------------------------------------------------------------------
 artemis-jdbc-store/src/main/resources/journal-sql.properties | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/activemq-artemis/blob/4256b2f7/artemis-jdbc-store/src/main/resources/journal-sql.properties
----------------------------------------------------------------------
diff --git a/artemis-jdbc-store/src/main/resources/journal-sql.properties b/artemis-jdbc-store/src/main/resources/journal-sql.properties
index 45fe857..1ac4bff 100644
--- a/artemis-jdbc-store/src/main/resources/journal-sql.properties
+++ b/artemis-jdbc-store/src/main/resources/journal-sql.properties
@@ -89,4 +89,10 @@ table-names-case.oracle=upper
 create-journal-table.db2=CREATE TABLE %s(id BIGINT,recordType SMALLINT,compactCount SMALLINT,txId BIGINT,userRecordType SMALLINT,variableSize INTEGER,record BLOB(2G),txDataSize INTEGER,txData BLOB(2G),txCheckNoRecords INTEGER,seq BIGINT NOT NULL, PRIMARY KEY(seq))
 max-blob-size.db2=2147483647
 create-file-table.db2=CREATE TABLE %s (ID BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB(2G), PRIMARY KEY(ID))
-append-to-file.db2=UPDATE %s SET DATA = (DATA || ?) WHERE ID=?
\ No newline at end of file
+append-to-file.db2=UPDATE %s SET DATA = (DATA || ?) WHERE ID=?
+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))
+max-blob-size.mssql=2147483647
\ No newline at end of file