db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davi...@apache.org
Subject svn commit: r390176 - in /db/derby/code/trunk/java: build/org/apache/derbyBuild/ client/org/apache/derby/client/am/ engine/org/apache/derby/loc/ shared/org/apache/derby/shared/common/reference/ testing/org/apache/derbyTesting/functionTests/tests/jdbc4/...
Date Thu, 30 Mar 2006 16:56:27 GMT
Author: davidvc
Date: Thu Mar 30 08:56:25 2006
New Revision: 390176

URL: http://svn.apache.org/viewcvs?rev=390176&view=rev
Log:
DERBY-1149 : Fix failures in StatementTest.java.  I also added
a new constants file for testing that contains all the standard
SQL State strings.  Derby-specific SQL States can be added as
needed.

Passes derbyall, except for the sysinfo tests, which is a known regression
when running against the classes directory.


Added:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java
  (with props)
Modified:
    db/derby/code/trunk/java/build/org/apache/derbyBuild/splitmessages.java
    db/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java
    db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties
    db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/BaseJDBCTestCase.java

Modified: db/derby/code/trunk/java/build/org/apache/derbyBuild/splitmessages.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/build/org/apache/derbyBuild/splitmessages.java?rev=390176&r1=390175&r2=390176&view=diff
==============================================================================
--- db/derby/code/trunk/java/build/org/apache/derbyBuild/splitmessages.java (original)
+++ db/derby/code/trunk/java/build/org/apache/derbyBuild/splitmessages.java Thu Mar 30 08:56:25
2006
@@ -52,7 +52,7 @@
         // Add message ids that don't start with XJ here
         clientMessageIds.add(SQLState.NO_CURRENT_CONNECTION);
         clientMessageIds.add(SQLState.NOT_IMPLEMENTED);
-        clientMessageIds.add(SQLState.CANNOT_CLOSE_ACTIVE_XA_CONNECTION);
+        clientMessageIds.add(SQLState.CANNOT_CLOSE_ACTIVE_CONNECTION);
         clientMessageIds.add(SQLState.XACT_SAVEPOINT_RELEASE_ROLLBACK_FAIL);
     }
 

Modified: db/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java?rev=390176&r1=390175&r2=390176&view=diff
==============================================================================
--- db/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java (original)
+++ db/derby/code/trunk/java/client/org/apache/derby/client/am/Connection.java Thu Mar 30
08:56:25 2006
@@ -711,7 +711,7 @@
         // The following precondition matches CLI semantics, see SQLDisconnect()
         if (!autoCommit_ && inUnitOfWork_ && !allowCloseInUOW_()) {
             throw new SqlException(agent_.logWriter_,
-                    new MessageId (SQLState.CANNOT_CLOSE_ACTIVE_XA_CONNECTION));        
          
+                    new MessageId (SQLState.CANNOT_CLOSE_ACTIVE_CONNECTION));           
       
         }
     }
 

Modified: db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties?rev=390176&r1=390175&r2=390176&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/loc/messages_en.properties Thu Mar 30
08:56:25 2006
@@ -1042,6 +1042,8 @@
 
 # Transaction states, matches DB2
 25000=Invalid transaction state.
+25001=Cannot close a connection while a transaction is still active.
+
 
 # Authorization
 25501=Unable to set the connection read-only property in an active transaction.

Modified: db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java?rev=390176&r1=390175&r2=390176&view=diff
==============================================================================
--- db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java
(original)
+++ db/derby/code/trunk/java/shared/org/apache/derby/shared/common/reference/SQLState.java
Thu Mar 30 08:56:25 2006
@@ -712,6 +712,8 @@
 	String LANG_NOT_AN_XML_DOCUMENT                                    = "2200L";
 
 	String LANG_INVALID_TRANSACTION_STATE                              = "25000";
