SQLStateConstants


1   /*
2       Derby - Class org.apache.derbyTesting.functionTests.util.SQLState
3   
4       Licensed to the Apache Software Foundation (ASF) under one or more
5       contributor license agreements.  See the NOTICE file distributed with
6       this work for additional information regarding copyright ownership.
7       The ASF licenses this file to You under the Apache License, Version 2.0
8       (the "License"); you may not use this file except in compliance with
9       the License.  You may obtain a copy of the License at
10       
11      http =//www.apache.org/licenses/LICENSE-2.0
12      
13      Unless required by applicable law or agreed to in writing, software
14      distributed under the License is distributed on an "AS IS" BASIS,
15      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16      See the License for the specific language governing permissions and
17      limitations under the License.
18     
19  */
20  package org.apache.derbyTesting.functionTests.util;
21      
22  /**
23   * This contains constants for all the standard SQL states as well as
24   * for those that are specific to Derby that our tests compare against
25   * to make sure the right error is thrown.
26   *
27   * It is important to use these constants rather than those in
28   * org.apache.derby.shared.common.reference.SQLState.java because
29   * (a) that class is not part of the public API and (b) that class contains
30   * message ids, not SQL states.
31  */
32  public class SQLStateConstants
33  {
34      // ==== STANDARD SQL STATES =====
35      // These are derived from the ISO SQL2003 specification
36      // INCITS-ISO-IEC-9075-2-2003
37      //
38      public static final String   AMBIGUOUS_CURSOR_NAME_NO_SUBCLASS 
39          = "3C000";
40      public static final String   ATTEMPT_TO_ASSIGN_TO_NON_UPDATABLE_COLUMN_NO_SUBCLASS 
41          = "0U000";
42      public static final String   ATTEMPT_TO_ASSIGN_TO_ORDERING_COLUMN_NO_SUBCLASS 
43          = "0V000";
44      public static final String   CARDINALITY_VIOLATION_NO_SUBCLASS 
45          = "21000";
46      public static final String   CLI_SPECIFIC_CONDITION_NO_SUBCLASS 
47          = "HY000";
48      public static final String   CONNECTION_EXCEPTION_NO_SUBCLASS 
49          = "08000";
50      public static final String   CONNECTION_EXCEPTION_CONNECTION_DOES_NOT_EXIST 
51          = "08003";
52      public static final String   CONNECTION_EXCEPTION_CONNECTION_FAILURE 
53          = "08006";
54      public static final String   CONNECTION_EXCEPTION_CONNECTION_NAME_IN_USE 
55          = "08002";
56      public static final String   CONNECTION_EXCEPTION_SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION 
57          = "08001";
58      public static final String   CONNECTION_EXCEPTION_SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION 
59          = "08004";
60      public static final String   CONNECTION_EXCEPTION_TRANSACTION_RESOLUTION_UNKNOWN 
61          = "08007";
62      public static final String   DATA_EXCEPTION_NO_SUBCLASS 
63          = "22000";
64      public static final String   DATA_EXCEPTION_ARRAY_ELEMENT_ERROR
65          = "2202E";
66      public static final String   DATA_EXCEPTION_CHARACTER_NOT_IN_REPERTOIRE 
67          = "22021";
68      public static final String   DATA_EXCEPTION_DATETIME_FIELD_OVERFLOW 
69          = "22008";
70      public static final String   DATA_EXCEPTION_DIVISION_BY_ZERO 
71          = "22012";
72      public static final String   DATA_EXCEPTION_ERROR_IN_ASSIGNMENT 
73          = "22005";
74      public static final String   DATA_EXCEPTION_ESCAPE_CHARACTER_CONFLICT 
75          = "2200B";
76      public static final String   DATA_EXCEPTION_INDICATOR_OVERFLOW 
77          = "22022";
78      public static final String   DATA_EXCEPTION_INTERVAL_FIELD_OVERFLOW 
79          = "22015";
80      public static final String   DATA_EXCEPTION_INTERVAL_VALUE_OUT_OF_RANGE 
81          = "2200P";
82      public static final String   DATA_EXCEPTION_INVALID_ARGUMENT_FOR_NATURAL_LOGARITHM 
83          = "2201E";
84      public static final String   DATA_EXCEPTION_INVALID_ARGUMENT_FOR_POWER_FUNCTION 
85          = "2201F";
86      public static final String   DATA_EXCEPTION_INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION 
87          = "2201G";
88      public static final String   DATA_EXCEPTION_INVALID_CHARACTER_VALUE_FOR_CAST 
89          = "22018";
90      public static final String   DATA_EXCEPTION_INVALID_DATETIME_FORMAT 
91          = "22007";
92      public static final String   DATA_EXCEPTION_INVALID_ESCAPE_CHARACTER 
93          = "22019";
94      public static final String   DATA_EXCEPTION_INVALID_ESCAPE_OCTET
95          = "2200D";
96      public static final String   DATA_EXCEPTION_INVALID_ESCAPE_SEQUENCE 
97          = "22025";
98      public static final String   DATA_EXCEPTION_INVALID_INDICATOR_PARAMETER_VALUE 
99          = "22010";
100     public static final String   DATA_EXCEPTION_INVALID_INTERVAL_FORMAT 
101         = "22006";
102     public static final String   DATA_EXCEPTION_INVALID_PARAMETER_VALUE 
103         = "22023";
104     public static final String   DATA_EXCEPTION_INVALID_PRECEDING_OR_FOLLOWING_SIZE_IN_WINDOW_FUNCTION 
105         = "22013";
106     public static final String   DATA_EXCEPTION_INVALID_REGULAR_EXPRESSION 
107         = "2201B";
108     public static final String   DATA_EXCEPTION_INVALID_REPEAT_ARGUMENT_IN_A_SAMPLE_CLAUSE 
109         = "2202G";
110     public static final String   DATA_EXCEPTION_INVALID_SAMPLE_SIZE 
111         = "2202H";
112     public static final String   DATA_EXCEPTION_INVALID_TIME_ZONE_DISPLACEMENT_VALUE 
113         = "22009";
114     public static final String   DATA_EXCEPTION_INVALID_USE_OF_ESCAPE_CHARACTER 
115         = "2200C";
116     public static final String   DATA_EXCEPTION_NULL_VALUE_NO_INDICATOR_PARAMETER
117         = "2200G";
118     public static final String   DATA_EXCEPTION_MOST_SPECIFIC_TYPE_MISMATCH 
119         = "22002";
120     public static final String   DATA_EXCEPTION_MULTISET_VALUE_OVERFLOW 
121         = "2200Q";
122     public static final String   DATA_EXCEPTION_NONCHARACTER_IN_UCS_STRING 
123         = "22029";
124     public static final String   DATA_EXCEPTION_NULL_VALUE_NOT_ALLOWED 
125         = "22004";
126     public static final String   DATA_EXCEPTION_NULL_VALUE_SUBSTITUTED_FOR_MUTATOR_SUBJECT_PARAMETER 
127         = "2202D";
128     public static final String   DATA_EXCEPTION_NUMERIC_VALUE_OUT_OF_RANGE 
129         = "22003";
130     public static final String   DATA_EXCEPTION_SEQUENCE_GENERATOR_LIMIT_EXCEEDED 
131         = "2200H";
132     public static final String   DATA_EXCEPTION_STRING_DATA_LENGTH_MISMATCH 
133         = "22026";
134     public static final String   DATA_EXCEPTION_STRING_DATA_RIGHT_TRUNCATION 
135         = "22001";
136     public static final String   DATA_EXCEPTION_SUBSTRING_ERROR 
137         = "22011";
138     public static final String   DATA_EXCEPTION_TRIM_ERROR 
139         = "22027";
140     public static final String   DATA_EXCEPTION_UNTERMINATED_C_STRING 
141         = "22024";
142     public static final String   DATA_EXCEPTION_ZERO_LENGTH_CHARACTER_STRING 
143         = "2200F";
144     public static final String   DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST_NO_SUBCLASS 
145         = "2B000";
146     public static final String   DIAGNOSTICS_EXCEPTION_NO_SUBCLASS 
147         = "0Z000";
148     public static final String   DIAGNOSTICS_EXCEPTION_MAXIMUM_NUMBER_OF_DIAGNOSTICS_AREAS_EXCEEDED 
149         = "0Z001";
150     public static final String   DYNAMIC_SQL_ERROR_NO_SUBCLASS 
151         = "07000";
152     public static final String   DYNAMIC_SQL_ERROR_CURSOR_SPECIFICATION_CANNOT_BE_EXECUTED 
153         = "07003";
154     public static final String   DYNAMIC_SQL_ERROR_INVALID_DATETIME_INTERVAL_CODE 
155         = "0700F";
156     public static final String   DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_COUNT 
157         = "07008";
158     public static final String   DYNAMIC_SQL_ERROR_INVALID_DESCRIPTOR_INDEX 
159         = "07009";
160     public static final String   DYNAMIC_SQL_ERROR_PREPARED_STATEMENT_NOT_A_CURSOR_SPECIFICATION 
161         = "07005";
162     public static final String   DYNAMIC_SQL_ERROR_RESTRICTED_DATA_TYPE_ATTRIBUTE_VIOLATION 
163         = "07006";
164     public static final String   DYNAMIC_SQL_ERROR_DATA_TYPE_TRANSFORM_FUNCTION_VIOLATION 
165         = "0700B";
166     public static final String   DYNAMIC_SQL_ERROR_INVALID_DATA_TARGET 
167         = "0700D";
168     public static final String   DYNAMIC_SQL_ERROR_INVALID_LEVEL_VALUE 
169         = "0700E";
170     public static final String   DYNAMIC_SQL_ERROR_UNDEFINED_DATA_VALUE 
171         = "0700C";
172     public static final String   DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_DYNAMIC_PARAMETER_SPEC 
173         = "07001";
174     public static final String   DYNAMIC_SQL_ERROR_USING_CLAUSE_DOES_NOT_MATCH_TARGET_SPEC 
175         = "07002";
176     public static final String   DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_DYNAMIC_PARAMETERS 
177         = "07004";
178     public static final String   DYNAMIC_SQL_ERROR_USING_CLAUSE_REQUIRED_FOR_RESULT_FIELDS 
179         = "07007";
180     public static final String   EXTERNAL_ROUTINE_EXCEPTION_NO_SUBCLASS 
181         = "38000";
182     public static final String   EXTERNAL_ROUTINE_EXCEPTION_CONTAINING_SQL_NOT_PERMITTED 
183         = "38001";
184     public static final String   EXTERNAL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED 
185         = "38002";
186     public static final String   EXTERNAL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED 
187         = "38003";
188     public static final String   EXTERNAL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED 
189         = "38004";
190     public static final String   EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NO_SUBCLASS 
191         = "39000";
192     public static final String   EXTERNAL_ROUTINE_INVOCATION_EXCEPTION_NULL_VALUE_NOT_ALLOWED 
193         = "39004";
194     public static final String   FEATURE_NOT_SUPPORTED_NO_SUBCLASS 
195         = "0A000";
196     public static final String   FEATURE_NOT_SUPPORTED_MULTIPLE_ENVIRONMENT_TRANSACTIONS 
197         = "0A001";
198     public static final String   INTEGRITY_CONSTRAINT_VIOLATION_NO_SUBCLASS 
199         = "23000";
200     public static final String   INTEGRITY_CONSTRAINT_VIOLATION_RESTRICT_VIOLATION 
201         = "23001";
202     public static final String   INVALID_AUTHORIZATION_SPECIFICATION_NO_SUBCLASS 
203         = "28000";
204     public static final String   INVALID_CATALOG_NAME_NO_SUBCLASS 
205         = "3D000";
206     public static final String   INVALID_CHARACTER_SET_NAME_NO_SUBCLASS 
207         = "2C000";
208     public static final String   INVALID_COLLATION_NAME_NO_SUBCLASS 
209         = "2H000";
210     public static final String   INVALID_CONDITION_NUMBER_NO_SUBCLASS 
211         = "35000";
212     public static final String   INVALID_CONNECTION_NAME_NO_SUBCLASS 
213         = "2E000";
214     public static final String   INVALID_CURSOR_NAME_NO_SUBCLASS 
215         = "34000";
216     public static final String   INVALID_CURSOR_STATE_NO_SUBCLASS 
217         = "24000";
218     public static final String   INVALID_GRANTOR_STATE_NO_SUBCLASS 
219         = "0L000";
220     public static final String   INVALID_ROLE_SPECIFICATION 
221         = "0P000";
222     public static final String   INVALID_SCHEMA_NAME_NO_SUBCLASS 
223         = "3F000";
224     public static final String   INVALID_SCHEMA_NAME_LIST_SPECIFICATION_NO_SUBCLASS 
225         = "0E000";
226     public static final String   INVALID_SQL_DESCRIPTOR_NAME_NO_SUBCLASS 
227         = "33000";
228     public static final String   INVALID_SQL_INVOKED_PROCEDURE_REFERENCE_NO_SUBCLASS 
229         = "0M000";
230     public static final String   INVALID_SQL_STATEMENT 
231         = "30000";
232     public static final String   INVALID_SQL_STATEMENT_IDENTIFIER_NO_SUBCLASS 
233         = "30000";
234     public static final String   INVALID_SQL_STATEMENT_NAME_NO_SUBCLASS 
235         = "26000";
236     public static final String   INVALID_TRANSFORM_GROUP_NAME_SPECIFICATION_NO_SUBCLASS 
237         = "0S000";
238     public static final String   INVALID_TRANSACTION_STATE_NO_SUBCLASS 
239         = "25000";
240     public static final String   INVALID_TRANSACTION_STATE_ACTIVE_SQL_TRANSACTION 
241         = "25001";
242     public static final String   INVALID_TRANSACTION_STATE_BRANCH_TRANSACTION_ALREADY_ACTIVE 
243         = "25002";
244     public static final String   INVALID_TRANSACTION_STATE_HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL 
245         = "25008";
246     public static final String   INVALID_TRANSACTION_STATE_INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION 
247         = "25003";
248     public static final String   INVALID_TRANSACTION_STATE_INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION 
249         = "25004";
250     public static final String   INVALID_TRANSACTION_STATE_NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION 
251         = "25005";
252     public static final String   INVALID_TRANSACTION_STATE_READ_ONLY_SQL_TRANSACTION 
253         = "25006";
254     public static final String   INVALID_TRANSACTION_STATE_SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED 
255         = "25007";
256     public static final String   INVALID_TRANSACTION_INITIATION_NO_SUBCLASS 
257         = "0B000";
258     public static final String   INVALID_TRANSACTION_TERMINATION_NO_SUBCLASS 
259         = "2D000";
260     public static final String   LOCATOR_EXCEPTION_INVALID_SPECIFICATION 
261         = "0F001";
262     public static final String   LOCATOR_EXCEPTION_NO_SUBCLASS 
263         = "0F000";
264     public static final String   NO_DATA_NO_SUBCLASS 
265         = "02000";
266     public static final String   NO_DATA_NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED 
267         = "02001";
268     public static final String   REMOTE_DATABASE_ACCESS_NO_SUBCLASS 
269         = "HZ000";
270     public static final String   SAVEPOINT_EXCEPTION_INVALID_SPECIFICATION 
271         = "3B001";
272     public static final String   SAVEPOINT_EXCEPTION_NO_SUBCLASS 
273         = "3B000";
274     public static final String   SAVEPOINT_EXCEPTION_TOO_MANY 
275         = "3B002";
276     public static final String   SQL_ROUTINE_EXCEPTION_NO_SUBCLASS 
277         = "2F000";
278     public static final String   SQL_ROUTINE_EXCEPTION_FUNCTION_EXECUTED_NO_RETURN_STATEMENT 
279         = "2F005";
280     public static final String   SQL_ROUTINE_EXCEPTION_MODIFYING_SQL_DATA_NOT_PERMITTED 
281         = "2F002";
282     public static final String   SQL_ROUTINE_EXCEPTION_PROHIBITED_SQL_STATEMENT_ATTEMPTED 
283         = "2F003";
284     public static final String   SQL_ROUTINE_EXCEPTION_READING_SQL_DATA_NOT_PERMITTED 
285         = "2F004";
286     public static final String   SUCCESSFUL_COMPLETION_NO_SUBCLASS 
287         = "00000";
288     public static final String   SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_NO_SUBCLASS 
289         = "42000";
290     public static final String   SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DIRECT_STATEMENT_NO_SUBCLASS 
291         = "2A000";
292     public static final String   SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_IN_DYNAMIC_STATEMENT_NO_SUBCLASS 
293         = "37000";
294     public static final String   TARGET_TABLE_DISAGREES_WITH_CURSOR_SPECIFICATION_NO_SUBCLASS 
295         = "0T000";
296     public static final String   TRANSACTION_ROLLBACK_NO_SUBCLASS 
297         = "40000";
298     public static final String   TRANSACTION_ROLLBACK_INTEGRITY_CONSTRAINT_VIOLATION 
299         = "40002";
300     public static final String   TRANSACTION_ROLLBACK_SERIALIZATION_FAILURE 
301         = "40001";
302     public static final String   TRANSACTION_ROLLBACK_STATEMENT_COMPLETION_UNKNOWN 
303         = "40003";
304     public static final String   TRIGGERED_DATA_CHANGE_VIOLATION_NO_SUBCLASS 
305         = "27000";
306     public static final String   WARNING_NO_SUBCLASS 
307         = "01000";
308     public static final String   WARNING_ADDITIONAL_RESULT_SETS_RETURNED 
309         = "0100D";
310     public static final String   WARNING_ARRAY_DATA_RIGHT_TRUNCATION 
311         = "0102F";
312     public static final String   WARNING_ATTEMPT_TO_RETURN_TOO_MANY_RESULT_SETS 
313         = "0100E";
314     public static final String   WARNING_CURSOR_OPERATION_CONFLICT 
315         = "01001";
316     public static final String   WARNING_DEFAULT_VALUE_TOO_LONG_FOR_INFORMATION_SCHEMA 
317         = "0100B";
318     public static final String   WARNING_DISCONNECT_ERROR 
319         = "01002";
320     public static final String   WARNING_DYNAMIC_RESULT_SETS_RETURNED 
321         = "0100C";
322     public static final String   WARNING_INSUFFICIENT_ITEM_DESCRIPTOR_AREAS 
323         = "01005";
324     public static final String   WARNING_NULL_VALUE_ELIMINATED_IN_SET_FUNCTION 
325         = "01003";
326     public static final String   WARNING_PRIVILEGE_NOT_GRANTED 
327         = "01007";
328     public static final String   WARNING_PRIVILEGE_NOT_REVOKED 
329         = "01006";
330     public static final String   WARNING_QUERY_EXPRESSION_TOO_LONG_FOR_INFORMATION_SCHEMA 
331         = "0100A";
332     public static final String   WARNING_SEARCH_CONDITION_TOO_LONG_FOR_INFORMATION_SCHEMA 
333         = "01009";
334     public static final String   WARNING_STATEMENT_TOO_LONG_FOR_INFORMATION_SCHEMA 
335         = "0100F";
336     public static final String   WARNING_STRING_DATA_RIGHT_TRUNCATION_WARNING 
337         = "01004";
338     public static final String   WITH_CHECK_OPTION_VIOLATION_NO_SUBCLASS 
339         = "44000";
340     // The SQLState when calling next on a result set which is closed.
341     public static final String   RESULT_SET_IS_CLOSED = "XCL16";
342     //The SQLState of the SQLExcepion thrown when a class for which 
343     //isWrapperFor returns false is passed as a parameter to the 
344     //unwrap method.
345     public static final String   UNABLE_TO_UNWRAP = "XJ128";
346     
347     public static final String   LANG_GRANT_REVOKE_WITH_LEGACY_ACCESS = "42Z60";
348     public static final String   SHUTDOWN_DATABASE = "08006";
349     public static final String   PROPERTY_UNSUPPORTED_CHANGE = "XCY02";
350 }
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags