ARTEMIS-1660: Remove oracle12 autoincrement from column id for journal tables
Project: http://git-wip-us.apache.org/repos/asf/activemq-artemis/repo Commit: http://git-wip-us.apache.org/repos/asf/activemq-artemis/commit/722ef6aa Tree: http://git-wip-us.apache.org/repos/asf/activemq-artemis/tree/722ef6aa Diff: http://git-wip-us.apache.org/repos/asf/activemq-artemis/diff/722ef6aa Branch: refs/heads/master Commit: 722ef6aa6c09eaf344d5eac6a8ded1880735ed81 Parents: d6f9f81 Author: Benjamin Graf <benjamin.g...@gmx.net> Authored: Mon Feb 12 20:56:20 2018 +0100 Committer: Clebert Suconic <clebertsuco...@apache.org> Committed: Tue Mar 6 18:47:52 2018 -0500 ---------------------------------------------------------------------- artemis-jdbc-store/src/main/resources/journal-sql.properties | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/activemq-artemis/blob/722ef6aa/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 e83efe5..f659ad4 100644 --- a/artemis-jdbc-store/src/main/resources/journal-sql.properties +++ b/artemis-jdbc-store/src/main/resources/journal-sql.properties @@ -79,7 +79,7 @@ table-names-case.mysql=lower # Oracle SQL statements create-file-table.oracle=CREATE TABLE %s(ID NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID)) -create-journal-table.oracle=CREATE TABLE %s(id NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY,recordType NUMBER(5),compactCount NUMBER(5),txId NUMBER(19),userRecordType NUMBER(5),variableSize NUMBER(10),record BLOB,txDataSize NUMBER(10),txData BLOB,txCheckNoRecords NUMBER(10),seq NUMBER(19)) +create-journal-table.oracle=CREATE TABLE %s(id NUMBER(19),recordType NUMBER(5),compactCount NUMBER(5),txId NUMBER(19),userRecordType NUMBER(5),variableSize NUMBER(10),record BLOB,txDataSize NUMBER(10),txData BLOB,txCheckNoRecords NUMBER(10),seq NUMBER(19)) # 4 GiB max-blob-size.oracle=4294967296