+    String CANNOT_CLOSE_ACTIVE_CONNECTION                              = "25001";
+
 
 	String LANG_UNEXPECTED_USER_EXCEPTION                              = "38000";
 	String EXTERNAL_ROUTINE_NO_SQL									   = "38001";

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java?rev=390176&r1=390175&r2=390176&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/StatementTest.java
Thu Mar 30 08:56:25 2006
@@ -22,6 +22,7 @@
 
 import org.apache.derby.shared.common.reference.SQLState;
 import org.apache.derbyTesting.functionTests.util.BaseJDBCTestCase;
+import org.apache.derbyTesting.functionTests.util.SQLStateConstants;
 
 import junit.framework.*;
 
@@ -169,18 +170,22 @@
             con.close();
             fail("Invalid transaction state exception was not thrown");
         } catch (SQLException sqle) {
-            if (usingEmbedded()) {
-                assertEquals("Unexpected exception thrown: " + sqle.getMessage(),
-                        SQLState.LANG_INVALID_TRANSACTION_STATE,
-                        sqle.getSQLState());
-            } else {
-                // TODO: Compare with SQLState when implemented on the client side.
-                assertEquals("Unexpected exception thrown: " + sqle.getMessage(),
-                        "java.sql.Connection.close() requested while a " +
-                        "transaction is in progress on the connection.The " +
-                        "transaction remains active, and the connection " +
-                        "cannot be closed.",
-                        sqle.getMessage());
+            // The SQL State is incorrect in the embedded client, see
+            // JIRA id DERBY-1168
+            String expectedState;
+            if ( this.usingDerbyNetClient() )
+                expectedState = SQLStateConstants.INVALID_TRANSACTION_STATE_ACTIVE_SQL_TRANSACTION;
+            else
+                expectedState = SQLStateConstants.INVALID_TRANSACTION_STATE_NO_SUBCLASS;
+            
+            if ( ! expectedState.equals(sqle.getSQLState()) )
+            {
+                System.err.println("ERROR: Unexpected SQL State encountered; "
+                    + "got " + sqle.getSQLState() + ", expected " 
+                    + expectedState +
+                    ". Unexpected exception message is " + sqle.getMessage());
+                
+                throw sqle;
             }
         }
         assertFalse("Statement should still be open, because " +

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/BaseJDBCTestCase.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/BaseJDBCTestCase.java?rev=390176&r1=390175&r2=390176&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/BaseJDBCTestCase.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/BaseJDBCTestCase.java
Thu Mar 30 08:56:25 2006
@@ -219,12 +219,18 @@
             throw new IllegalArgumentException("Exception cannot be null " +
                                                "when asserting SQLState");
         }
-        // Make sure the expected SQLState is 5 characters long, if not null.
-        // If it is too short, we let it be.
-        if (expected != null && expected.length() > 5) {
-            expected = expected.substring(0, 5);
-        }
-        assertEquals(message, expected, exception.getSQLState());
+        
+        String state = exception.getSQLState();
+        
+        if ( state != null )
+            assertTrue("The exception's SQL state must be five characters long",
+                exception.getSQLState().length() == 5);
+        
+        if ( expected != null )
+            assertTrue("The expected SQL state must be five characters long",
+                expected.length() == 5);
+        
+        assertEquals(message, expected, state);
     }
     
     /**

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java?rev=390176&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java
(added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java
Thu Mar 30 08:56:25 2006
@@ -0,0 +1,339 @@
+/*
+    Derby - Class org.apache.derbyTesting.functionTests.util.SQLState
+
+    Copyright 2006 The Apache Software Foundation or its licensors, as applicable.
+     
+    Licensed under the Apache License, Version 2.0 (the "License");
+    you may not use this file except in compliance with the License.
+    You may obtain a copy of the License at
+     
+    http =//www.apache.org/licenses/LICENSE-2.0
+    
+    Unless required by applicable law or agreed to in writing, software
+    distributed under the License is distributed on an "AS IS" BASIS,
+    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+    See the License for the specific language governing permissions and
+    limitations under the License.
+   
+*/
+package org.apache.derbyTesting.functionTests.util;
+    
+/**
+ * This contains constants for all the standard SQL states as well as
+ * for those that are specific to Derby that our tests compare against
+ * to make sure the right error is thrown.
+ *
+ * It is important to use these constants rather than those in
+ * org.apache.derby.shared.common.reference.SQLState.java because
+ * (a) that class is not part of the public API and (b) that class contains
+ * message ids, not SQL states.
+*/
+public class SQLStateConstants
+{
+    // ==== STANDARD SQL STATES =====
+    // These are derived from the ISO SQL2003 specification
+    // INCITS-ISO-IEC-9075-2-2003
+    //
+    public static final String AMBIGUOUS_CURSOR_NAME_NO_SUBCLASS 
+        = "3C000";
+    public static final String ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN_NO_SUBCLASS 
+        = "0U000";
+    public static final String ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN_NO_SUBCLASS 
+        = "0V000";
+    public static final String CARDINALITY_VIOLATION_NO_SUBCLASS 
+        = "21000";
+    public static final String CLI_SPECIFIC_CONDITION_NO_SUBCLASS 
+        = "HY000";
+    public static final String CONNECTION_EXCEPTION_NO_SUBCLASS 
+        = "08000";
+    public static final String CONNECTION_EXCEPTION_CONNECTION_DOES_NOT_EXIST 
+        = "08003";
+    public static final String CONNECTION_EXCEPTION_CONNECTION_FAILURE 
+        = "08006";
+    public static final String CONNECTION_EXCEPTION_CONNECTION_NAME_IN_USE 
+        = "08002";
+    public static final String CONNECTION_EXCEPTION_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION

+        = "08001";
+    public static final String CONNECTION_EXCEPTION_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION

+        = "08004";
+    public static final String CONNECTION_EXCEPTION_TRANSACTION_RESOLUTION_UNKNOWN 
+        = "08007";
+    public static final String DATA_EXCEPTION_NO_SUBCLASS 
+        = "22000";
+    public static final String DATA_EXCEPTION_ARRAY_ELEMENT_ERROR
+        = "2202E";
+    public static final String DATA_EXCEPTION_CHARACTER_NOT_IN_REPERTOIRE 
+        = "22021";
+    public static final String DATA_EXCEPTION_DATETIME_FIELD_OVERFLOW 
+        = "22008";
+    public static final String DATA_EXCEPTION_DIVISION_BY_ZERO 
+        = "22012";
+    public static final String DATA_EXCEPTION_ERROR_IN_ASSIGNMENT 
+        = "22005";
+    public static final String DATA_EXCEPTION_ESCAPE_CHARACTER_CONFLICT 
+        = "2200B";
+    public static final String DATA_EXCEPTION_INDICATOR_OVERFLOW 
+        = "22022";
+    public static final String DATA_EXCEPTION_INTERVAL_FIELD_OVERFLOW 
+        = "22015";
+    public static final String DATA_EXCEPTION_INTERVAL_VALUE_OUT_OF_RANGE 
+        = "2200P";
+    public static final String DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM 
+        = "2201E";
+    public static final String DATA_EXCEPTION_INVALID_ARGUMENT_FOR_POWER_FUNCTION 
+        = "2201F";
+    public static final String DATA_EXCEPTION_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION

+        = "2201G";
+    public static final String DATA_EXCEPTION_INVALID_CHARACTER_VALUE_FOR_CAST 
+        = "22018";
+    public static final String DATA_EXCEPTION_INVALID_DATETIME_FORMAT 
+        = "22007";
+    public static final String DATA_EXCEPTION_INVALID_ESCAPE_CHARACTER 
+        = "22019";
+    public static final String DATA_EXCEPTION_INVALID_ESCAPE_OCTET
+        = "2200D";
+    public static final String DATA_EXCEPTION_INVALID_ESCAPE_SEQUENCE 
+        = "22025";
+    public static final String DATA_EXCEPTION_INVALID_INDICATOR_PARAMETER_VALUE 
+        = "22010";
+    public static final String DATA_EXCEPTION_INVALID_INTERVAL_FORMAT 
+        = "22006";
+    public static final String DATA_EXCEPTION_INVALID_PARAMETER_VALUE 
+        = "22023";
+    public static final String DATA_EXCEPTION_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION

+        = "22013";
+    public static final String DATA_EXCEPTION_INVALID_REGULAR_EXPRESSION 
+        = "2201B";
+    public static final String DATA_EXCEPTION_INVALID_REPEAT_ARGUMENT_IN_A_SAMPLE_CLAUSE

+        = "2202G";
+    public static final String DATA_EXCEPTION_INVALID_SAMPLE_SIZE 
+        = "2202H";
+    public static final String DATA_EXCEPTION_INVALID_TIME_ZONE_DISPLACEMENT_VALUE 
+        = "22009";
+    public static final String DATA_EXCEPTION_INVALID_USE_OF_ESCAPE_CHARACTER 
+        = "2200C";
+    public static final String DATA_EXCEPTION_NULL_VALUE_NO_INDICATOR_PARAMETER
+        = "2200G";
+    public static final String DATA_EXCEPTION_MOST_SPECIFIC_TYPE_MISMATCH 
+        = "22002";
+    public static final String DATA_EXCEPTION_MULTISET_VALUE_OVERFLOW 
+        = "2200Q";
+    public static final String DATA_EXCEPTION_NONCHARACTER_IN_UCS_STRING 
+        = "22029";
+    public static final String DATA_EXCEPTION_NULL_VALUE_NOT_ALLOWED 
+        = "22004";
+    public static final String DATA_EXCEPTION_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER

+        = "2202D";
+    public static final String DATA_EXCEPTION_NUMERIC_VALUE_OUT_OF_RANGE 
+        = "22003";
+    public static final String DATA_EXCEPTION_SEQUENCE_GENERATOR_LIMIT_EXCEEDED 
+        = "2200H";
+    public static final String DATA_EXCEPTION_STRING_DATA_LENGTH_MISMATCH 
+        = "22026";
+    public static final String DATA_EXCEPTION_STRING_DATA_RIGHT_TRUNCATION 
+        = "22001";
+    public static final String DATA_EXCEPTION_SUBSTRING_ERROR 
+        = "22011";
+    public static final String DATA_EXCEPTION_TRIM_ERROR 
+        = "22027";
+    public static final String DATA_EXCEPTION_UNTERMINATED_C_STRING 
+        = "22024";
+    public static final String DATA_EXCEPTION_ZERO_LENGTH_CHARACTER_STRING 
+        = "2200F";
+    public static final String DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST_NO_SUBCLASS 
+        = "2B000";
+    public static final String DIAGNOSTICS_EXCEPTION_NO_SUBCLASS 
+        = "0Z000";
+    public static final String DIAGNOSTICS_EXCEPTION_MAXIMUM_NUMBER_OF_DIAGNOSTICS_AREAS_EXCEEDED

+        = "0Z001";
+    public static final String DYNAMIC_SQL_ERROR_NO_SUBCLASS 
+        = "07000";
+    public static final String DYNAMIC_SQL_ERROR_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED

+        = "07003";
+    public static final String DYNAMIC_SQL_ERROR_INVALID_DATETIME_INTERVAL_CODE 
+        = "0700F";
+    public static final String DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_COUNT 
+        = "07008";
+    public static final String DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_INDEX 
+        = "07009";
+    public static final String DYNAMIC_SQL_ERROR_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION

+        = "07005";
+    public static final String DYNAMIC_SQL_ERROR_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION

+        = "07006";
+    public static final String DYNAMIC_SQL_ERROR_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION 
+        = "0700B";
+    public static final String DYNAMIC_SQL_ERROR_INVALID_DATA_TARGET 
+        = "0700D";
+    public static final String DYNAMIC_SQL_ERROR_INVALID_LEVEL_VALUE 
+        = "0700E";
+    public static final String DYNAMIC_SQL_ERROR_UNDEFINED_DATA_VALUE 
+        = "0700C";
+    public static final String DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPEC

+        = "07001";
+    public static final String DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPEC

+        = "07002";
+    public static final String DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS

+        = "07004";
+    public static final String DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS

+        = "07007";
+    public static final String EXTERNAL_ROUTINE_EXCEPTION_NO_SUBCLASS 
+        = "38000";
+    public static final String EXTERNAL_ROUTINE_EXCEPTION_CONTAINING_SQL_NOT_PERMITTED 
+        = "38001";
+    public static final String EXTERNAL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED

+        = "38002";
+    public static final String EXTERNAL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED

+        = "38003";
+    public static final String EXTERNAL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED

+        = "38004";
+    public static final String EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NO_SUBCLASS 
+        = "39000";
+    public static final String EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NULL_VALUE_NOT_ALLOWED

+        = "39004";
+    public static final String FEATURE_NOT_SUPPORTED_NO_SUBCLASS 
+        = "0A000";
+    public static final String FEATURE_NOT_SUPPORTED_MULTIPLE_ENVIRONMENT_TRANSACTIONS 
+        = "0A001";
+    public static final String INTEGRITY_CONSTRAINT_VIOLATION_NO_SUBCLASS 
+        = "23000";
+    public static final String INTEGRITY_CONSTRAINT_VIOLATION_RESTRICT_VIOLATION 
+        = "23001";
+    public static final String INVALID_AUTHORIZATION_SPECIFICATION_NO_SUBCLASS 
+        = "28000";
+    public static final String INVALID_CATALOG_NAME_NO_SUBCLASS 
+        = "3D000";
+    public static final String INVALID_CHARACTER_SET_NAME_NO_SUBCLASS 
+        = "2C000";
+    public static final String INVALID_COLLATION_NAME_NO_SUBCLASS 
+        = "2H000";
+    public static final String INVALID_CONDITION_NUMBER_NO_SUBCLASS 
+        = "35000";
+    public static final String INVALID_CONNECTION_NAME_NO_SUBCLASS 
+        = "2E000";
+    public static final String INVALID_CURSOR_NAME_NO_SUBCLASS 
+        = "34000";
+    public static final String INVALID_CURSOR_STATE_NO_SUBCLASS 
+        = "24000";
+    public static final String INVALID_GRANTOR_STATE_NO_SUBCLASS 
+        = "0L000";
+    public static final String INVALID_ROLE_SPECIFICATION 
+        = "0P000";
+    public static final String INVALID_SCHEMA_NAME_NO_SUBCLASS 
+        = "3F000";
+    public static final String INVALID_SCHEMA_NAME_LIST_SPECIFICATION_NO_SUBCLASS 
+        = "0E000";
+    public static final String INVALID_SQL_DESCRIPTOR_NAME_NO_SUBCLASS 
+        = "33000";
+    public static final String INVALID_SQL_INVOKED_PROCEDURE_REFERENCE_NO_SUBCLASS 
+        = "0M000";
+    public static final String INVALID_SQL_STATEMENT 
+        = "30000";
+    public static final String INVALID_SQL_STATEMENT_IDENTIFIER_NO_SUBCLASS 
+        = "30000";
+    public static final String INVALID_SQL_STATEMENT_NAME_NO_SUBCLASS 
+        = "26000";
+    public static final String INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION_NO_SUBCLASS 
+        = "0S000";
+    public static final String INVALID_TRANSACTION_STATE_NO_SUBCLASS 
+        = "25000";
+    public static final String INVALID_TRANSACTION_STATE_ACTIVE_SQL_TRANSACTION 
+        = "25001";
+    public static final String INVALID_TRANSACTION_STATE_BRANCH_TRANSACTION_ALREADY_ACTIVE

+        = "25002";
+    public static final String INVALID_TRANSACTION_STATE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL

+        = "25008";
+    public static final String INVALID_TRANSACTION_STATE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION

+        = "25003";
+    public static final String INVALID_TRANSACTION_STATE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION

+        = "25004";
+    public static final String INVALID_TRANSACTION_STATE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION

+        = "25005";
+    public static final String INVALID_TRANSACTION_STATE_READ_ONLY_SQL_TRANSACTION 
+        = "25006";
+    public static final String INVALID_TRANSACTION_STATE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED

+        = "25007";
+    public static final String INVALID_TRANSACTION_INITIATION_NO_SUBCLASS 
+        = "0B000";
+    public static final String INVALID_TRANSACTION_TERMINATION_NO_SUBCLASS 
+        = "2D000";
+    public static final String LOCATOR_EXCEPTION_INVALID_SPECIFICATION 
+        = "0F001";
+    public static final String LOCATOR_EXCEPTION_NO_SUBCLASS 
+        = "0F000";
+    public static final String NO_DATA_NO_SUBCLASS 
+        = "02000";
+    public static final String NO_DATA_NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED 
+        = "02001";
+    public static final String REMOTE_DATABASE_ACCESS_NO_SUBCLASS 
+        = "HZ000";
+    public static final String SAVEPOINT_EXCEPTION_INVALID_SPECIFICATION 
+        = "3B001";
+    public static final String SAVEPOINT_EXCEPTION_NO_SUBCLASS 
+        = "3B000";
+    public static final String SAVEPOINT_EXCEPTION_TOO_MANY 
+        = "3B002";
+    public static final String SQL_ROUTINE_EXCEPTION_NO_SUBCLASS 
+        = "2F000";
+    public static final String SQL_ROUTINE_EXCEPTION_FUNCTION_EXECUTED_NO_RETURN_STATEMENT

+        = "2F005";
+    public static final String SQL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED 
+        = "2F002";
+    public static final String SQL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED 
+        = "2F003";
+    public static final String SQL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED 
+        = "2F004";
+    public static final String SUCCESSFUL_COMPLETION_NO_SUBCLASS 
+        = "00000";
+    public static final String SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_NO_SUBCLASS 
+        = "42000";
+    public static final String SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DIRECT_STATEMENT_NO_SUBCLASS

+        = "2A000";
+    public static final String SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DYNAMIC_STATEMENT_NO_SUBCLASS

+        = "37000";
+    public static final String TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION_NO_SUBCLASS

+        = "0T000";
+    public static final String TRANSACTION_ROLLBACK_NO_SUBCLASS 
+        = "40000";
+    public static final String TRANSACTION_ROLLBACK_INTEGRITY_CONSTRAINT_VIOLATION 
+        = "40002";
+    public static final String TRANSACTION_ROLLBACK_SERIALIZATION_FAILURE 
+        = "40001";
+    public static final String TRANSACTION_ROLLBACK_STATEMENT_COMPLETION_UNKNOWN 
+        = "40003";
+    public static final String TRIGGERED_DATA_CHANGE_VIOLATION_NO_SUBCLASS 
+        = "27000";
+    public static final String WARNING_NO_SUBCLASS 
+        = "01000";
+    public static final String WARNING_ADDITIONAL_RESULT_SETS_RETURNED 
+        = "0100D";
+    public static final String WARNING_ARRAY_DATA_RIGHT_TRUNCATION 
+        = "0102F";
+    public static final String WARNING_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS 
+        = "0100E";
+    public static final String WARNING_CURSOR_OPERATION_CONFLICT 
+        = "01001";
+    public static final String WARNING_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA 
+        = "0100B";
+    public static final String WARNING_DISCONNECT_ERROR 
+        = "01002";
+    public static final String WARNING_DYNAMIC_RESULT_SETS_RETURNED 
+        = "0100C";
+    public static final String WARNING_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS 
+        = "01005";
+    public static final String WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION 
+        = "01003";
+    public static final String WARNING_PRIVILEGE_NOT_GRANTED 
+        = "01007";
+    public static final String WARNING_PRIVILEGE_NOT_REVOKED 
+        = "01006";
+    public static final String WARNING_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA 
+        = "0100A";
+    public static final String WARNING_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA 
+        = "01009";
+    public static final String WARNING_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA 
+        = "0100F";
+    public static final String WARNING_STRING_DATA_RIGHT_TRUNCATION_WARNING 
+        = "01004";
+    public static final String WITH_CHECK_OPTION_VIOLATION_NO_SUBCLASS 
+        = "44000";
+}
\ No newline at end of file

Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/SQLStateConstants.java
------------------------------------------------------------------------------
    svn:eol-style = native



Mime
View raw message