Repository: activemq-artemis Updated Branches: refs/heads/2.6.x 737fbbab3 -> 31c9d38e4
ARTEMIS-2089 DB2 sending larger message (1MB) crashes the whole server It declares JDBC journal Blobs for IBM DB2 DBMS matching max-blob-size in order to allow to store data with size > 1 MB ie the default BLOB capacity (cherry picked from commit ead9b007579ad83fd6c808243e4c20035d4c4b4d) Project: http://git-wip-us.apache.org/repos/asf/activemq-artemis/repo Commit: http://git-wip-us.apache.org/repos/asf/activemq-artemis/commit/31c9d38e Tree: http://git-wip-us.apache.org/repos/asf/activemq-artemis/tree/31c9d38e Diff: http://git-wip-us.apache.org/repos/asf/activemq-artemis/diff/31c9d38e Branch: refs/heads/2.6.x Commit: 31c9d38e47c691f738ab9328a57e5538d5078d3f Parents: 737fbba Author: Francesco Nigro <[email protected]> Authored: Fri Sep 14 16:11:44 2018 +0200 Committer: Martyn Taylor <[email protected]> Committed: Tue Sep 18 11:47:30 2018 +0100 ---------------------------------------------------------------------- artemis-jdbc-store/src/main/resources/journal-sql.properties | 1 + 1 file changed, 1 insertion(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/activemq-artemis/blob/31c9d38e/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 86e6a3d..eb7a5a4 100644 --- a/artemis-jdbc-store/src/main/resources/journal-sql.properties +++ b/artemis-jdbc-store/src/main/resources/journal-sql.properties @@ -86,6 +86,7 @@ max-blob-size.oracle=4294967296 table-names-case.oracle=upper # DB2 SQL statements +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
