Source code: org/apache/derby/iapi/reference/SQLState.java
1 /*
2
3 Derby - Class org.apache.derby.iapi.reference.SQLState
4
5 Copyright 1999, 2004 The Apache Software Foundation or its licensors, as applicable.
6
7 Licensed under the Apache License, Version 2.0 (the "License");
8 you may not use this file except in compliance with the License.
9 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
21 package org.apache.derby.iapi.reference;
22
23
24 /**
25 List of error message identifiers.
26 This is the set of message identifiers. The message identifier
27 also encodes the SQLState as the first five characters.
28 StandardExceptions must be created using the static
29 StandardException.newException() method calls, passing in a
30 field from this class.
31 <BR>
32 The five character SQL State is obtained from a StandardException
33 using the zero-argument StandardException.getSQLState() method.
34 <BR>
35 The message identifier (ie. the value that matches a field in this class)
36 is obtained using the zero-argument StandardException.getMessageId() method.
37 <BR>
38 Thus if checking for a specific error using a field from this interface
39 the correct code is
40 <PRE>
41 if (se.getMessageId().equals(SQLState.DEADLOCK))
42 </PRE>
43 <BR>
44 A utility static method StandardException.getSQLState(String messageId)
45 exists to convert an field from this class into a five character SQLState.
46 <P>
47
48 <P>
49 The SQL state of an error message dictates the error's severity.
50 The severity is determined from the first two characters of the
51 state if the state is five characters long, otherwise the state
52 is expected to be 7 characters long and the last character determines
53 the state. If the state is seven characters long then only the first
54 five will be seen by the error reporting code and exception.
55 <BR>
56 If the state is 9 characters long, the last two characters encode
57 an exception category, which Synchronization uses to determine whether
58 the error causes REFRESH to halt or to simply skip the failed transaction.
59 All 5 and 7 character states default to the ENVIRONMENTAL exception
60 category.
61 <BR>
62 Here is the encoding of the SQL state, broken down by severity.
63 <UL>
64 <LI> <B> SYSTEM_SEVERITY </B>
65 xxxxx.M
66
67 <LI> <B> DATABASE_SEVERITY </B>
68 xxxxx.D
69
70 <LI> <B> SESSION_SEVERITY </B>
71 08xxx
72 xxxxx.C
73
74 <LI> <B> TRANSACTION_SEVERITY </B>
75 40xxx or xxxxx.T
76
77 <LI> <B> STATEMENT_SEVERITY </B>
78 {2,3}xxxx, 42xxx, 07xxx or xxxxx.S
79
80 <LI> <B> WARNING_SEVERITY </B>
81 01xxx <EM> SQL State rules require that warnings have states starting with 01</EM>
82
83 <LI> <B> NO_APPLICABLE_SEVERITY </B>
84 YYxxx (YY means none of the above) or xxxxx.U
85
86 <LI> <B> TRANSIENT exception category </B>
87 xxxxx.Y#T (Y can be any of the preceding severities)
88
89 <LI> <B> CONSISTENCY exception category </B>
90 xxxxx.Y#C (Y can be any of the preceding severities)
91
92 <LI> <B> ENVIRONMENTAL exception category (the default)</B>
93 xxxxx.Y#E (Y can be any of the preceding severities)
94
95 <LI> <B> WRAPPED exception category</B>
96 xxxxx.Y#W (Y can be any of the preceding severities)
97
98 </UL>
99 <HR>
100 <P>
101 <B>SQL State ranges</B>
102 <UL>
103 <LI>Basic Services
104 <UL>
105 <LI> XBCA CacheService
106 <LI> XBCM ClassManager
107 <LI> XBCX Cryptography
108 <LI> XBM0 Monitor
109 <LI> XBDA DataComm
110 <LI> XCY0 Properties
111 </UL>
112
113 <LI>Connectivity
114 <UL>
115 <LI> 08XXX Connection Exceptions
116 </UL>
117
118
119 <LI>Language
120 <UL>
121 <LI> 2200J-2200R for SQL/XML errors (based on SQL/XML[2003]) </LI>
122 <LI> 42800-? for compatible DB2 errors
123 <LI> 42X00-42Zxx for compilation errors </LI>
124 <LI> 43X00-43Yxx for org.apache.derby.impl.sql.execute.rts
125 <LI> 44X00 for all other org.apache.derby.catalog.types
126 <LI> 46000 for SQLJ errors (for now, leave this range empty) </LI>
127 <LI> 38000 SQL3 ranges </LI>
128 <LI> XD00x Dependency mgr </LI>
129 <LI>
130 </UL>
131
132 <LI>Store
133 <UL>
134 <LI> XSCG0 Conglomerate
135 <LI> XSCH0 Heap
136 </UL>
137
138 <LI>Reserved for IBM Use: XQC00 - XQCZZ
139 </UL>
140 */
141
142 public interface SQLState {
143
144 /*
145 ** BasicServices
146 */
147
148 /*
149 ** Monitor
150 */
151 String SERVICE_STARTUP_EXCEPTION = "XBM01.D";
152 String SERVICE_MISSING_IMPLEMENTATION = "XBM02.D";
153 String SERVICE_MISSING_SOURCE_IMPLEMENTATION= "XBM03.D";
154 String SERVICE_MISSING_TARGET_IMPLEMENTATION= "XBM04.D";
155 String MISSING_PRODUCT_VERSION = "XBM05.D";
156 String SERVICE_WRONG_BOOT_PASSWORD = "XBM06.D";
157 String SERVICE_BOOT_PASSWORD_TOO_SHORT = "XBM07.D";
158 String MISSING_ENCRYPTION_PROVIDER = "XBM0G.D";
159 String SERVICE_DIRECTORY_CREATE_ERROR = "XBM0H.D";
160 String SERVICE_DIRECTORY_REMOVE_ERROR = "XBM0I.D";
161 String SERVICE_DIRECTORY_EXISTS_ERROR = "XBM0J.D";
162 String PROTOCOL_UNKNOWN = "XBM0K.D";
163
164 // these were originally ModuleStartupExceptions
165 String AUTHENTICATION_NOT_IMPLEMENTED = "XBM0L.D";
166 String AUTHENTICATION_SCHEME_ERROR = "XBM0M.D";
167 String JDBC_DRIVER_REGISTER = "XBM0N.D";
168 String READ_ONLY_SERVICE = "XBM0P.D";
169 String UNABLE_TO_RENAME_FILE = "XBM0S.D";
170 String AMBIGIOUS_PROTOCOL = "XBM0T.D";
171
172 String REGISTERED_CLASS_NONE = "XBM0U.S";
173 String REGISTERED_CLASS_LINAKGE_ERROR = "XBM0V.S";
174 String REGISTERED_CLASS_INSTANCE_ERROR = "XBM0W.S";
175 String INVALID_LOCALE_DESCRIPTION = "XBM0X.D";
176 String SERVICE_DIRECTORY_NOT_IN_BACKUP = "XBM0Y.D";
177 String UNABLE_TO_COPY_FILE_FROM_BACKUP = "XBM0Z.D";
178 String PROPERTY_FILE_NOT_FOUND_IN_BACKUP = "XBM0Q.D";
179 String UNABLE_TO_DELETE_FILE = "XBM0R.D";
180 String INSTANTIATE_STORAGE_FACTORY_ERROR = "XBM08.D";
181
182 /*
183 ** Upgrade
184 */
185 String UPGRADE_UNSUPPORTED = "XCW00.D";
186 // Note: UPGRADE_SPSRECOMPILEFAILED is now in the warnings section.
187
188 /*
189 ** ContextService
190 */
191 String CONN_INTERRUPT = "08000";
192
193
194 /*
195 ** ClassManager
196 */
197 String GENERATED_CLASS_LINKAGE_ERROR = "XBCM1.S";
198 String GENERATED_CLASS_INSTANCE_ERROR = "XBCM2.S";
199 String GENERATED_CLASS_NO_SUCH_METHOD = "XBCM3.S";
200
201 /*
202 ** Cryptography
203 */
204 String CRYPTO_EXCEPTION = "XBCX0.S";
205 String ILLEGAL_CIPHER_MODE = "XBCX1.S";
206 String ILLEGAL_BP_LENGTH = "XBCX2.S";
207 String NULL_BOOT_PASSWORD = "XBCX5.S";
208 String NON_STRING_BP = "XBCX6.S";
209 String WRONG_PASSWORD_CHANGE_FORMAT = "XBCX7.S";
210 String DATABASE_NOT_ENCRYPTED = "XBCX8.S";
211 String DATABASE_READ_ONLY = "XBCX9.S";
212 String WRONG_BOOT_PASSWORD = "XBCXA.S";
213 String ENCRYPTION_BAD_PADDING = "XBCXB.S";
214 String ENCRYPTION_NOSUCH_ALGORITHM = "XBCXC.S";
215 String ENCRYPTION_NOCHANGE_ALGORITHM = "XBCXD.S";
216 String ENCRYPTION_NOCHANGE_PROVIDER = "XBCXE.S";
217 String ENCRYPTION_NO_PROVIDER_CLASS = "XBCXF.S";
218 String ENCRYPTION_BAD_PROVIDER = "XBCXG.S";
219 String ENCRYPTION_BAD_ALG_FORMAT = "XBCXH.S";
220 String ENCRYPTION_BAD_FEEDBACKMODE = "XBCXI.S";
221 String ENCRYPTION_BAD_JCE = "XBCXJ.S";
222 String ENCRYPTION_BAD_EXTERNAL_KEY = "XBCXK.S";
223 String ENCRYPTION_UNABLE_KEY_VERIFICATION = "XBCXL.S";
224 /*
225 ** Cache Service
226 */
227 String OBJECT_EXISTS_IN_CACHE = "XBCA0.S";
228 String CACHE_FULL = "XBCA3.S";
229
230 /*
231 ** Properties
232 */
233 String PROPERTY_INVALID_VALUE = "XCY00.S";
234 String PROPERTY_UNSUPPORTED_CHANGE = "XCY02.S";
235 String PROPERTY_MISSING = "XCY03.S";
236
237 /*
238 ** LockManager
239 */
240 String DEADLOCK = "40001";
241 String LOCK_TIMEOUT = "40XL1";
242 String LOCK_TIMEOUT_LOG = "40XL2";
243
244 /*
245 ** Store - access.protocol.Interface statement exceptions
246 */
247 String STORE_CONGLOMERATE_DOES_NOT_EXIST = "XSAI2.S";
248 String STORE_FEATURE_NOT_IMPLEMENTED = "XSAI3.S";
249
250 /*
251 ** Store - access.protocol.Interface RunTimeStatistics property names
252 ** and values.
253 */
254 String STORE_RTS_SCAN_TYPE = "XSAJ0.U";
255 String STORE_RTS_NUM_PAGES_VISITED = "XSAJ1.U";
256 String STORE_RTS_NUM_ROWS_VISITED = "XSAJ2.U";
257 String STORE_RTS_NUM_DELETED_ROWS_VISITED = "XSAJ3.U";
258 String STORE_RTS_NUM_ROWS_QUALIFIED = "XSAJ4.U";
259 String STORE_RTS_NUM_COLUMNS_FETCHED = "XSAJ5.U";
260 String STORE_RTS_COLUMNS_FETCHED_BIT_SET = "XSAJ6.U";
261 String STORE_RTS_TREE_HEIGHT = "XSAJ7.U";
262 String STORE_RTS_SORT_TYPE = "XSAJ8.U";
263 String STORE_RTS_NUM_ROWS_INPUT = "XSAJA.U";
264 String STORE_RTS_NUM_ROWS_OUTPUT = "XSAJB.U";
265 String STORE_RTS_NUM_MERGE_RUNS = "XSAJC.U";
266 String STORE_RTS_MERGE_RUNS_SIZE = "XSAJD.U";
267 String STORE_RTS_ALL = "XSAJE.U";
268 String STORE_RTS_BTREE = "XSAJF.U";
269 String STORE_RTS_HEAP = "XSAJG.U";
270 String STORE_RTS_SORT = "XSAJH.U";
271 String STORE_RTS_EXTERNAL = "XSAJI.U";
272 String STORE_RTS_INTERNAL = "XSAJJ.U";
273
274 /*
275 ** Store - access.protocol.XA statement exceptions
276 */
277 String STORE_XA_PROTOCOL_VIOLATION = "XSAX0.S";
278 // STORE_XA_PROTOCOL_VIOLATION_SQLSTATE has no associated message it is
279 // just a constant used by the code so that an exception can be caught
280 // and programatically determined to be a STORE_XA_PROTOCOL_VIOLATION.
281 String STORE_XA_PROTOCOL_VIOLATION_SQLSTATE = "XSAX0";
282 String STORE_XA_XAER_DUPID = "XSAX1.S";
283 // STORE_XA_XAER_DUPID_SQLSTATE has no associated message it is
284 // just a constant used by the code so that an exception can be caught
285 // and programatically determined to be a STORE_XA_XAER_DUPID.
286 String STORE_XA_XAER_DUPID_SQLSTATE = "XSAX1";
287
288 /*
289 ** Store - Conglomerate
290 */
291 String CONGLOMERATE_TEMPLATE_CREATE_ERROR = "XSCG0.S";
292
293 /*
294 ** Store - AccessManager
295 */
296 String AM_NO_FACTORY_FOR_IMPLEMENTATION = "XSAM0.S";
297 String AM_NO_SUCH_CONGLOMERATE_DROP = "XSAM2.S";
298 String AM_NO_SUCH_CONGLOMERATE_TYPE = "XSAM3.S";
299 String AM_NO_SUCH_SORT = "XSAM4.S";
300 String AM_SCAN_NOT_POSITIONED = "XSAM5.S";
301 String AM_RECORD_NOT_FOUND = "XSAM6.S";
302
303
304 /*
305 ** Store - Heap
306 */
307 String HEAP_CANT_CREATE_CONTAINER = "XSCH0.S";
308 String HEAP_CONTAINER_NOT_FOUND = "XSCH1.S";
309 String HEAP_COULD_NOT_CREATE_CONGLOMERATE = "XSCH4.S";
310 String HEAP_TEMPLATE_MISMATCH = "XSCH5.S";
311 String HEAP_IS_CLOSED = "XSCH6.S";
312 String HEAP_SCAN_NOT_POSITIONED = "XSCH7.S";
313 String HEAP_UNIMPLEMENTED_FEATURE = "XSCH8.S";
314
315 /*
316 ** Store - BTree
317 */
318 String BTREE_CANT_CREATE_CONTAINER = "XSCB0.S";
319 String BTREE_CONTAINER_NOT_FOUND = "XSCB1.S";
320 String BTREE_PROPERTY_NOT_FOUND = "XSCB2.S";
321 String BTREE_UNIMPLEMENTED_FEATURE = "XSCB3.S";
322 String BTREE_SCAN_NOT_POSITIONED = "XSCB4.S";
323 String BTREE_ROW_NOT_FOUND_DURING_UNDO = "XSCB5.S";
324 String BTREE_NO_SPACE_FOR_KEY = "XSCB6.S";
325 String BTREE_SCAN_INTERNAL_ERROR = "XSCB7.S";
326 String BTREE_IS_CLOSED = "XSCB8.S";
327 String BTREE_ABORT_THROUGH_TRACE = "XSCB9.S";
328
329 /*
330 ** Store - Sort
331 */
332 String SORT_IMPROPER_SCAN_METHOD = "XSAS0.S";
333 String SORT_SCAN_NOT_POSITIONED = "XSAS1.S";
334
335
336 String SORT_TYPE_MISMATCH = "XSAS3.S";
337 String SORT_COULD_NOT_INIT = "XSAS6.S";
338
339 /*
340 ** RawStore
341 */
342
343 /*
344 ** RawStore - protocol.Interface statement exceptions
345 */
346 String RAWSTORE_NESTED_FREEZE = "XSRS0.S";
347 String RAWSTORE_CANNOT_BACKUP_TO_NONDIRECTORY = "XSRS1.S";
348 String RAWSTORE_ERROR_RENAMING_FILE = "XSRS4.S";
349 String RAWSTORE_ERROR_COPYING_FILE = "XSRS5.S";
350 String RAWSTORE_CANNOT_CREATE_BACKUP_DIRECTORY = "XSRS6.S";
351 String RAWSTORE_UNEXPECTED_EXCEPTION = "XSRS7.S";
352 String RAWSTORE_CANNOT_CHANGE_LOGDEVICE = "XSRS8.S";
353 String RAWSTORE_RECORD_VANISHED = "XSRS9.S";
354
355 /*
356 ** RawStore - Log.Generic statement exceptions
357 */
358 String LOG_WRITE_LOG_RECORD = "XSLB1.S";
359 String LOG_BUFFER_FULL = "XSLB2.S";
360 String LOG_TRUNC_LWM_NULL = "XSLB4.S";
361 String LOG_TRUNC_LWM_ILLEGAL = "XSLB5.S";
362 String LOG_ZERO_LENGTH_LOG_RECORD = "XSLB6.S";
363 String LOG_RESET_BEYOND_SCAN_LIMIT = "XSLB8.S";
364 String LOG_FACTORY_STOPPED = "XSLB9.S";
365
366 /*
367 ** RawStore - Log.Generic database exceptions
368 */
369 String LOG_CANNOT_FLUSH = "XSLA0.D";
370 String LOG_DO_ME_FAIL = "XSLA1.D";
371 String LOG_IO_ERROR = "XSLA2.D";
372 String LOG_CORRUPTED = "XSLA3.D";
373 String LOG_FULL = "XSLA4.D";
374 String LOG_READ_LOG_FOR_UNDO = "XSLA5.D";
375 String LOG_RECOVERY_FAILED = "XSLA6.D";
376 String LOG_REDO_FAILED = "XSLA7.D";
377 String LOG_UNDO_FAILED = "XSLA8.D";
378 String LOG_UNSUPPORTED_FEATURE = "XSLA9.D";
379 String LOG_STORE_CORRUPT = "XSLAA.D";
380 String LOG_FILE_NOT_FOUND = "XSLAB.D";
381 String LOG_INCOMPATIBLE_FORMAT = "XSLAC.D";
382 String LOG_RECORD_CORRUPTED = "XSLAD.D";
383 String LOG_CONTROL_FILE = "XSLAE.D";
384 String LOG_READ_ONLY_DB_NEEDS_UNDO = "XSLAF.D";
385 String LOG_READ_ONLY_DB_UPDATE = "XSLAH.D";
386 String LOG_CANNOT_LOG_CHECKPOINT = "XSLAI.D";
387 String LOG_NULL = "XSLAJ.D";
388 String LOG_EXCEED_MAX_LOG_FILE_NUMBER = "XSLAK.D";
389 String LOG_EXCEED_MAX_LOG_FILE_SIZE = "XSLAL.D";
390 String LOG_CANNOT_VERIFY_LOG_FORMAT = "XSLAM.D";
391 String LOG_INCOMPATIBLE_VERSION = "XSLAN.D";
392 String LOG_UNEXPECTED_RECOVERY_PROBLEM = "XSLAO.D";
393 String LOG_CANNOT_UPGRADE_BETA = "XSLAP.D";
394 String LOG_SEGMENT_NOT_EXIST = "XSLAQ.D";
395 String UNABLE_TO_COPY_LOG_FILE = "XSLAR.D";
396 String LOG_DIRECTORY_NOT_FOUND_IN_BACKUP = "XSLAS.D";
397 String LOG_SEGMENT_EXIST = "XSLAT.D";
398
399
400 /*
401 ** Basic Services - StoredFormatException
402 */
403 String SFE_CANT_RESTORE_INVALID_STORED_FORM = "XBAEA.S";
404 String SFE_FAIL_IO_EXCEPTION = "XBAEB.S";
405 String SFE_UNABLE_TO_FIND_CLASS_EXC_NO_NAME = "XBAED.S";
406
407 /*
408 ** RawStore - Transactions.Basic statement exceptions
409 */
410 String XACT_MAX_SAVEPOINT_LEVEL_REACHED = "3B002.S";
411 //Bug 4466 - changed sqlstate for following two to match DB2 sqlstates.
412 String XACT_SAVEPOINT_EXISTS = "3B501.S";
413 String XACT_SAVEPOINT_NOT_FOUND = "3B001.S";
414 //Bug 4468 - release/rollback of savepoint failed because it doesn't exist
415 String XACT_SAVEPOINT_RELEASE_ROLLBACK_FAIL = "3B502.S";
416 String XACT_TRANSACTION_ACTIVE = "XSTA2.S";
417 String XACT_NO_CONTEXT_MANAGER = "XSTA3.S";
418
419 /*
420 ** RawStore - Transactions.Basic transaction exceptions
421 */
422 String XACT_PROTOCOL_VIOLATION = "40XT0";
423 String XACT_COMMIT_EXCEPTION = "40XT1";
424 String XACT_ROLLBACK_EXCEPTION = "40XT2";
425 String XACT_TRANSACTION_NOT_IDLE = "40XT4";
426 String XACT_INTERNAL_TRANSACTION_EXCEPTION = "40XT5";
427 String XACT_CANNOT_ACTIVATE_TRANSACTION = "40XT6";
428 String XACT_NOT_SUPPORTED_IN_INTERNAL_XACT = "40XT7";
429
430 /*
431 ** RawStore - Transactions.Basic system exceptions
432 */
433 String XACT_ABORT_EXCEPTION = "XSTB0.M";
434 String XACT_CANNOT_LOG_CHANGE = "XSTB2.M";
435 String XACT_CANNOT_ABORT_NULL_LOGGER = "XSTB3.M";
436 String XACT_CANNOT_CHECKPOINT = "XSTB4.M";
437 String XACT_CREATE_NO_LOG = "XSTB5.M";
438 String XACT_TRANSACTION_TABLE_IN_USE = "XSTB6.M";
439
440
441 /*
442 ** RawStore - Data.Generic statement exceptions
443 */
444 String DATA_SLOT_NOT_ON_PAGE = "XSDA1.S";
445 String DATA_UPDATE_DELETED_RECORD = "XSDA2.S";
446 String DATA_NO_SPACE_FOR_RECORD = "XSDA3.S";
447 String DATA_UNEXPECTED_EXCEPTION = "XSDA4.S";
448 String DATA_UNDELETE_RECORD = "XSDA5.S";
449 String DATA_NULL_STORABLE_COLUMN = "XSDA6.S";
450 String DATA_STORABLE_READ_MISMATCH = "XSDA7.S";
451 String DATA_STORABLE_READ_EXCEPTION = "XSDA8.S";
452 String DATA_STORABLE_READ_MISSING_CLASS = "XSDA9.S";
453 String DATA_TIME_STAMP_ILLEGAL = "XSDAA.S";
454 String DATA_TIME_STAMP_NULL = "XSDAB.S";
455 String DATA_DIFFERENT_CONTAINER = "XSDAC.S";
456 String DATA_NO_ROW_COPIED = "XSDAD.S";
457 String DATA_CANNOT_MAKE_RECORD_HANDLE = "XSDAE.S";
458 String DATA_INVALID_RECORD_HANDLE = "XSDAF.S";
459 String DATA_ALLOC_NTT_CANT_OPEN = "XSDAG.S";
460 String DATA_CANNOT_GET_DEALLOC_LOCK = "XSDAI.S";
461 String DATA_STORABLE_WRITE_EXCEPTION = "XSDAJ.S";
462 String DATA_WRONG_PAGE_FOR_HANDLE = "XSDAK.S";
463 String DATA_UNEXPECTED_OVERFLOW_PAGE = "XSDAL.S";
464 String DATA_SQLDATA_READ_INSTANTIATION_EXCEPTION = "XSDAM.S";
465 String DATA_SQLDATA_READ_ILLEGAL_ACCESS_EXCEPTION = "XSDAN.S";
466
467 /*
468 ** RawStore - Data.Generic transaction exceptions
469 */
470 String DATA_CORRUPT_PAGE = "XSDB0.D";
471 String DATA_UNKNOWN_PAGE_FORMAT = "XSDB1.D";
472 String DATA_UNKNOWN_CONTAINER_FORMAT = "XSDB2.D";
473 String DATA_CHANGING_CONTAINER_INFO = "XSDB3.D";
474 String DATA_MISSING_LOG = "XSDB4.D";
475 String DATA_MISSING_PAGE = "XSDB5.D";
476 String DATA_MULTIPLE_JBMS_ON_DB = "XSDB6.D";
477 String DATA_MULTIPLE_JBMS_WARNING = "XSDB7.D";
478 String DATA_MULTIPLE_JBMS_FORCE_LOCK = "XSDB8.D";
479 String DATA_CORRUPT_STREAM_CONTAINER = "XSDB9.D";
480 String DATA_OBJECT_ALLOCATION_FAILED = "XSDBA.D";
481
482 /*
483 ** RawStore - Data.Filesystem statement exceptions
484 */
485 String FILE_EXISTS = "XSDF0.S";
486 String FILE_CREATE = "XSDF1.S";
487 String FILE_CREATE_NO_CLEANUP = "XSDF2.S";
488 String FILE_CANNOT_CREATE_SEGMENT = "XSDF3.S";
489 String FILE_CANNOT_REMOVE_FILE = "XSDF4.S";
490 String FILE_NO_ALLOC_PAGE = "XSDF6.S";
491 String FILE_NEW_PAGE_NOT_LATCHED = "XSDF7.S";
492 String FILE_REUSE_PAGE_NOT_FOUND = "XSDF8.S";
493 String FILE_READ_ONLY = "XSDFB.S";
494 String FILE_IO_GARBLED = "XSDFD.S";
495 String FILE_UNEXPECTED_EXCEPTION = "XSDFF.S";
496 String FILE_ILLEGAL_ENCRYPTED_PAGE_SIZE = "XSDFG.S";
497
498 /*
499 ** RawStore - Data.FSLDemo transaction exceptions
500 */
501 String FSL_RESOURCE_LIMIT_EXCEEDED = "XSDI0.T";
502
503 /*
504 ** RawStore - Data.Filesystem database exceptions
505 */
506 String FILE_READ_PAGE_EXCEPTION = "XSDG0.D";
507 String FILE_WRITE_PAGE_EXCEPTION = "XSDG1.D";
508 String FILE_BAD_CHECKSUM = "XSDG2.D";
509 String FILE_CONTAINER_EXCEPTION = "XSDG3.D";
510 String FILE_DATABASE_NOT_IN_CREATE = "XSDG5.D";
511 String DATA_DIRECTORY_NOT_FOUND_IN_BACKUP = "XSDG6.D";
512 String UNABLE_TO_REMOVE_DATA_DIRECTORY = "XSDG7.D";
513 String UNABLE_TO_COPY_DATA_DIRECTORY = "XSDG8.D";
514
515
516
517 /*
518 ** InternalUtil - Id Parsing
519 ** Note that the code catches ID parsing errors.
520 ** (Range XCXA0-XCXAZ)
521 */
522 String ID_PARSE_ERROR ="XCXA0.S";
523
524 /*
525 ** InternalUtil - Database Class Path Parsing
526 ** Note that the code catches database class path parsing errors.
527 ** (Range XCXB0-XCXBZ)
528 */
529 String DB_CLASS_PATH_PARSE_ERROR="XCXB0.S";
530
531 /*
532 ** InternalUtil - Id List Parsing
533 ** Note that the code catches id list parsing errors.
534 ** (Range XCXC0-XCXCZ)
535 */
536 String ID_LIST_PARSE_ERROR="XCXC0.S";
537
538 /*
539 ** InternalUtil - IO Errors
540 ** (Range XCXD0-XCXDZ)
541 */
542
543 /*
544 ** InternalUtil - LocaleFinder interface
545 */
546 String NO_LOCALE="XCXE0.S";
547
548 String DATA_CONTAINER_CLOSED = "40XD0";
549 String DATA_CONTAINER_READ_ONLY = "40XD1";
550 String DATA_CONTAINER_VANISHED = "40XD2";
551
552 /*
553 ** Connectivity - Connection Exceptions: 08XXX
554 */
555
556 String ERROR_CLOSE = "08003";
557
558
559 /*
560 ** Language
561 */
562
563 /*
564 ** Language Statement Exception
565 */
566 String LSE_COMPILATION_PREFIX="42";
567
568 /*
569 ** Language
570 **
571 ** The entries in this file are sorted into groups. Add your entry
572 ** to the appropriate group. Language errors are divided into 3 groups:
573 ** A group for standard SQLExceptions.
574 **
575 ** 2200J-00R - For SQL/XML errors (based on SQL/XML[2003]).
576 ** 428?? - adding some DB2 compatible errors
577 ** 42X00-42Zxx for compilation errors
578 ** 46000 for SQLJ errors (for now, leave this range empty)
579 ** 38000 SQL3 ranges
580 ** 39001 SQL3
581 ** X0X00-X0Xxx for implementation-defined execution errors.
582 **
583 ** NOTE: If an error can occur during both compilation and execution, then
584 ** you need 2 different errors.
585 **
586 ** In addition to the above groups, this file also contains SQLStates
587 ** for language transaction severity errors. These are in the range
588 **
589 ** 40XC0 - 40XCZ
590 **
591 ** implementation-defined range reserved for class 23 is L01-LZZ
592 **
593 **
594 ** Errors that have standard SQLStates
595 **
596 ** Implementation-defined subclasses must begin with a digit from 5 through 9,
597 ** or a letter from I through Z (capitals only).
598 **
599 */
600
601 /*
602 **
603 ** SQL-J ERRORS -- see jamie for further info
604 **
605 ** DDL
606 ** 46001 - invalid URL
607 ** 46002 - invalid JAR name
608 ** 46003 - invalid class deletion
609 ** 46004 - invalid JAR name
610 ** 46005 - invalid replacement
611 ** 46006 - invalid grantee
612 ** 46007 - invalid signature
613 ** 46008 - invalid method specification
614 ** 46009 - invalid REVOKE
615 **
616 ** Execution
617 ** 46102 - invalid jar name in path
618 ** 46103 - unresolved class name
619 ** 0100E - too many result sets
620 ** 39001 - invalid SQLSTATE
621 ** 39004 - invalid null value
622 ** 38000 - uncaught java exception
623 ** 38mmm - user defined error numbers
624 ** to be used in the future
625 ** InvalidNullValue.sqlstate=39004
626 */
627
628 // WARNINGS (start with 01)
629 String LANG_CONSTRAINT_DROPPED = "01500";
630 String LANG_VIEW_DROPPED = "01501";
631 String LANG_TRIGGER_DROPPED = "01502";
632 String LANG_COL_NOT_NULL = "01503";
633 String LANG_INDEX_DUPLICATE = "01504";
634 String LANG_VALUE_TRUNCATED = "01505";
635 String LANG_SYNONYM_UNDEFINED = "01522";
636 String LANG_NULL_ELIMINATED_IN_SET_FUNCTION = "01003";
637
638 String LANG_NO_ROW_FOUND = "02000";
639
640 // 0100C is not returned for procedures written in Java, from the SQL2003 spec.
641 String LANG_DYNAMIC_RESULTS_RETURNED = "0100C";
642 String LANG_TOO_MANY_DYNAMIC_RESULTS_RETURNED = "0100E";
643
644
645 // TRANSACTION severity language errors. These are in the range:
646 // 40XC0 - 40XCZ
647 String LANG_DEAD_STATEMENT = "40XC0";
648
649 String LANG_MISSING_PARMS = "07000";
650 String LANG_SCALAR_SUBQUERY_CARDINALITY_VIOLATION = "21000";
651 String LANG_STRING_TRUNCATION = "22001";
652 String LANG_CONCAT_STRING_OVERFLOW = "54006";
653 String LANG_OUTSIDE_RANGE_FOR_DATATYPE = "22003";
654
655 String LANG_DB2_GETXXX_BAD_COLUMN_TYPE = "22005"; // same 22005 error
656 String LANG_DATA_TYPE_GET_MISMATCH = "22005"; // same 22005 error
657
658 String LANG_DATE_RANGE_EXCEPTION = "22007.S.180";
659 String LANG_DATE_SYNTAX_EXCEPTION = "22007.S.181";
660 String LANG_INVALID_FUNCTION_ARGUMENT = "22008.S";
661 String LANG_SUBSTR_START_OR_LEN_OUT_OF_RANGE = "22011";
662 String LANG_DIVIDE_BY_ZERO = "22012";
663 String LANG_SQRT_OF_NEG_NUMBER = "22013";
664 String LANG_INVALID_PARAMETER_FOR_SEARCH_POSITION = "22014";
665 String LANG_INVALID_TYPE_FOR_LOCATE_FUNCTION = "22015";
666 String LANG_FORMAT_EXCEPTION = "22018";
667 String LANG_INVALID_ESCAPE_CHARACTER = "22019";
668 String LANG_INVALID_ESCAPE_SEQUENCE = "22025";
669 String LANG_INVALID_TRIM_SET = "22027";
670 String LANG_ESCAPE_IS_NULL = "22501";
671 String LANG_NULL_INTO_NON_NULL = "23502";
672 String LANG_DUPLICATE_KEY_CONSTRAINT = "23505";
673 String LANG_FK_VIOLATION = "23503";
674 String LANG_CHECK_CONSTRAINT_VIOLATED = "23513";
675
676 // From SQL/XML[2003] spec; there are others, but
677 // these are the ones we actually use with our
678 // current XML support.
679 String LANG_NOT_AN_XML_DOCUMENT = "2200L";
680
681 String LANG_INVALID_TRANSACTION_STATE = "25000";
682
683 String LANG_UNEXPECTED_USER_EXCEPTION = "38000";
684 String EXTERNAL_ROUTINE_NO_SQL = "38001";
685 String EXTERNAL_ROUTINE_NO_MODIFIES_SQL = "38002";
686 String EXTERNAL_ROUTINE_NO_READS_SQL = "38004";
687
688 String LANG_NULL_TO_PRIMITIVE_PARAMETER = "39004";
689 String LANG_SYNTAX_OR_ACCESS_VIOLATION = "42000";
690 String LANG_DB2_NOT_NULL_COLUMN_INVALID_DEFAULT = "42601";
691 String LANG_DB2_INVALID_HEXADECIMAL_CONSTANT = "42606";
692 String LANG_DB2_STRING_CONSTANT_TOO_LONG = "54002";
693 String LANG_DB2_NUMBER_OF_ARGS_INVALID = "42605";
694 String LANG_DB2_COALESCE_FUNCTION_ALL_PARAMS = "42610";
695 String LANG_DB2_LENGTH_PRECISION_SCALE_VIOLATION = "42611";
696 String LANG_DB2_MULTIPLE_ELEMENTS = "42613";
697 String LANG_DB2_INVALID_CHECK_CONSTRAINT = "42621";
698 String LANG_INVALID_IN_CONTEXT = "42703";
699 String LANG_DB2_DUPLICATE_NAMES = "42734";
700 String LANG_DB2_INVALID_COLS_SPECIFIED = "42802";
701 String LANG_DB2_INVALID_SELECT_COL_FOR_HAVING = "42803";
702 String LANG_DB2_ADD_UNIQUE_OR_PRIMARY_KEY_ON_NULL_COLS = "42831";
703 String LANG_DB2_REPLACEMENT_ERROR = "42815.S.713";
704 String LANG_DB2_COALESCE_DATATYPE_MISMATCH = "42815.S.171";
705 String LANG_DB2_TOO_LONG_FLOATING_POINT_LITERAL = "42820";
706 String LANG_DB2_LIKE_SYNTAX_ERROR = "42824";
707 String LANG_INVALID_FK_COL_FOR_SETNULL = "42834";
708 String LANG_INVALID_ALTER_TABLE_ATTRIBUTES = "42837";
709 String LANG_DB2_FUNCTION_INCOMPATIBLE = "42884";
710
711
712 String LANG_DB2_PARAMETER_NEEDS_MARKER = "42886";
713 String LANG_DB2_INVALID_DEFAULT_VALUE = "42894";
714
715 String LANG_NO_AGGREGATES_IN_WHERE_CLAUSE = "42903";
716 String LANG_DB2_VIEW_REQUIRES_COLUMN_NAMES = "42908";
717 String LANG_DELETE_RULE_VIOLATION = "42915";
718 String LANG_SYNONYM_CIRCULAR = "42916";
719 String LANG_DB2_ON_CLAUSE_INVALID = "42972";
720 String LANG_SYNTAX_ERROR = "42X01";
721 String LANG_LEXICAL_ERROR = "42X02";
722 String LANG_AMBIGUOUS_COLUMN_NAME = "42X03";
723 String LANG_COLUMN_NOT_FOUND = "42X04";
724 String LANG_TABLE_NOT_FOUND = "42X05";
725 String LANG_TOO_MANY_RESULT_COLUMNS = "42X06";
726 String LANG_NULL_IN_VALUES_CLAUSE = "42X07";
727 String LANG_DOES_NOT_IMPLEMENT = "42X08";
728 String LANG_FROM_LIST_DUPLICATE_TABLE_NAME = "42X09";
729 String LANG_EXPOSED_NAME_NOT_FOUND = "42X10";
730 String LANG_IDENTIFIER_TOO_LONG = "42622";
731 String LANG_DUPLICATE_COLUMN_NAME_CREATE = "42X12";
732 String LANG_TOO_MANY_COLUMNS_IN_TABLE_OR_VIEW = "54011";
733 String LANG_TOO_MANY_INDEXES_ON_TABLE = "42Z9F";
734 String LANG_DUPLICATE_COLUMN_NAME_INSERT = "42X13";
735 String LANG_COLUMN_NOT_FOUND_IN_TABLE = "42X14";
736 String LANG_ILLEGAL_COLUMN_REFERENCE = "42X15";
737 String LANG_DUPLICATE_COLUMN_NAME_UPDATE = "42X16";
738 String LANG_INVALID_JOIN_ORDER_SPEC = "42X17";
739 String LANG_NOT_COMPARABLE = "42818";
740 String LANG_NON_BOOLEAN_WHERE_CLAUSE = "42X19";
741 String LANG_NO_TABLE_MUST_HAVE_CURRENT_OF = "42X21";
742 String LANG_CURSOR_NOT_UPDATABLE = "42X23";
743 // String LANG_UNARY_MINUS_BAD_TYPE = "42X24";
744 String LANG_UNARY_FUNCTION_BAD_TYPE = "42X25";
745 String LANG_TYPE_DOESNT_EXIST = "42X26";
746 String LANG_CURSOR_DELETE_MISMATCH = "42X28";
747 String LANG_CURSOR_UPDATE_MISMATCH = "42X29";
748 String LANG_CURSOR_NOT_FOUND = "42X30";
749 String LANG_COLUMN_NOT_UPDATABLE_IN_CURSOR = "42X31";
750 String LANG_CORRELATION_NAME_FOR_UPDATABLE_COLUMN_DISALLOWED_IN_CURSOR = "42X42";
751 String LANG_DERIVED_COLUMN_LIST_MISMATCH = "42X32";
752 String LANG_DUPLICATE_COLUMN_NAME_DERIVED = "42X33";
753 String LANG_PARAM_IN_SELECT_LIST = "42X34";
754 String LANG_BINARY_OPERANDS_BOTH_PARMS = "42X35";
755 String LANG_UNARY_OPERAND_PARM = "42X36";
756 String LANG_UNARY_ARITHMETIC_BAD_TYPE = "42X37";
757 String LANG_CANT_SELECT_STAR_SUBQUERY = "42X38";
758 String LANG_NON_SINGLE_COLUMN_SUBQUERY = "42X39";
759 String LANG_UNARY_LOGICAL_NON_BOOLEAN = "42X40";
760 String LANG_INVALID_FROM_LIST_PROPERTY = "42X41";
761 String LANG_NOT_STORABLE = "42821";
762 String LANG_NULL_RESULT_SET_META_DATA = "42X43";
763 String LANG_INVALID_COLUMN_LENGTH = "42X44";
764 String LANG_INVALID_FUNCTION_ARG_TYPE = "42X45";
765 // = "42X46";
766 // = "42X47";
767 String LANG_INVALID_PRECISION = "42X48";
768 String LANG_INVALID_INTEGER_LITERAL = "42X49";
769 String LANG_NO_METHOD_FOUND = "42X50";
770 String LANG_TYPE_DOESNT_EXIST2 = "42X51";
771 String LANG_PRIMITIVE_RECEIVER = "42X52";
772 String LANG_LIKE_BAD_TYPE = "42X53";
773 String LANG_PARAMETER_RECEIVER = "42X54";
774 String LANG_TABLE_NAME_MISMATCH = "42X55";
775 String LANG_VIEW_DEFINITION_R_C_L_MISMATCH = "42X56";
776 String LANG_INVALID_V_T_I_COLUMN_COUNT = "42X57";
777 String LANG_UNION_UNMATCHED_COLUMNS = "42X58";
778 String LANG_ROW_VALUE_CONSTRUCTOR_UNMATCHED_COLUMNS = "42X59";
779 String LANG_INVALID_INSERT_MODE = "42X60";
780 String LANG_NOT_UNION_COMPATIBLE = "42X61";
781 String LANG_NO_USER_DDL_IN_SYSTEM_SCHEMA = "42X62";
782 String LANG_NO_ROWS_FROM_USING = "42X63";
783 String LANG_INVALID_STATISTICS_SPEC = "42X64";
784 String LANG_INDEX_NOT_FOUND = "42X65";
785 String LANG_DUPLICATE_COLUMN_NAME_CREATE_INDEX = "42X66";
786 //42X67
787 String LANG_NO_FIELD_FOUND = "42X68";
788 String LANG_PRIMITIVE_REFERENCING_EXPRESSION = "42X69";
789 String LANG_DUPLICATE_PARAMETER_NAME = "42X70";
790 String LANG_UNKNOWN_NAMED_PARAMETER = "42X71";
791 String LANG_NO_STATIC_FIELD_FOUND = "42X72";
792 String LANG_AMBIGUOUS_METHOD_INVOCATION = "42X73";
793 String LANG_INVALID_CALL_STATEMENT = "42X74";
794 String LANG_NO_CONSTRUCTOR_FOUND = "42X75";
795 String LANG_ADDING_PRIMARY_KEY_ON_EXPLICIT_NULLABLE_COLUMN = "42X76";
796 String LANG_COLUMN_OUT_OF_RANGE = "42X77";
797 String LANG_ORDER_BY_COLUMN_NOT_FOUND = "42X78";
798 String LANG_DUPLICATE_COLUMN_FOR_ORDER_BY = "42X79";
799 String LANG_QUALIFIED_COLUMN_NAME_NOT_ALLOWED = "42877";
800 String LANG_EMPTY_VALUES_CLAUSE = "42X80";
801 String LANG_INSERT_COLUMN_LIST_VALUES_MISMATCH = "42X81";
802 String LANG_USING_CARDINALITY_VIOLATION = "42X82";
803 String LANG_ADDING_COLUMN_WITH_NULL_AND_NOT_NULL_CONSTRAINT = "42X83";
804 String LANG_CANT_DROP_BACKING_INDEX = "42X84";
805 String LANG_CONSTRAINT_SCHEMA_MISMATCH = "42X85";
806 String LANG_DROP_NON_EXISTENT_CONSTRAINT = "42X86";
807 String LANG_ALL_RESULT_EXPRESSIONS_PARAMS = "42X87";
808 String LANG_CONDITIONAL_NON_BOOLEAN = "42X88";
809 String LANG_NOT_TYPE_COMPATIBLE = "42X89";
810 String LANG_TOO_MANY_PRIMARY_KEY_CONSTRAINTS = "42X90";
811 String LANG_DUPLICATE_CONSTRAINT_NAME_CREATE = "42X91";
812 String LANG_DUPLICATE_CONSTRAINT_COLUMN_NAME = "42X92";
813 String LANG_INVALID_CREATE_CONSTRAINT_COLUMN_LIST = "42X93";
814 String LANG_OBJECT_NOT_FOUND = "42X94";
815 String LANG_NO_PARAMS_IN_USING = "42X95";
816 String LANG_DB_CLASS_PATH_HAS_MISSING_JAR = "42X96";
817 String LANG_NO_PARAMS_IN_VIEWS = "42X98";
818 String LANG_INVALID_USER_AGGREGATE_DEFINITION = "42X99";
819 String LANG_INVALID_USER_AGGREGATE_DEFINITION2 = "42Y00";
820 String LANG_INVALID_CHECK_CONSTRAINT = "42Y01";
821 // String LANG_NO_ALTER_TABLE_COMPRESS_ON_TARGET_TABLE = "42Y02";
822 String LANG_NO_SUCH_METHOD_ALIAS = "42Y03";
823 String LANG_INVALID_FULL_STATIC_METHOD_NAME = "42Y04";
824 String LANG_NO_SUCH_FOREIGN_KEY = "42Y05";
825 //String LANG_METHOD_ALIAS_NOT_FOUND = "42Y06";
826 String LANG_SCHEMA_DOES_NOT_EXIST = "42Y07";
827 String LANG_NO_FK_ON_SYSTEM_SCHEMA = "42Y08";
828 String LANG_VOID_METHOD_CALL = "42Y09";
829 String LANG_TABLE_CONSTRUCTOR_ALL_PARAM_COLUMN = "42Y10";
830 String LANG_MISSING_JOIN_SPECIFICATION = "42Y11";
831 String LANG_NON_BOOLEAN_JOIN_CLAUSE = "42Y12";
832 String LANG_DUPLICATE_COLUMN_NAME_CREATE_VIEW = "42Y13";
833 // String LANG_DROP_TABLE_ON_NON_TABLE = "42Y15"; -- replaced by 42Y62
834 String LANG_NO_METHOD_MATCHING_ALIAS = "42Y16";
835 // String LANG_DROP_SYSTEM_TABLE_ATTEMPTED = "42Y17"; -- replaced by 42X62
836 String LANG_INVALID_CAST = "42846";
837 String LANG_AMBIGUOUS_GROUPING_COLUMN = "42Y19";
838 // String LANG_UNMATCHED_GROUPING_COLUMN = // "42Y20"; -- not used
839 String LANG_TYPE_DOESNT_EXIST_OR_NO_CLASS_ALIAS = "42Y21";
840 String LANG_USER_AGGREGATE_BAD_TYPE = "42Y22";
841 String LANG_BAD_J_D_B_C_TYPE_INFO = "42Y23";
842 String LANG_VIEW_NOT_UPDATEABLE = "42Y24";
843 String LANG_UPDATE_SYSTEM_TABLE_ATTEMPTED = "42Y25";
844 // String LANG_NO_PARAMS_IN_TRIGGER_WHEN = "42Y26"; -- not used.
845 String LANG_NO_PARAMS_IN_TRIGGER_ACTION = "42Y27";
846 // String LANG_NO_TRIGGER_ON_SYSTEM_TABLE = "42Y28"; -- replaced by 42X62
847 String LANG_INVALID_NON_GROUPED_SELECT_LIST = "42Y29";
848 String LANG_INVALID_GROUPED_SELECT_LIST = "42Y30";
849 String LANG_TOO_MANY_ELEMENTS = "54004";
850 String LANG_BAD_AGGREGATOR_CLASS = "42Y31";
851 String LANG_BAD_AGGREGATOR_CLASS2 = "42Y32";
852 String LANG_USER_AGGREGATE_CONTAINS_AGGREGATE = "42Y33";
853 String LANG_AMBIGUOUS_COLUMN_NAME_IN_TABLE = "42Y34";
854 String LANG_INVALID_COL_REF_NON_GROUPED_SELECT_LIST = "42Y35";
855 String LANG_INVALID_COL_REF_GROUPED_SELECT_LIST = "42Y36";
856 String LANG_TYPE_DOESNT_EXIST3 = "42Y37";
857 String LANG_INVALID_BULK_INSERT_REPLACE = "42Y38";
858 String LANG_UNRELIABLE_QUERY_FRAGMENT = "42Y39";
859 String LANG_DUPLICATE_COLUMN_IN_TRIGGER_UPDATE = "42Y40";
860 String LANG_TRIGGER_SPS_CANNOT_BE_EXECED = "42Y41";
861 String LANG_INVALID_DECIMAL_SCALE = "42Y42";
862 String LANG_INVALID_DECIMAL_PRECISION_SCALE = "42Y43";
863 String LANG_INVALID_FROM_TABLE_PROPERTY = "42Y44";
864 String LANG_CANNOT_BIND_TRIGGER_V_T_I = "42Y45";
865 String LANG_INVALID_FORCED_INDEX1 = "42Y46";
866 // String LANG_INVALID_FORCED_INDEX2 = "42Y47";
867 String LANG_INVALID_FORCED_INDEX2 = "42Y48";
868 String LANG_DUPLICATE_PROPERTY = "42Y49";
869 String LANG_BOTH_FORCE_INDEX_AND_CONSTRAINT_SPECIFIED = "42Y50";
870 // String LANG_INVALID_FORCED_INDEX4 = "42Y51";
871 String LANG_OBJECT_DOES_NOT_EXIST = "42Y55";
872 String LANG_INVALID_JOIN_STRATEGY = "42Y56";
873 String LANG_INVALID_NUMBER_FORMAT_FOR_OVERRIDE = "42Y58";
874 String LANG_INVALID_HASH_INITIAL_CAPACITY = "42Y59";
875 String LANG_INVALID_HASH_LOAD_FACTOR = "42Y60";
876 String LANG_INVALID_HASH_MAX_CAPACITY = "42Y61";
877 String LANG_INVALID_OPERATION_ON_VIEW = "42Y62";
878 String LANG_HASH_NO_EQUIJOIN_FOUND = "42Y63";
879 String LANG_INVALID_BULK_FETCH_VALUE = "42Y64";
880 String LANG_INVALID_BULK_FETCH_WITH_JOIN_TYPE = "42Y65";
881 String LANG_INVALID_BULK_FETCH_UPDATEABLE = "42Y66";
882 String LANG_CANNOT_DROP_SYSTEM_SCHEMAS = "42Y67";
883 String LANG_ILLEGAL_WORK_UNIT_REFERENCE = "42Y68";
884 String LANG_NO_BEST_PLAN_FOUND = "42Y69";
885 String LANG_ILLEGAL_FORCED_JOIN_ORDER = "42Y70";
886 String LANG_CANNOT_DROP_SYSTEM_ALIASES = "42Y71";
887 String LANG_INVALID_PROPERTY_VALUE = "42Y81";
888 String LANG_CANNOT_DROP_TRIGGER_S_P_S = "42Y82";
889 String LANG_USER_AGGREGATE_BAD_TYPE_NULL = "42Y83";
890 String LANG_INVALID_DEFAULT_DEFINITION = "42Y84";
891 String LANG_INVALID_USE_OF_DEFAULT = "42Y85";
892 String LANG_NO_INSERT_REPLACE_ON_PUBLISHED_TABLE = "42Y86";
893 String LANG_NO_INSERT_REPLACE_ON_TARGET_TABLE = "42Y87";
894 String LANG_AGGREGATES_TAKE_ONE_PARAM = "42Y89";
895 String LANG_STMT_NOT_UPDATABLE = "42Y90";
896 String LANG_NO_SPS_USING_IN_TRIGGER = "42Y91";
897 String LANG_TRIGGER_BAD_REF_MISMATCH = "42Y92";
898 String LANG_TRIGGER_BAD_REF_CLAUSE_DUPS = "42Y93";
899 String LANG_BINARY_LOGICAL_NON_BOOLEAN = "42Y94";
900 String LANG_BINARY_OPERATOR_NOT_SUPPORTED = "42Y95";
901 String LANG_UNKNOWN = "42Y96.U";
902 String LANG_INVALID_ESCAPE = "42Y97";
903 String LANG_JAVACC_SYNTAX = "42Y98.U";
904 String LANG_JAVACC_LEXICAL_ERROR = "42Y99.U";
905 String LANG_JAVA_METHOD_CALL_OR_FIELD_REF = "42Z00.U";
906 String LANG_UNTYPED = "42Z01.U";
907 // TEMPORARY COMPILATION RESTRICTIONS
908 String LANG_USER_AGGREGATE_MULTIPLE_DISTINCTS = "42Z02";
909 String LANG_NO_AGGREGATES_IN_ON_CLAUSE = "42Z07";
910 String LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER = "42Z08";
911
912 // MORE GENERIC LANGUAGE STUFF
913 String LANG_COLUMN_DEFAULT = "42Z09.U";
914 String LANG_GQPT_NOT_IMPL = "42Z10.U";
915 String LANG_STREAM = "42Z11.U";
916
917 String LANG_CIRCULAR_DEFINITION = "42Z12";
918 // String LANG_UPDATABLE_VTI_BAD_GETMETADATA = "42Z14";
919
920 // for alter table modify column ...
921 String LANG_MODIFY_COLUMN_CHANGE_TYPE = "42Z15";
922 String LANG_MODIFY_COLUMN_INVALID_TYPE = "42Z16";
923 String LANG_MODIFY_COLUMN_INVALID_LENGTH = "42Z17";
924 String LANG_MODIFY_COLUMN_FKEY_CONSTRAINT = "42Z18";
925 String LANG_MODIFY_COLUMN_REFERENCED = "42Z19";
926 String LANG_MODIFY_COLUMN_PKEY_CONSTRAINT = "42Z20";
927
928 String LANG_AI_INVALID_INCREMENT = "42Z21";
929 String LANG_AI_INVALID_TYPE = "42Z22";
930 String LANG_AI_CANNOT_MODIFY_AI = "42Z23";
931 String LANG_AI_OVERFLOW = "42Z24";
932 String LANG_AI_COUNTER_ERROR = "42Z25";
933 String LANG_AI_CANNOT_NULL_AI = "42Z26";
934 String LANG_AI_CANNOT_ADD_AI_TO_NULLABLE = "42Z27";
935 // String LANG_BUILT_IN_ALIAS_NAME = "42Z28";
936 // RUNTIMESTATISTICS
937 String LANG_TIME_SPENT_THIS = "42Z30.U";
938 String LANG_TIME_SPENT_THIS_AND_BELOW = "42Z31.U";
939 String LANG_TOTAL_TIME_BREAKDOWN = "42Z32.U";
940 String LANG_CONSTRUCTOR_TIME = "42Z33.U";
941 String LANG_OPEN_TIME = "42Z34.U";
942 String LANG_NEXT_TIME = "42Z35.U";
943 String LANG_CLOSE_TIME = "42Z36.U";
944 String LANG_NONE = "42Z37.U";
945 String LANG_POSITION_NOT_AVAIL = "42Z38.U";
946 String LANG_UNEXPECTED_EXC_GETTING_POSITIONER = "42Z39.U";
947 String LANG_POSITIONER = "42Z40.U";
948 String LANG_ORDERED_NULL_SEMANTICS = "42Z41.U";
949 String LANG_COLUMN_ID = "42Z42.U";
950 String LANG_OPERATOR = "42Z43.U";
951 String LANG_ORDERED_NULLS = "42Z44.U";
952 String LANG_UNKNOWN_RETURN_VALUE = "42Z45.U";
953 String LANG_NEGATE_COMPARISON_RESULT = "42Z46.U";
954 String LANG_GQPT_NOT_SUPPORTED = "42Z47.U";
955 String LANG_COLUMN_ID_ARRAY = "42Z48.U";
956
957 String LANG_SERIALIZABLE = "42Z80.U";
958 String LANG_READ_COMMITTED = "42Z81.U";
959 String LANG_EXCLUSIVE = "42Z82.U";
960 String LANG_INSTANTANEOUS_SHARE = "42Z83.U";
961 String LANG_SHARE = "42Z84.U";
962 String LANG_TABLE = "42Z85.U";
963 String LANG_ROW = "42Z86.U";
964 String LANG_SHARE_TABLE = "42Z87.U";
965 String LANG_SHARE_ROW = "42Z88.U";
966
967 // MORE GENERIC LANGUAGE STUFF
968 // String LANG_UPDATABLE_VTI_BAD_GETRESULTSETCONCURRENCY = "42Z89";
969 String LANG_UPDATABLE_VTI_NON_UPDATABLE_RS = "42Z90";
970 String LANG_SUBQUERY = "42Z91";
971 String LANG_REPEATABLE_READ = "42Z92";
972 String LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_COLUMNS = "42Z93";
973 // String LANG_ALTER_SYSTEM_TABLE_ATTEMPTED = "42Z94"; -- replaced by 42X62
974 // String LANG_ALTER_TABLE_ON_NON_TABLE = "42Z95"; -- replaced by 42Y62
975 String LANG_RENAME_COLUMN_WILL_BREAK_CHECK_CONSTRAINT = "42Z97";
976 // beetle 2758. For now just raise an error for literals > 64K
977 String LANG_INVALID_LITERAL_LENGTH = "42Z99";
978 String LANG_READ_UNCOMMITTED = "42Z9A";
979 String LANG_VTI_BLOB_CLOB_UNSUPPORTED = "42Z9B";
980 String LANG_EXPLICIT_NULLS_IN_DB2_MODE = "42Z9C";
981 String LANG_UNSUPPORTED_TRIGGER_STMT = "42Z9D";
982 String LANG_DROP_CONSTRAINT_TYPE = "42Z9E";
983
984 //following 3 matches the DB2 sql states
985 String LANG_DECLARED_GLOBAL_TEMP_TABLE_ONLY_IN_SESSION_SCHEMA = "428EK";
986 String LANG_NOT_ALLOWED_FOR_DECLARED_GLOBAL_TEMP_TABLE = "42995";
987 String LANG_LONG_DATA_TYPE_NOT_ALLOWED = "42962";
988
989 String LANG_MULTIPLE_AUTOINCREMENT_COLUMNS = "428C1";
990 String LANG_ALTER_TABLE_AUTOINCREMENT_COLUMN_NOT_ALLOWED = "42601.S.372";
991 String LANG_TOO_MANY_INDEX_KEY_COLS = "54008";
992 String LANG_TRIGGER_RECURSION_EXCEEDED = "54038";
993 String LANG_TOO_MANY_PARAMETERS_FOR_STORED_PROC = "54023";
994
995 //following 1 does not match the DB2 sql state, it is a Cloudscape specific behavior which is not compatible with DB2
996 String LANG_OPERATION_NOT_ALLOWED_ON_SESSION_SCHEMA_TABLES = "XCL51.S";
997
998 // org.apache.derby.impl.sql.execute.rts
999 String RTS_ATTACHED_TO = "43X00.U";
1000 String RTS_BEGIN_SQ_NUMBER = "43X01.U";
1001 String RTS_ANY_RS = "43X02.U";
1002 String RTS_NUM_OPENS = "43X03.U";
1003 String RTS_ROWS_SEEN = "43X04.U";
1004 String RTS_SOURCE_RS = "43X05.U";
1005 String RTS_END_SQ_NUMBER = "43X06.U";
1006 String RTS_OPT_EST_RC = "43X07.U";
1007 String RTS_OPT_EST_COST = "43X08.U";
1008 String RTS_SECONDS = "43X09.U";
1009 String RTS_TOTAL = "43X10.U";
1010 String RTS_NODE = "43X11.U";
1011 String RTS_NOT_IMPL = "43X12.U";
1012 String RTS_DELETE_RS_USING = "43X13.U";
1013 String RTS_TABLE_LOCKING = "43X14.U";
1014 String RTS_ROW_LOCKING = "43