You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by da...@apache.org on 2006/03/30 18:56:27 UTC
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/...
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