You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@activemq.apache.org by jb...@apache.org on 2018/12/13 19:54:47 UTC
[1/2] activemq-artemis git commit: This closes #2461
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 <jb...@apache.org>
Authored: Thu Dec 13 13:54:13 2018 -0600
Committer: Justin Bertram <jb...@apache.org>
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(-)
----------------------------------------------------------------------
[2/2] activemq-artemis git commit: ARTEMIS-2202 Improve MSSQL support
for JDBC storage
Posted by jb...@apache.org.
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 <ni...@gmail.com>
Authored: Tue Dec 11 16:51:20 2018 +0100
Committer: Justin Bertram <jb...@apache.org>
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