[1/2] activemq-artemis git commit: This closes #2461

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[1/2] activemq-artemis git commit: This closes #2461

jbertram
Repository: activemq-artemis
Updated Branches:
  refs/heads/master 456fbce5f -> e2448753a


This closes #2461


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

Branch: refs/heads/master
Commit: e2448753a05d108cf971523e9035d881d853986b
Parents: 456fbce 158227f
Author: Justin Bertram <[hidden email]>
Authored: Thu Dec 13 13:54:13 2018 -0600
Committer: Justin Bertram <[hidden email]>
Committed: Thu Dec 13 13:54:13 2018 -0600

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


Reply | Threaded
Open this post in threaded view
|

[2/2] activemq-artemis git commit: ARTEMIS-2202 Improve MSSQL support for JDBC storage

jbertram
ARTEMIS-2202 Improve MSSQL support for JDBC storage


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

Branch: refs/heads/master
Commit: 158227fcf369e86fdc2ce742bf19860db70f4b23
Parents: 456fbce
Author: Francesco Nigro <[hidden email]>
Authored: Tue Dec 11 16:51:20 2018 +0100
Committer: Justin Bertram <[hidden email]>
Committed: Thu Dec 13 13:54:13 2018 -0600

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


http://git-wip-us.apache.org/repos/asf/activemq-artemis/blob/158227fc/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 b8877ba..1ac4bff 100644
--- a/artemis-jdbc-store/src/main/resources/journal-sql.properties
+++ b/artemis-jdbc-store/src/main/resources/journal-sql.properties
@@ -90,4 +90,9 @@ create-journal-table.db2=CREATE TABLE %s(id BIGINT,recordType SMALLINT,compactCo
 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=?
-table-names-case.db2=upper
\ No newline at end of file
+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