Repository: activemq-artemis
Updated Branches:
  refs/heads/artemis-1009 b3bf94270 -> 19608cb4c (forced update)


ARTEMIS-1010 Uppercase table name for Oracle


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

Branch: refs/heads/artemis-1009
Commit: f3b83831e0119c0afbfcb4824d4703bb70a99726
Parents: 61e10fe
Author: Martyn Taylor <[email protected]>
Authored: Wed Mar 1 16:34:49 2017 +0000
Committer: Clebert Suconic <[email protected]>
Committed: Thu Mar 2 19:40:08 2017 -0500

----------------------------------------------------------------------
 .../jdbc/store/drivers/oracle/Oracle12CSQLProvider.java       | 7 +------
 1 file changed, 1 insertion(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/activemq-artemis/blob/f3b83831/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/drivers/oracle/Oracle12CSQLProvider.java
----------------------------------------------------------------------
diff --git 
a/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/drivers/oracle/Oracle12CSQLProvider.java
 
b/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/drivers/oracle/Oracle12CSQLProvider.java
index accddfd..64e72f8 100644
--- 
a/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/drivers/oracle/Oracle12CSQLProvider.java
+++ 
b/artemis-jdbc-store/src/main/java/org/apache/activemq/artemis/jdbc/store/drivers/oracle/Oracle12CSQLProvider.java
@@ -21,11 +21,6 @@ import 
org.apache.activemq.artemis.jdbc.store.sql.SQLProvider;
 
 public class Oracle12CSQLProvider extends GenericSQLProvider {
 
-   /**
-   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))
-   max-blob-size.oracle=4294967296 **/
-
    private final String createFileTableSQL = "CREATE TABLE " + tableName + " 
(ID NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY, FILENAME VARCHAR(255), 
EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID))";
 
    private final String createJournalTableSQL = "CREATE TABLE " + tableName + 
" (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))";
@@ -33,7 +28,7 @@ public class Oracle12CSQLProvider extends GenericSQLProvider {
    private static final long MAX_BLOB_SIZE = 4294967296L; //4GB
 
    protected Oracle12CSQLProvider(String tableName) {
-      super(tableName);
+      super(tableName.toUpperCase());
    }
 
    @Override

Reply via email to