activemq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gtu...@apache.org
Subject svn commit: r1038758 - /activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
Date Wed, 24 Nov 2010 18:38:04 GMT
Author: gtully
Date: Wed Nov 24 18:38:04 2010
New Revision: 1038758

URL: http://svn.apache.org/viewvc?rev=1038758&view=rev
Log:
https://issues.apache.org/activemq/browse/AMQ-2985 - fix order so alter table works for oracle
- ORA-30649:missing directory keyword

Modified:
    activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java

Modified: activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
URL: http://svn.apache.org/viewvc/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java?rev=1038758&r1=1038757&r2=1038758&view=diff
==============================================================================
--- activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
(original)
+++ activemq/trunk/activemq-core/src/main/java/org/apache/activemq/store/jdbc/Statements.java
Wed Nov 24 18:38:04 2010
@@ -99,7 +99,7 @@ public class Statements {
                 "INSERT INTO " + getFullLockTableName() + "(ID) VALUES (1)", 
                 "ALTER TABLE " + getFullMessageTableName() + " ADD PRIORITY " + sequenceDataType,
                 "CREATE INDEX " + getFullMessageTableName() + "_PIDX ON " + getFullMessageTableName()
+ " (PRIORITY)",
-                "ALTER TABLE " + getFullAckTableName() + " ADD PRIORITY " + sequenceDataType
 + " NOT NULL DEFAULT 5",
+                "ALTER TABLE " + getFullAckTableName() + " ADD PRIORITY " + sequenceDataType
 + " DEFAULT 5 NOT NULL",
                 "ALTER TABLE " + getFullAckTableName() + " DROP PRIMARY KEY",
                 "ALTER TABLE " + getFullAckTableName() + " ADD PRIMARY KEY (CONTAINER, CLIENT_ID,
SUB_NAME, PRIORITY)",
             };



Mime
View raw message