Java API By Example, From Geeks To Geeks.

1 /* 2 3    Derby - Class org.apache.derby.shared.common.reference.SQLState 4 5    Licensed to the Apache Software Foundation (ASF) under one or more 6    contributor license agreements. See the NOTICE file distributed with 7    this work for additional information regarding copyright ownership. 8    The ASF licenses this file to You under the Apache License, Version 2.0 9    (the "License"); you may not use this file except in compliance with 10    the License. You may obtain a copy of the License at 11 12       http://www.apache.org/licenses/LICENSE-2.0 13 14    Unless required by applicable law or agreed to in writing, software 15    distributed under the License is distributed on an "AS IS" BASIS, 16    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 17    See the License for the specific language governing permissions and 18    limitations under the License. 19 20  */ 21 22 package org.apache.derby.shared.common.reference; 23 24 25 /** 26     List of error message identifiers. 27     This is the set of message identifiers. The message identifier 28     also encodes the SQLState as the first five characters. 29     StandardExceptions must be created using the static 30     StandardException.newException() method calls, passing in a 31     field from this class. 32     <BR> 33     The five character SQL State is obtained from a StandardException 34     using the zero-argument StandardException.getSQLState() method. 35     <BR> 36     The message identifier (ie. the value that matches a field in this class) 37     is obtained using the zero-argument StandardException.getMessageId() method. 38     <BR> 39     Thus if checking for a specific error using a field from this interface 40     the correct code is 41     <PRE> 42         if (se.getMessageId().equals(SQLState.DEADLOCK)) 43     </PRE> 44     <BR> 45     A utility static method StandardException.getSQLState(String messageId) 46     exists to convert an field from this class into a five character SQLState. 47     <P> 48 49     <P> 50     The SQL state of an error message dictates the error's severity. 51     The severity is determined from the first two characters of the 52     state if the state is five characters long, otherwise the state 53     is expected to be 7 characters long and the last character determines 54     the state. If the state is seven characters long then only the first 55     five will be seen by the error reporting code and exception. 56     <BR> 57     If the state is 9 characters long, the last two characters encode 58     an exception category, which Synchronization uses to determine whether 59     the error causes REFRESH to halt or to simply skip the failed transaction. 60     All 5 and 7 character states default to the ENVIRONMENTAL exception 61     category. 62     <BR> 63     Here is the encoding of the SQL state, broken down by severity. 64     <UL> 65     <LI> <B> SYSTEM_SEVERITY </B> 66         xxxxx.M 67          68     <LI> <B> DATABASE_SEVERITY </B> 69         xxxxx.D 70 71     <LI> <B> SESSION_SEVERITY </B> 72         08xxx 73         xxxxx.C 74 75     <LI> <B> TRANSACTION_SEVERITY </B> 76         40xxx or xxxxx.T 77 78     <LI> <B> STATEMENT_SEVERITY </B> 79         {2,3}xxxx, 42xxx, 07xxx or xxxxx.S 80 81     <LI> <B> WARNING_SEVERITY </B> 82         01xxx <EM> SQL State rules require that warnings have states starting with 01</EM> 83 84     <LI> <B> NO_APPLICABLE_SEVERITY </B> 85         YYxxx (YY means none of the above) or xxxxx.U 86 87     <LI> <B> TRANSIENT exception category </B> 88         xxxxx.Y#T (Y can be any of the preceding severities) 89 90     <LI> <B> CONSISTENCY exception category </B> 91         xxxxx.Y#C (Y can be any of the preceding severities) 92 93     <LI> <B> ENVIRONMENTAL exception category (the default)</B> 94         xxxxx.Y#E (Y can be any of the preceding severities) 95 96     <LI> <B> WRAPPED exception category</B> 97         xxxxx.Y#W (Y can be any of the preceding severities) 98 99     </UL> 100     <HR> 101     <P> 102     <B>SQL State ranges</B> 103     <UL> 104     <LI>Basic Services 105       <UL> 106       <LI> XBCA CacheService 107       <LI> XBCM ClassManager 108       <LI> XBCX Cryptography 109       <LI> XBM0 Monitor 110       <LI> XBDA DataComm 111       <LI> XCY0 Properties 112       </UL> 113 114     <LI>Connectivity 115       <UL> 116       <LI> 08XXX Connection Exceptions 117       </UL> 118 119 120     <LI>Language 121       <UL> 122         <LI> 2200J-2200R for SQL/XML errors (based on SQL/XML[2006]) </LI> 123         <LI> 42800-? for compatible DB2 errors 124         <LI> 42X00-42Zxx for compilation errors </LI> 125         <LI> 43X00-43Yxx for org.apache.derby.impl.sql.execute.rts 126         <LI> 44X00 for all other org.apache.derby.catalog.types 127         <LI> 46000 for SQLJ errors (for now, leave this range empty) </LI> 128         <LI> 38000 SQL3 ranges </LI> 129         <LI> XD00x Dependency mgr </LI> 130         <LI> XMLxx Misc XML errors not covered by SQL standard </LI> 131       <LI> 132       </UL> 133 134     <LI>Store 135       <UL> 136       <LI> XSCG0 Conglomerate 137       <LI> XSCH0 Heap 138       </UL> 139 140     <LI>Reserved for IBM Use: XQC00 - XQCZZ 141     </UL> 142 */ 143 144 public interface SQLState { 145 146     /* 147     ** BasicServices 148     */ 149 150     /* 151     ** Monitor 152     */ 153     String SERVICE_STARTUP_EXCEPTION = "XBM01.D"; 154     String SERVICE_MISSING_IMPLEMENTATION = "XBM02.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     String GENERATED_CLASS_LIMIT_EXCEEDED = "XBCM4.S"; 201 202     /* 203     ** Cryptography 204     */ 205     String CRYPTO_EXCEPTION = "XBCX0.S"; 206     String ILLEGAL_CIPHER_MODE = "XBCX1.S"; 207     String ILLEGAL_BP_LENGTH = "XBCX2.S"; 208     String NULL_BOOT_PASSWORD = "XBCX5.S"; 209     String NON_STRING_BP = "XBCX6.S"; 210     String WRONG_PASSWORD_CHANGE_FORMAT = "XBCX7.S"; 211     String DATABASE_NOT_ENCRYPTED = "XBCX8.S"; 212     String DATABASE_READ_ONLY = "XBCX9.S"; 213     String WRONG_BOOT_PASSWORD = "XBCXA.S"; 214     String ENCRYPTION_BAD_PADDING = "XBCXB.S"; 215     String ENCRYPTION_NOSUCH_ALGORITHM = "XBCXC.S"; 216     String ENCRYPTION_NOCHANGE_ALGORITHM = "XBCXD.S"; 217     String ENCRYPTION_NOCHANGE_PROVIDER = "XBCXE.S"; 218     String ENCRYPTION_NO_PROVIDER_CLASS = "XBCXF.S"; 219     String ENCRYPTION_BAD_PROVIDER = "XBCXG.S"; 220     String ENCRYPTION_BAD_ALG_FORMAT = "XBCXH.S"; 221     String ENCRYPTION_BAD_FEEDBACKMODE = "XBCXI.S"; 222     String ENCRYPTION_BAD_JCE = "XBCXJ.S"; 223     String ENCRYPTION_BAD_EXTERNAL_KEY = "XBCXK.S"; 224     String ENCRYPTION_UNABLE_KEY_VERIFICATION = "XBCXL.S"; 225     String ENCRYPTION_INVALID_EXKEY_LENGTH = "XBCXM.S"; 226     String ENCRYPTION_ILLEGAL_EXKEY_CHARS = "XBCXN.S"; 227     String ENCRYPTION_PREPARED_XACT_EXIST = "XBCXO.S"; 228     String REENCRYPTION_PREPARED_XACT_EXIST = "XBCXP.S"; 229     String CANNOT_ENCRYPT_READONLY_DATABASE = "XBCXQ.S"; 230     String CANNOT_REENCRYPT_READONLY_DATABASE = "XBCXR.S"; 231     String CANNOT_ENCRYPT_LOG_ARCHIVED_DATABASE = "XBCXS.S"; 232     String CANNOT_REENCRYPT_LOG_ARCHIVED_DATABASE = "XBCXT.S"; 233     String DATABASE_ENCRYPTION_FAILED = "XBCXU.S"; 234     String DATABASE_REENCRYPTION_FAILED = "XBCXV.S"; 235 236     /* 237     ** Cache Service 238     */ 239     String OBJECT_EXISTS_IN_CACHE = "XBCA0.S"; 240 241     /* 242     ** Properties 243     */ 244     String PROPERTY_INVALID_VALUE = "XCY00.S"; 245     String PROPERTY_UNSUPPORTED_CHANGE = "XCY02.S"; 246     String PROPERTY_MISSING = "XCY03.S"; 247     String PROPERTY_SYNTAX_INVALID = "XCY04.S"; 248 249     /* 250     ** LockManager 251     */ 252     String DEADLOCK = "40001"; 253     String LOCK_TIMEOUT = "40XL1"; 254     String LOCK_TIMEOUT_LOG = "40XL2"; 255 256     /* 257     ** Store - access.protocol.Interface statement exceptions 258     */ 259     String STORE_CONGLOMERATE_DOES_NOT_EXIST = "XSAI2.S"; 260     String STORE_FEATURE_NOT_IMPLEMENTED = "XSAI3.S"; 261 262     /* 263     ** Store - access.protocol.Interface RunTimeStatistics property names 264     ** and values. 265     */ 266     String STORE_RTS_SCAN_TYPE = "XSAJ0.U"; 267     String STORE_RTS_NUM_PAGES_VISITED = "XSAJ1.U"; 268     String STORE_RTS_NUM_ROWS_VISITED = "XSAJ2.U"; 269     String STORE_RTS_NUM_DELETED_ROWS_VISITED = "XSAJ3.U"; 270     String STORE_RTS_NUM_ROWS_QUALIFIED = "XSAJ4.U"; 271     String STORE_RTS_NUM_COLUMNS_FETCHED = "XSAJ5.U"; 272     String STORE_RTS_COLUMNS_FETCHED_BIT_SET = "XSAJ6.U"; 273     String STORE_RTS_TREE_HEIGHT = "XSAJ7.U"; 274     String STORE_RTS_SORT_TYPE = "XSAJ8.U"; 275     String STORE_RTS_NUM_ROWS_INPUT = "XSAJA.U"; 276     String STORE_RTS_NUM_ROWS_OUTPUT = "XSAJB.U"; 277     String STORE_RTS_NUM_MERGE_RUNS = "XSAJC.U"; 278     String STORE_RTS_MERGE_RUNS_SIZE = "XSAJD.U"; 279     String STORE_RTS_ALL = "XSAJE.U"; 280     String STORE_RTS_BTREE = "XSAJF.U"; 281     String STORE_RTS_HEAP = "XSAJG.U"; 282     String STORE_RTS_SORT = "XSAJH.U"; 283     String STORE_RTS_EXTERNAL = "XSAJI.U"; 284     String STORE_RTS_INTERNAL = "XSAJJ.U"; 285 286     /* 287     ** Store - access.protocol.XA statement exceptions 288     */ 289     String STORE_XA_PROTOCOL_VIOLATION = "XSAX0.S"; 290     // STORE_XA_PROTOCOL_VIOLATION_SQLSTATE has no associated message it is 291 // just a constant used by the code so that an exception can be caught 292 // and programatically determined to be a STORE_XA_PROTOCOL_VIOLATION. 293 String STORE_XA_PROTOCOL_VIOLATION_SQLSTATE = "XSAX0"; 294     String STORE_XA_XAER_DUPID = "XSAX1.S"; 295     // STORE_XA_XAER_DUPID_SQLSTATE has no associated message it is 296 // just a constant used by the code so that an exception can be caught 297 // and programatically determined to be a STORE_XA_XAER_DUPID. 298 String STORE_XA_XAER_DUPID_SQLSTATE = "XSAX1"; 299 300     /* 301     ** Store - Conglomerate 302     */ 303     String CONGLOMERATE_TEMPLATE_CREATE_ERROR = "XSCG0.S"; 304 305     /* 306     ** Store - AccessManager 307     */ 308     String AM_NO_FACTORY_FOR_IMPLEMENTATION = "XSAM0.S"; 309     String AM_NO_SUCH_CONGLOMERATE_DROP = "XSAM2.S"; 310     String AM_NO_SUCH_CONGLOMERATE_TYPE = "XSAM3.S"; 311     String AM_NO_SUCH_SORT = "XSAM4.S"; 312     String AM_SCAN_NOT_POSITIONED = "XSAM5.S"; 313     String AM_RECORD_NOT_FOUND = "XSAM6.S"; 314      315 316     /* 317     ** Store - Heap 318     */ 319     String HEAP_CANT_CREATE_CONTAINER = "XSCH0.S"; 320     String HEAP_CONTAINER_NOT_FOUND = "XSCH1.S"; 321     String HEAP_COULD_NOT_CREATE_CONGLOMERATE = "XSCH4.S"; 322     String HEAP_TEMPLATE_MISMATCH = "XSCH5.S"; 323     String HEAP_IS_CLOSED = "XSCH6.S"; 324     String HEAP_SCAN_NOT_POSITIONED = "XSCH7.S"; 325     String HEAP_UNIMPLEMENTED_FEATURE = "XSCH8.S"; 326 327     /* 328     ** Store - BTree 329     */ 330     String BTREE_CANT_CREATE_CONTAINER = "XSCB0.S"; 331     String BTREE_CONTAINER_NOT_FOUND = "XSCB1.S"; 332     String BTREE_PROPERTY_NOT_FOUND = "XSCB2.S"; 333     String BTREE_UNIMPLEMENTED_FEATURE = "XSCB3.S"; 334     String BTREE_SCAN_NOT_POSITIONED = "XSCB4.S"; 335     String BTREE_ROW_NOT_FOUND_DURING_UNDO = "XSCB5.S"; 336     String BTREE_NO_SPACE_FOR_KEY = "XSCB6.S"; 337     String BTREE_SCAN_INTERNAL_ERROR = "XSCB7.S"; 338     String BTREE_IS_CLOSED = "XSCB8.S"; 339     String BTREE_ABORT_THROUGH_TRACE = "XSCB9.S"; 340 341     /* 342     ** Store - Sort 343     */ 344     String SORT_IMPROPER_SCAN_METHOD = "XSAS0.S"; 345     String SORT_SCAN_NOT_POSITIONED = "XSAS1.S"; 346 347 348     String SORT_TYPE_MISMATCH = "XSAS3.S"; 349     String SORT_COULD_NOT_INIT = "XSAS6.S"; 350 351     /* 352     ** RawStore 353     */ 354 355     /* 356     ** RawStore - protocol.Interface statement exceptions 357     */ 358     String RAWSTORE_NESTED_FREEZE = "XSRS0.S"; 359     String RAWSTORE_CANNOT_BACKUP_TO_NONDIRECTORY = "XSRS1.S"; 360     String RAWSTORE_ERROR_RENAMING_FILE = "XSRS4.S"; 361     String RAWSTORE_ERROR_COPYING_FILE = "XSRS5.S"; 362     String RAWSTORE_CANNOT_CREATE_BACKUP_DIRECTORY = "XSRS6.S"; 363     String RAWSTORE_UNEXPECTED_EXCEPTION = "XSRS7.S"; 364     String RAWSTORE_CANNOT_CHANGE_LOGDEVICE = "XSRS8.S"; 365     String RAWSTORE_RECORD_VANISHED = "XSRS9.S"; 366     String BACKUP_BLOCKING_OPERATIONS_IN_PROGRESS = "XSRSA.S"; 367     String BACKUP_OPERATIONS_NOT_ALLOWED = "XSRSB.S"; 368     String RAWSTORE_CANNOT_BACKUP_INTO_DATABASE_DIRECTORY = "XSRSC.S"; 369 370     /* 371     ** RawStore - Log.Generic statement exceptions 372     */ 373     String LOG_WRITE_LOG_RECORD = "XSLB1.S"; 374     String LOG_BUFFER_FULL = "XSLB2.S"; 375     String LOG_TRUNC_LWM_NULL = "XSLB4.S"; 376     String LOG_TRUNC_LWM_ILLEGAL = "XSLB5.S"; 377     String LOG_ZERO_LENGTH_LOG_RECORD = "XSLB6.S"; 378     String LOG_RESET_BEYOND_SCAN_LIMIT = "XSLB8.S"; 379     String LOG_FACTORY_STOPPED = "XSLB9.S"; 380 381     /* 382     ** RawStore - Log.Generic database exceptions 383     */ 384     String LOG_CANNOT_FLUSH = "XSLA0.D"; 385     String LOG_DO_ME_FAIL = "XSLA1.D"; 386     String LOG_IO_ERROR = "XSLA2.D"; 387     String LOG_CORRUPTED = "XSLA3.D"; 388     String LOG_FULL = "XSLA4.D"; 389     String LOG_READ_LOG_FOR_UNDO = "XSLA5.D"; 390     String LOG_RECOVERY_FAILED = "XSLA6.D"; 391     String LOG_REDO_FAILED = "XSLA7.D"; 392     String LOG_UNDO_FAILED = "XSLA8.D"; 393     String LOG_STORE_CORRUPT = "XSLAA.D"; 394     String LOG_FILE_NOT_FOUND = "XSLAB.D"; 395     String LOG_INCOMPATIBLE_FORMAT = "XSLAC.D"; 396     String LOG_RECORD_CORRUPTED = "XSLAD.D"; 397     String LOG_CONTROL_FILE = "XSLAE.D"; 398     String LOG_READ_ONLY_DB_NEEDS_UNDO = "XSLAF.D"; 399     String LOG_READ_ONLY_DB_UPDATE = "XSLAH.D"; 400     String LOG_CANNOT_LOG_CHECKPOINT = "XSLAI.D"; 401     String LOG_NULL = "XSLAJ.D"; 402     String LOG_EXCEED_MAX_LOG_FILE_NUMBER = "XSLAK.D"; 403     String LOG_EXCEED_MAX_LOG_FILE_SIZE = "XSLAL.D"; 404     String LOG_CANNOT_VERIFY_LOG_FORMAT = "XSLAM.D"; 405     String LOG_INCOMPATIBLE_VERSION = "XSLAN.D"; 406     String LOG_UNEXPECTED_RECOVERY_PROBLEM = "XSLAO.D"; 407     String LOG_CANNOT_UPGRADE_BETA = "XSLAP.D"; 408     String LOG_SEGMENT_NOT_EXIST = "XSLAQ.D"; 409     String UNABLE_TO_COPY_LOG_FILE = "XSLAR.D"; 410     String LOG_DIRECTORY_NOT_FOUND_IN_BACKUP = "XSLAS.D"; 411     String LOG_SEGMENT_EXIST = "XSLAT.D"; 412 413 414     /* 415     ** RawStore - Transactions.Basic statement exceptions 416     */ 417     String XACT_MAX_SAVEPOINT_LEVEL_REACHED = "3B002.S"; 418     //Bug 4466 - changed sqlstate for following two to match DB2 sqlstates. 419 String XACT_SAVEPOINT_EXISTS = "3B501.S"; 420     String XACT_SAVEPOINT_NOT_FOUND = "3B001.S"; 421     //Bug 4468 - release/rollback of savepoint failed because it doesn't exist 422 String XACT_SAVEPOINT_RELEASE_ROLLBACK_FAIL = "3B502.S"; 423     String XACT_TRANSACTION_ACTIVE = "XSTA2.S"; 424 425     /* 426     ** RawStore - Transactions.Basic transaction exceptions 427     */ 428     String TRANSACTION_PREFIX="40"; 429 430     String XACT_PROTOCOL_VIOLATION = "40XT0"; 431     String XACT_COMMIT_EXCEPTION = "40XT1"; 432     String XACT_ROLLBACK_EXCEPTION = "40XT2"; 433     String XACT_TRANSACTION_NOT_IDLE = "40XT4"; 434     String XACT_INTERNAL_TRANSACTION_EXCEPTION = "40XT5"; 435     String XACT_CANNOT_ACTIVATE_TRANSACTION = "40XT6"; 436     String XACT_NOT_SUPPORTED_IN_INTERNAL_XACT = "40XT7"; 437 438     /* 439     ** RawStore - Transactions.Basic system exceptions 440     */ 441     String XACT_ABORT_EXCEPTION = "XSTB0.M"; 442     String XACT_CANNOT_LOG_CHANGE = "XSTB2.M"; 443     String XACT_CANNOT_ABORT_NULL_LOGGER = "XSTB3.M"; 444     String XACT_CREATE_NO_LOG = "XSTB5.M"; 445     String XACT_TRANSACTION_TABLE_IN_USE = "XSTB6.M"; 446 447      448     /* 449     ** RawStore - Data.Generic statement exceptions 450     */ 451     String DATA_SLOT_NOT_ON_PAGE = "XSDA1.S"; 452     String DATA_UPDATE_DELETED_RECORD = "XSDA2.S"; 453     String DATA_NO_SPACE_FOR_RECORD = "XSDA3.S"; 454     String DATA_UNEXPECTED_EXCEPTION = "XSDA4.S"; 455     String DATA_UNDELETE_RECORD = "XSDA5.S"; 456     String DATA_NULL_STORABLE_COLUMN = "XSDA6.S"; 457     String DATA_STORABLE_READ_MISMATCH = "XSDA7.S"; 458     String DATA_STORABLE_READ_EXCEPTION = "XSDA8.S"; 459     String DATA_STORABLE_READ_MISSING_CLASS = "XSDA9.S"; 460     String DATA_TIME_STAMP_ILLEGAL = "XSDAA.S"; 461     String DATA_TIME_STAMP_NULL = "XSDAB.S"; 462     String DATA_DIFFERENT_CONTAINER = "XSDAC.S"; 463     String DATA_NO_ROW_COPIED = "XSDAD.S"; 464     String DATA_CANNOT_MAKE_RECORD_HANDLE = "XSDAE.S"; 465     String DATA_INVALID_RECORD_HANDLE = "XSDAF.S"; 466     String DATA_ALLOC_NTT_CANT_OPEN = "XSDAG.S"; 467     String DATA_CANNOT_GET_DEALLOC_LOCK = "XSDAI.S"; 468     String DATA_STORABLE_WRITE_EXCEPTION = "XSDAJ.S"; 469     String DATA_WRONG_PAGE_FOR_HANDLE = "XSDAK.S"; 470     String DATA_UNEXPECTED_OVERFLOW_PAGE = "XSDAL.S"; 471     String DATA_SQLDATA_READ_INSTANTIATION_EXCEPTION = "XSDAM.S"; 472     String DATA_SQLDATA_READ_ILLEGAL_ACCESS_EXCEPTION = "XSDAN.S"; 473 474     /* 475     ** RawStore - Data.Generic transaction exceptions 476     */ 477     String DATA_CORRUPT_PAGE = "XSDB0.D"; 478     String DATA_UNKNOWN_PAGE_FORMAT = "XSDB1.D"; 479     String DATA_UNKNOWN_CONTAINER_FORMAT = "XSDB2.D"; 480     String DATA_CHANGING_CONTAINER_INFO = "XSDB3.D"; 481     String DATA_MISSING_LOG = "XSDB4.D"; 482     String DATA_MISSING_PAGE = "XSDB5.D"; 483     String DATA_MULTIPLE_JBMS_ON_DB = "XSDB6.D"; 484     String DATA_MULTIPLE_JBMS_WARNING = "XSDB7.D"; 485     String DATA_MULTIPLE_JBMS_FORCE_LOCK = "XSDB8.D"; 486     String DATA_CORRUPT_STREAM_CONTAINER = "XSDB9.D"; 487     String DATA_OBJECT_ALLOCATION_FAILED = "XSDBA.D"; 488 489     /* 490     ** RawStore - Data.Filesystem statement exceptions 491     */ 492     String FILE_EXISTS = "XSDF0.S"; 493     String FILE_CREATE = "XSDF1.S"; 494     String FILE_CREATE_NO_CLEANUP = "XSDF2.S"; 495     String FILE_CANNOT_CREATE_SEGMENT = "XSDF3.S"; 496     String FILE_CANNOT_REMOVE_FILE = "XSDF4.S"; 497     String FILE_NO_ALLOC_PAGE = "XSDF6.S"; 498     String FILE_NEW_PAGE_NOT_LATCHED = "XSDF7.S"; 499     String FILE_REUSE_PAGE_NOT_FOUND = "XSDF8.S"; 500     String FILE_READ_ONLY = "XSDFB.S"; 501     String FILE_IO_GARBLED = "XSDFD.S"; 502     String FILE_UNEXPECTED_EXCEPTION = "XSDFF.S"; 503     String BACKUP_FILE_IO_ERROR = "XSDFH.S"; 504     String FILE_NEW_PAGE_DURING_RECOVERY = "XSDFI.S"; 505 506     /* 507     ** RawStore - Data.FSLDemo transaction exceptions 508     */ 509 510     /* 511     ** RawStore - Data.Filesystem database exceptions 512     */ 513     String FILE_READ_PAGE_EXCEPTION = "XSDG0.D"; 514     String FILE_WRITE_PAGE_EXCEPTION = "XSDG1.D"; 515     String FILE_BAD_CHECKSUM = "XSDG2.D"; 516     String FILE_CONTAINER_EXCEPTION = "XSDG3.D"; 517     String FILE_DATABASE_NOT_IN_CREATE = "XSDG5.D"; 518     String DATA_DIRECTORY_NOT_FOUND_IN_BACKUP = "XSDG6.D"; 519     String UNABLE_TO_REMOVE_DATA_DIRECTORY = "XSDG7.D"; 520     String UNABLE_TO_COPY_DATA_DIRECTORY = "XSDG8.D"; 521 522 523 524     /* 525     ** InternalUtil - Id Parsing 526     ** Note that the code catches ID parsing errors. 527     ** (Range XCXA0-XCXAZ) 528     */ 529     String ID_PARSE_ERROR ="XCXA0.S"; 530 531     /* 532     ** InternalUtil - Database Class Path Parsing 533     ** Note that the code catches database class path parsing errors. 534     ** (Range XCXB0-XCXBZ) 535     */ 536     String DB_CLASS_PATH_PARSE_ERROR="XCXB0.S"; 537 538     /* 539     ** InternalUtil - Id List Parsing 540     ** Note that the code catches id list parsing errors. 541     ** (Range XCXC0-XCXCZ) 542     */ 543     String ID_LIST_PARSE_ERROR="XCXC0.S"; 544 545     /* 546     ** InternalUtil - IO Errors 547     ** (Range XCXD0-XCXDZ) 548     */ 549 550     /* 551     ** InternalUtil - LocaleFinder interface 552     */ 553     String NO_LOCALE="XCXE0.S"; 554 555     String DATA_CONTAINER_CLOSED = "40XD0"; 556     String DATA_CONTAINER_READ_ONLY = "40XD1"; 557     String DATA_CONTAINER_VANISHED = "40XD2"; 558 559     /* 560     ** Connectivity - Connection Exceptions: 08XXX 561     */ 562     String CONNECTIVITY_PREFIX="08"; 563 564 565     /* 566     ** Language 567     */ 568 569     /* 570     ** Language Statement Exception 571     */ 572     String LSE_COMPILATION_PREFIX="42"; 573 574     /* 575     ** Language 576     ** 577     ** The entries in this file are sorted into groups. Add your entry 578     ** to the appropriate group. Language errors are divided into 3 groups: 579     ** A group for standard SQLExceptions. 580     ** 581     ** 2200J-00R - For SQL/XML errors (based on SQL/XML[2006]). 582     ** 428?? - adding some DB2 compatible errors 583     ** 42X00-42Zxx for compilation errors 584     ** 46000 for SQLJ errors (for now, leave this range empty) 585     ** 38000 SQL3 ranges 586     ** 39001 SQL3 587     ** X0X00-X0Xxx for implementation-defined execution errors. 588     ** 589     ** NOTE: If an error can occur during both compilation and execution, then 590     ** you need 2 different errors. 591     ** 592     ** In addition to the above groups, this file also contains SQLStates 593     ** for language transaction severity errors. These are in the range 594     ** 595     ** 40XC0 - 40XCZ 596     ** 597     ** implementation-defined range reserved for class 23 is L01-LZZ 598     ** 599     ** 600     ** Errors that have standard SQLStates 601     ** 602     ** Implementation-defined subclasses must begin with a digit from 5 through 9, 603     ** or a letter from I through Z (capitals only). 604     ** 605     */ 606 607     /* 608     ** 609     ** SQL-J ERRORS -- see jamie for further info 610     ** 611     ** DDL 612     ** 46001 - invalid URL 613     ** 46002 - invalid JAR name 614     ** 46003 - invalid class deletion 615     ** 46004 - invalid JAR name 616     ** 46005 - invalid replacement 617     ** 46006 - invalid grantee 618     ** 46007 - invalid signature 619     ** 46008 - invalid method specification 620     ** 46009 - invalid REVOKE 621     ** 622     ** Execution 623     ** 46102 - invalid jar name in path 624     ** 46103 - unresolved class name 625     ** 0100E - too many result sets 626     ** 39001 - invalid SQLSTATE 627     ** 39004 - invalid null value 628     ** 38000 - uncaught java exception 629     ** 38mmm - user defined error numbers 630     ** to be used in the future 631     ** InvalidNullValue.sqlstate=39004 632     */ 633 634     // WARNINGS (start with 01) 635 String LANG_CONSTRAINT_DROPPED = "01500"; 636     String LANG_VIEW_DROPPED = "01501"; 637     String LANG_TRIGGER_DROPPED = "01502"; 638     String LANG_COL_NOT_NULL = "01503"; 639     String LANG_INDEX_DUPLICATE = "01504"; 640     String LANG_VALUE_TRUNCATED = "01505"; 641     String LANG_SYNONYM_UNDEFINED = "01522"; 642     String LANG_NULL_ELIMINATED_IN_SET_FUNCTION = "01003"; 643     String LANG_PRIVILEGE_NOT_REVOKED = "01006"; 644      645     String LANG_NO_ROW_FOUND = "02000"; 646 647     String LANG_TOO_MANY_DYNAMIC_RESULTS_RETURNED = "0100E"; 648      649 650     // TRANSACTION severity language errors. These are in the range: 651 // 40XC0 - 40XCZ 652 String LANG_DEAD_STATEMENT = "40XC0"; 653 654     /* 655     ** SQL Data exceptions 656     */ 657     String SQL_DATA_PREFIX="22"; 658      659     String LANG_MISSING_PARMS = "07000"; 660     String LANG_SCALAR_SUBQUERY_CARDINALITY_VIOLATION = "21000"; 661     String LANG_STRING_TRUNCATION = "22001"; 662     String LANG_CONCAT_STRING_OVERFLOW = "54006"; 663     String LANG_OUTSIDE_RANGE_FOR_DATATYPE = "22003"; 664     String YEAR_EXCEEDS_MAXIMUM = "22003.S.1"; 665     String DECIMAL_TOO_MANY_DIGITS = "22003.S.2"; 666     String NUMERIC_OVERFLOW = "22003.S.3"; 667     String CLIENT_LENGTH_OUTSIDE_RANGE_FOR_DATATYPE = "22003.S.4"; 668 669     String LANG_DATA_TYPE_GET_MISMATCH = "22005"; // same 22005 error 670 String UNSUPPORTED_ENCODING = "22005.S.1"; 671     String CHARACTER_CONVERTER_NOT_AVAILABLE = "22005.S.2"; 672     String CANT_CONVERT_UNICODE_TO_EBCDIC = "22005.S.3"; 673     String NET_UNRECOGNIZED_JDBC_TYPE = "22005.S.4"; 674     String NET_INVALID_JDBC_TYPE_FOR_PARAM = "22005.S.5"; 675     String UNRECOGNIZED_JAVA_SQL_TYPE = "22005.S.6"; 676 677     String LANG_DATE_RANGE_EXCEPTION = "22007.S.180"; 678     String LANG_DATE_SYNTAX_EXCEPTION = "22007.S.181"; 679     String LANG_INVALID_FUNCTION_ARGUMENT = "22008.S"; 680     String LANG_SUBSTR_START_OR_LEN_OUT_OF_RANGE = "22011"; 681     String LANG_DIVIDE_BY_ZERO = "22012"; 682     String LANG_SQRT_OF_NEG_NUMBER = "22013"; 683     String LANG_INVALID_PARAMETER_FOR_SEARCH_POSITION = "22014"; 684     String LANG_INVALID_TYPE_FOR_LOCATE_FUNCTION = "22015"; 685     String LOSS_OF_PRECISION_EXCEPTION = "22015.S.1"; 686     String LANG_FORMAT_EXCEPTION = "22018"; 687     String LANG_INVALID_ESCAPE_CHARACTER = "22019"; 688     String LANG_INVALID_ESCAPE_SEQUENCE = "22025"; 689     String LANG_INVALID_TRIM_SET = "22027"; 690     String LANG_STRING_TOO_LONG = "22028"; 691     String LANG_ESCAPE_IS_NULL = "22501"; 692 693 694     /* 695     ** Integrity violations. 696     */ 697     String INTEGRITY_VIOLATION_PREFIX="23"; 698      699     String LANG_NULL_INTO_NON_NULL = "23502"; 700     String LANG_DUPLICATE_KEY_CONSTRAINT = "23505"; 701     String LANG_FK_VIOLATION = "23503"; 702     String LANG_CHECK_CONSTRAINT_VIOLATED = "23513"; 703 704     // From SQL/XML[2006] spec; there are others, but 705 // these are the ones we actually use with our 706 // current XML support. 707 String LANG_XML_QUERY_ERROR = "10000"; 708     String LANG_NOT_AN_XML_DOCUMENT = "2200L"; 709     String LANG_INVALID_XML_DOCUMENT = "2200M"; 710     String LANG_INVALID_XML_CONTEXT_ITEM = "2200V"; 711     String LANG_XQUERY_SERIALIZATION_ERROR = "2200W"; 712 713     String LANG_INVALID_TRANSACTION_STATE = "25000"; 714     String CANNOT_CLOSE_ACTIVE_CONNECTION = "25001"; 715 716 717     String LANG_UNEXPECTED_USER_EXCEPTION = "38000"; 718     String EXTERNAL_ROUTINE_NO_SQL = "38001"; 719     String EXTERNAL_ROUTINE_NO_MODIFIES_SQL = "38002"; 720     String EXTERNAL_ROUTINE_NO_READS_SQL = "38004"; 721 722     String LANG_NULL_TO_PRIMITIVE_PARAMETER = "39004"; 723     String LANG_SYNTAX_OR_ACCESS_VIOLATION = "42000"; 724     String LANG_DB2_NOT_NULL_COLUMN_INVALID_DEFAULT = "42601"; 725     String LANG_DB2_INVALID_HEXADECIMAL_CONSTANT = "42606"; 726     String LANG_DB2_STRING_CONSTANT_TOO_LONG = "54002"; 727     String LANG_DB2_NUMBER_OF_ARGS_INVALID = "42605"; 728     String LANG_DB2_COALESCE_FUNCTION_ALL_PARAMS = "42610"; 729     String LANG_DB2_LENGTH_PRECISION_SCALE_VIOLATION = "42611"; 730     String LANG_DB2_MULTIPLE_ELEMENTS = "42613"; 731     String LANG_DB2_INVALID_CHECK_CONSTRAINT = "42621"; 732     String LANG_DB2_DUPLICATE_NAMES = "42734"; 733     String LANG_DB2_INVALID_COLS_SPECIFIED = "42802"; 734         String LANG_DB2_INVALID_SELECT_COL_FOR_HAVING = "42803"; 735     String LANG_DB2_ADD_UNIQUE_OR_PRIMARY_KEY_ON_NULL_COLS = "42831"; 736     String LANG_DB2_REPLACEMENT_ERROR = "42815.S.713"; 737     String LANG_DB2_COALESCE_DATATYPE_MISMATCH = "42815.S.171"; 738     String LANG_DB2_TOO_LONG_FLOATING_POINT_LITERAL = "42820"; 739     String LANG_DB2_LIKE_SYNTAX_ERROR = "42824"; 740     String LANG_INVALID_FK_COL_FOR_SETNULL = "42834"; 741     String LANG_INVALID_ALTER_TABLE_ATTRIBUTES = "42837"; 742     String LANG_DB2_FUNCTION_INCOMPATIBLE = "42884"; 743 744 745     String LANG_DB2_PARAMETER_NEEDS_MARKER = "42886"; 746     String LANG_DB2_INVALID_DEFAULT_VALUE = "42894"; 747 748     String LANG_NO_AGGREGATES_IN_WHERE_CLAUSE = "42903"; 749     String LANG_DB2_VIEW_REQUIRES_COLUMN_NAMES = "42908"; 750     String LANG_DELETE_RULE_VIOLATION = "42915"; 751     String LANG_SYNONYM_CIRCULAR = "42916"; 752     String LANG_DB2_ON_CLAUSE_INVALID = "42972"; 753     String LANG_SYNTAX_ERROR = "42X01"; 754     String LANG_LEXICAL_ERROR = "42X02"; 755     String LANG_AMBIGUOUS_COLUMN_NAME = "42X03"; 756     String LANG_COLUMN_NOT_FOUND = "42X04"; 757     String LANG_TABLE_NOT_FOUND = "42X05"; 758     String LANG_TOO_MANY_RESULT_COLUMNS = "42X06"; 759     String LANG_NULL_IN_VALUES_CLAUSE = "42X07"; 760     String LANG_DOES_NOT_IMPLEMENT = "42X08"; 761     String LANG_FROM_LIST_DUPLICATE_TABLE_NAME = "42X09"; 762     String LANG_EXPOSED_NAME_NOT_FOUND = "42X10"; 763     String LANG_IDENTIFIER_TOO_LONG = "42622"; 764     String LANG_DUPLICATE_COLUMN_NAME_CREATE = "42X12"; 765     String LANG_TOO_MANY_COLUMNS_IN_TABLE_OR_VIEW = "54011"; 766     String LANG_TOO_MANY_INDEXES_ON_TABLE = "42Z9F"; 767     String LANG_DUPLICATE_COLUMN_NAME_INSERT = "42X13"; 768     String LANG_COLUMN_NOT_FOUND_IN_TABLE = "42X14"; 769     String LANG_ILLEGAL_COLUMN_REFERENCE = "42X15"; 770     String LANG_DUPLICATE_COLUMN_NAME_UPDATE = "42X16"; 771     String LANG_INVALID_JOIN_ORDER_SPEC = "42X17"; 772     String LANG_NOT_COMPARABLE = "42818"; 773     String LANG_NON_BOOLEAN_WHERE_CLAUSE = "42X19"; 774     String LANG_CURSOR_NOT_UPDATABLE = "42X23"; 775     // String LANG_UNARY_MINUS_BAD_TYPE = "42X24"; 776 String LANG_UNARY_FUNCTION_BAD_TYPE = "42X25"; 777     String LANG_TYPE_DOESNT_EXIST = "42X26"; 778     String LANG_CURSOR_DELETE_MISMATCH = "42X28"; 779     String LANG_CURSOR_UPDATE_MISMATCH = "42X29"; 780     String LANG_CURSOR_NOT_FOUND = "42X30"; 781     String LANG_COLUMN_NOT_UPDATABLE_IN_CURSOR = "42X31"; 782     String LANG_CORRELATION_NAME_FOR_UPDATABLE_COLUMN_DISALLOWED_IN_CURSOR = "42X42"; 783     String LANG_DERIVED_COLUMN_LIST_MISMATCH = "42X32"; 784     String LANG_DUPLICATE_COLUMN_NAME_DERIVED = "42X33"; 785     String LANG_PARAM_IN_SELECT_LIST = "42X34"; 786     String LANG_BINARY_OPERANDS_BOTH_PARMS = "42X35"; 787     String LANG_UNARY_OPERAND_PARM = "42X36"; 788     String LANG_UNARY_ARITHMETIC_BAD_TYPE = "42X37"; 789     String LANG_CANT_SELECT_STAR_SUBQUERY = "42X38"; 790     String LANG_NON_SINGLE_COLUMN_SUBQUERY = "42X39"; 791     String LANG_UNARY_LOGICAL_NON_BOOLEAN = "42X40"; 792     String LANG_INVALID_FROM_LIST_PROPERTY = "42X41"; 793     String LANG_NOT_STORABLE = "42821"; 794     String LANG_NULL_RESULT_SET_META_DATA = "42X43"; 795     String LANG_INVALID_COLUMN_LENGTH = "42X44"; 796     String LANG_INVALID_FUNCTION_ARG_TYPE = "42X45"; 797     String LANG_AMBIGUOUS_FUNCTION_NAME = "42X46"; 798     String LANG_AMBIGUOUS_PROCEDURE_NAME = "42X47"; 799     String LANG_INVALID_PRECISION = "42X48"; 800     String LANG_INVALID_INTEGER_LITERAL = "42X49"; 801     String LANG_NO_METHOD_FOUND = "42X50"; 802     String LANG_TYPE_DOESNT_EXIST2 = "42X51"; 803     String LANG_PRIMITIVE_RECEIVER = "42X52"; 804     String LANG_LIKE_BAD_TYPE = "42X53"; 805     String LANG_PARAMETER_RECEIVER = "42X54"; 806     String LANG_TABLE_NAME_MISMATCH = "42X55"; 807     String LANG_VIEW_DEFINITION_R_C_L_MISMATCH = "42X56"; 808     String LANG_INVALID_V_T_I_COLUMN_COUNT = "42X57"; 809     String LANG_UNION_UNMATCHED_COLUMNS = "42X58"; 810     String LANG_ROW_VALUE_CONSTRUCTOR_UNMATCHED_COLUMNS = "42X59"; 811     String LANG_INVALID_INSERT_MODE = "42X60"; 812     String LANG_NOT_UNION_COMPATIBLE = "42X61"; 813     String LANG_NO_USER_DDL_IN_SYSTEM_SCHEMA = "42X62"; 814     String LANG_NO_ROWS_FROM_USING = "42X63"; 815     String LANG_INVALID_STATISTICS_SPEC = "42X64"; 816     String LANG_INDEX_NOT_FOUND = "42X65"; 817     String LANG_DUPLICATE_COLUMN_NAME_CREATE_INDEX = "42X66"; 818     //42X67 819 String LANG_NO_FIELD_FOUND = "42X68"; 820     String LANG_PRIMITIVE_REFERENCING_EXPRESSION = "42X69"; 821     String LANG_NO_STATIC_FIELD_FOUND = "42X72"; 822     String LANG_AMBIGUOUS_METHOD_INVOCATION = "42X73"; 823     String LANG_INVALID_CALL_STATEMENT = "42X74"; 824     String LANG_NO_CONSTRUCTOR_FOUND = "42X75"; 825     String LANG_ADDING_PRIMARY_KEY_ON_EXPLICIT_NULLABLE_COLUMN = "42X76"; 826     String LANG_COLUMN_OUT_OF_RANGE = "42X77"; 827     String LANG_ORDER_BY_COLUMN_NOT_FOUND = "42X78"; 828     String LANG_DUPLICATE_COLUMN_FOR_ORDER_BY = "42X79"; 829     String LANG_QUALIFIED_COLUMN_NAME_NOT_ALLOWED = "42877"; 830     String LANG_EMPTY_VALUES_CLAUSE = "42X80"; 831     String LANG_USING_CARDINALITY_VIOLATION = "42X82"; 832     String LANG_ADDING_COLUMN_WITH_NULL_AND_NOT_NULL_CONSTRAINT = "42X83"; 833     String LANG_CANT_DROP_BACKING_INDEX = "42X84"; 834     String LANG_CONSTRAINT_SCHEMA_MISMATCH = "42X85"; 835     String LANG_DROP_NON_EXISTENT_CONSTRAINT = "42X86"; 836     String LANG_ALL_RESULT_EXPRESSIONS_PARAMS = "42X87"; 837     String LANG_CONDITIONAL_NON_BOOLEAN = "42X88"; 838     String LANG_NOT_TYPE_COMPATIBLE = "42X89"; 839     String LANG_TOO_MANY_PRIMARY_KEY_CONSTRAINTS = "42X90"; 840     String LANG_DUPLICATE_CONSTRAINT_NAME_CREATE = "42X91"; 841     String LANG_DUPLICATE_CONSTRAINT_COLUMN_NAME = "42X92"; 842     String LANG_INVALID_CREATE_CONSTRAINT_COLUMN_LIST = "42X93"; 843     String LANG_OBJECT_NOT_FOUND = "42X94"; 844     String LANG_DB_CLASS_PATH_HAS_MISSING_JAR = "42X96"; 845     String LANG_NO_PARAMS_IN_VIEWS = "42X98"; 846     String LANG_INVALID_USER_AGGREGATE_DEFINITION2 = "42Y00"; 847     String LANG_INVALID_CHECK_CONSTRAINT = "42Y01"; 848     // String LANG_NO_ALTER_TABLE_COMPRESS_ON_TARGET_TABLE = "42Y02"; 849 String LANG_NO_SUCH_METHOD_ALIAS = "42Y03"; 850     String LANG_INVALID_FULL_STATIC_METHOD_NAME = "42Y04"; 851     String LANG_NO_SUCH_FOREIGN_KEY = "42Y05"; 852     //String LANG_METHOD_ALIAS_NOT_FOUND = "42Y06"; 853 String LANG_SCHEMA_DOES_NOT_EXIST = "42Y07"; 854     String LANG_NO_FK_ON_SYSTEM_SCHEMA = "42Y08"; 855     String LANG_VOID_METHOD_CALL = "42Y09"; 856     String LANG_TABLE_CONSTRUCTOR_ALL_PARAM_COLUMN = "42Y10"; 857     String LANG_MISSING_JOIN_SPECIFICATION = "42Y11"; 858     String LANG_NON_BOOLEAN_JOIN_CLAUSE = "42Y12"; 859     String LANG_DUPLICATE_COLUMN_NAME_CREATE_VIEW = "42Y13"; 860     // String LANG_DROP_TABLE_ON_NON_TABLE = "42Y15"; -- replaced by 42Y62 861 String LANG_NO_METHOD_MATCHING_ALIAS = "42Y16"; 862     // String LANG_DROP_SYSTEM_TABLE_ATTEMPTED = "42Y17"; -- replaced by 42X62 863 String LANG_INVALID_CAST = "42846"; 864     // String LANG_AMBIGUOUS_GROUPING_COLUMN = "42Y19"; -- unused post 883. 865 // String LANG_UNMATCHED_GROUPING_COLUMN = // "42Y20"; -- not used 866 String LANG_USER_AGGREGATE_BAD_TYPE = "42Y22"; 867     String LANG_BAD_J_D_B_C_TYPE_INFO = "42Y23"; 868     String LANG_VIEW_NOT_UPDATEABLE = "42Y24"; 869     String LANG_UPDATE_SYSTEM_TABLE_ATTEMPTED = "42Y25"; 870         String LANG_AGGREGATE_IN_GROUPBY_LIST = "42Y26"; 871     String LANG_NO_PARAMS_IN_TRIGGER_ACTION = "42Y27"; 872     // String LANG_NO_TRIGGER_ON_SYSTEM_TABLE = "42Y28"; -- replaced by 42X62 873 String LANG_INVALID_NON_GROUPED_SELECT_LIST = "42Y29"; 874     String LANG_INVALID_GROUPED_SELECT_LIST = "42Y30"; 875      876     String LANG_TOO_MANY_ELEMENTS = "54004"; 877     String LANG_BAD_AGGREGATOR_CLASS2 = "42Y32"; 878     String LANG_USER_AGGREGATE_CONTAINS_AGGREGATE = "42Y33"; 879     String LANG_AMBIGUOUS_COLUMN_NAME_IN_TABLE = "42Y34"; 880     String LANG_INVALID_COL_REF_NON_GROUPED_SELECT_LIST = "42Y35"; 881     String LANG_INVALID_COL_REF_GROUPED_SELECT_LIST = "42Y36"; 882     String LANG_TYPE_DOESNT_EXIST3 = "42Y37"; 883     String LANG_INVALID_BULK_INSERT_REPLACE = "42Y38"; 884     String LANG_UNRELIABLE_QUERY_FRAGMENT = "42Y39"; 885     String LANG_DUPLICATE_COLUMN_IN_TRIGGER_UPDATE = "42Y40"; 886     String LANG_TRIGGER_SPS_CANNOT_BE_EXECED = "42Y41"; 887     String LANG_INVALID_DECIMAL_SCALE = "42Y42"; 888     String LANG_INVALID_DECIMAL_PRECISION_SCALE = "42Y43"; 889     String LANG_INVALID_FROM_TABLE_PROPERTY = "42Y44"; 890     String LANG_CANNOT_BIND_TRIGGER_V_T_I = "42Y45"; 891     String LANG_INVALID_FORCED_INDEX1 = "42Y46"; 892 // String LANG_INVALID_FORCED_INDEX2 = "42Y47"; 893 String LANG_INVALID_FORCED_INDEX2 = "42Y48"; 894     String LANG_DUPLICATE_PROPERTY = "42Y49"; 895     String LANG_BOTH_FORCE_INDEX_AND_CONSTRAINT_SPECIFIED = "42Y50"; 896 // String LANG_INVALID_FORCED_INDEX4 = "42Y51"; 897 String LANG_OBJECT_DOES_NOT_EXIST = "42Y55"; 898     String LANG_INVALID_JOIN_STRATEGY = "42Y56"; 899     String LANG_INVALID_NUMBER_FORMAT_FOR_OVERRIDE = "42Y58"; 900     String LANG_INVALID_HASH_INITIAL_CAPACITY = "42Y59"; 901     String LANG_INVALID_HASH_LOAD_FACTOR = "42Y60"; 902     String LANG_INVALID_HASH_MAX_CAPACITY = "42Y61"; 903     String LANG_INVALID_OPERATION_ON_VIEW = "42Y62"; 904     String LANG_HASH_NO_EQUIJOIN_FOUND = "42Y63"; 905     String LANG_INVALID_BULK_FETCH_VALUE = "42Y64"; 906     String LANG_INVALID_BULK_FETCH_WITH_JOIN_TYPE = "42Y65"; 907     String LANG_INVALID_BULK_FETCH_UPDATEABLE = "42Y66"; 908     String LANG_CANNOT_DROP_SYSTEM_SCHEMAS = "42Y67"; 909     String LANG_NO_BEST_PLAN_FOUND = "42Y69"; 910     String LANG_ILLEGAL_FORCED_JOIN_ORDER = "42Y70"; 911     String LANG_CANNOT_DROP_SYSTEM_ALIASES = "42Y71"; 912     String LANG_CANNOT_DROP_TRIGGER_S_P_S = "42Y82"; 913     String LANG_USER_AGGREGATE_BAD_TYPE_NULL = "42Y83"; 914     String LANG_INVALID_DEFAULT_DEFINITION = "42Y84"; 915     String LANG_INVALID_USE_OF_DEFAULT = "42Y85"; 916     String LANG_STMT_NOT_UPDATABLE = "42Y90"; 917     String LANG_NO_SPS_USING_IN_TRIGGER = "42Y91"; 918     String LANG_TRIGGER_BAD_REF_MISMATCH = "42Y92"; 919     String LANG_TRIGGER_BAD_REF_CLAUSE_DUPS = "42Y93"; 920     String LANG_BINARY_LOGICAL_NON_BOOLEAN = "42Y94"; 921     String LANG_BINARY_OPERATOR_NOT_SUPPORTED = "42Y95"; 922     String LANG_UNKNOWN = "42Y96.U"; 923     String LANG_INVALID_ESCAPE = "42Y97"; 924     String LANG_JAVACC_SYNTAX = "42Y98.U"; 925     String LANG_JAVACC_LEXICAL_ERROR = "42Y99.U"; 926     String LANG_JAVA_METHOD_CALL_OR_FIELD_REF = "42Z00.U"; 927     String LANG_UNTYPED = "42Z01.U"; 928     // TEMPORARY COMPILATION RESTRICTIONS 929 String LANG_USER_AGGREGATE_MULTIPLE_DISTINCTS = "42Z02"; 930     String LANG_NO_AGGREGATES_IN_ON_CLAUSE = "42Z07"; 931     String LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER = "42Z08"; 932 933     // MORE GENERIC LANGUAGE STUFF 934 String LANG_COLUMN_DEFAULT = "42Z09.U"; 935     String LANG_STREAM = "42Z11.U"; 936 937     // String LANG_UPDATABLE_VTI_BAD_GETMETADATA = "42Z14"; 938 939     // for alter table modify column ... 940 String LANG_MODIFY_COLUMN_CHANGE_TYPE = "42Z15"; 941     String LANG_MODIFY_COLUMN_INVALID_TYPE = "42Z16"; 942     String LANG_MODIFY_COLUMN_INVALID_LENGTH = "42Z17"; 943     String LANG_MODIFY_COLUMN_FKEY_CONSTRAINT = "42Z18"; 944     String LANG_MODIFY_COLUMN_REFERENCED = "42Z19"; 945     String LANG_MODIFY_COLUMN_EXISTING_CONSTRAINT = "42Z20"; 946 947     String LANG_AI_INVALID_INCREMENT = "42Z21"; 948     String LANG_AI_INVALID_TYPE = "42Z22"; 949     String LANG_AI_CANNOT_MODIFY_AI = "42Z23"; 950     String LANG_AI_OVERFLOW = "42Z24"; 951     String LANG_AI_COUNTER_ERROR = "42Z25"; 952     String LANG_AI_CANNOT_NULL_AI = "42Z26"; 953     String LANG_AI_CANNOT_ADD_AI_TO_NULLABLE = "42Z27"; 954     // String LANG_BUILT_IN_ALIAS_NAME = "42Z28"; 955 // RUNTIMESTATISTICS 956 String LANG_TIME_SPENT_THIS = "42Z30.U"; 957     String LANG_TIME_SPENT_THIS_AND_BELOW = "42Z31.U"; 958     String LANG_TOTAL_TIME_BREAKDOWN = "42Z32.U"; 959     String LANG_CONSTRUCTOR_TIME = "42Z33.U"; 960     String LANG_OPEN_TIME = "42Z34.U"; 961     String LANG_NEXT_TIME = "42Z35.U"; 962     String LANG_CLOSE_TIME = "42Z36.U"; 963     String LANG_NONE = "42Z37.U"; 964     String LANG_POSITION_NOT_AVAIL = "42Z38.U"; 965     String LANG_UNEXPECTED_EXC_GETTING_POSITIONER = "42Z39.U"; 966     String LANG_POSITIONER = "42Z40.U"; 967     String LANG_ORDERED_NULL_SEMANTICS = "42Z41.U"; 968     String LANG_COLUMN_ID = "42Z42.U"; 969     String LANG_OPERATOR = "42Z43.U"; 970     String LANG_ORDERED_NULLS = "42Z44.U"; 971     String LANG_UNKNOWN_RETURN_VALUE = "42Z45.U"; 972     String LANG_NEGATE_COMPARISON_RESULT = "42Z46.U"; 973     String LANG_GQPT_NOT_SUPPORTED = "42Z47.U"; 974     String LANG_COLUMN_ID_ARRAY = "42Z48.U"; 975 976     String LANG_GRANT_REVOKE_WITH_LEGACY_ACCESS = "42Z60"; 977 978     // 42Z70 - 42Z7Z: For Derby-specific XML compilation errors 979 // (not defined by SQL/XML standard). 980 String LANG_ATTEMPT_TO_BIND_XML = "42Z70"; 981     String LANG_ATTEMPT_TO_SELECT_XML = "42Z71"; 982     String LANG_XML_KEYWORD_MISSING = "42Z72"; 983     String LANG_INVALID_XMLSERIALIZE_TYPE = "42Z73"; 984     String LANG_UNSUPPORTED_XML_FEATURE = "42Z74"; 985     String LANG_INVALID_XML_QUERY_EXPRESSION = "42Z75"; 986     String LANG_MULTIPLE_XML_CONTEXT_ITEMS = "42Z76"; 987     String LANG_INVALID_CONTEXT_ITEM_TYPE = "42Z77"; 988     String LANG_XMLPARSE_UNKNOWN_PARAM_TYPE = "42Z79"; 989 990     String LANG_SERIALIZABLE = "42Z80.U"; 991     String LANG_READ_COMMITTED = "42Z81.U"; 992     String LANG_EXCLUSIVE = "42Z82.U"; 993     String LANG_INSTANTANEOUS_SHARE = "42Z83.U"; 994     String LANG_SHARE = "42Z84.U"; 995     String LANG_TABLE = "42Z85.U"; 996     String LANG_ROW = "42Z86.U"; 997     String LANG_SHARE_TABLE = "42Z87.U"; 998     String LANG_SHARE_ROW = "42Z88.U"; 999 1000    // MORE GENERIC LANGUAGE STUFF 1001 // String LANG_UPDATABLE_VTI_BAD_GETRESULTSETCONCURRENCY = "42Z89"; 1002 String LANG_UPDATABLE_VTI_NON_UPDATABLE_RS = "42Z90"; 1003    String LANG_SUBQUERY = "42Z91"; 1004    String LANG_REPEATABLE_READ = "42Z92"; 1005    String LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_COLUMNS = "42Z93"; 1006    // String LANG_ALTER_SYSTEM_TABLE_ATTEMPTED = "42Z94"; -- replaced by 42X62 1007 // String LANG_ALTER_TABLE_ON_NON_TABLE = "42Z95"; -- replaced by 42Y62 1008 String LANG_RENAME_COLUMN_WILL_BREAK_CHECK_CONSTRAINT = "42Z97"; 1009    // beetle 2758. For now just raise an error for literals > 64K 1010 String LANG_INVALID_LITERAL_LENGTH = "42Z99"; 1011    String LANG_READ_UNCOMMITTED = "42Z9A"; 1012    String LANG_VTI_BLOB_CLOB_UNSUPPORTED = "42Z9B"; 1013    String LANG_UNSUPPORTED_TRIGGER_STMT = "42Z9D"; 1014    String LANG_UNSUPPORTED_TRIGGER_PROC = "42Z9D.S.1"; 1015    String LANG_DROP_CONSTRAINT_TYPE = "42Z9E"; 1016    String LANG_QUERY_TOO_COMPLEX = "42ZA0"; 1017    String LANG_INVALID_SQL_IN_BATCH = "42ZA1"; 1018 1019    //following 3 matches the DB2 sql states 1020 String LANG_DECLARED_GLOBAL_TEMP_TABLE_ONLY_IN_SESSION_SCHEMA = "428EK"; 1021    String LANG_NOT_ALLOWED_FOR_DECLARED_GLOBAL_TEMP_TABLE = "42995"; 1022    String LANG_LONG_DATA_TYPE_NOT_ALLOWED = "42962"; 1023 1024    String LANG_MULTIPLE_AUTOINCREMENT_COLUMNS = "428C1"; 1025    String LANG_ALTER_TABLE_AUTOINCREMENT_COLUMN_NOT_ALLOWED = "42601.S.372"; 1026    String LANG_TOO_MANY_INDEX_KEY_COLS = "54008"; 1027    String LANG_TRIGGER_RECURSION_EXCEEDED = "54038"; 1028    String LANG_TOO_MANY_PARAMETERS_FOR_STORED_PROC = "54023"; 1029 1030    //following 1 does not match the DB2 sql state, it is a Cloudscape specific behavior which is not compatible with DB2 1031 String LANG_OPERATION_NOT_ALLOWED_ON_SESSION_SCHEMA_TABLES = "XCL51.S"; 1032 1033    // org.apache.derby.impl.sql.execute.rts 1034 String RTS_ATTACHED_TO = "43X00.U"; 1035    String RTS_BEGIN_SQ_NUMBER = "43X01.U"; 1036    String RTS_ANY_RS = "43X02.U"; 1037    String RTS_NUM_OPENS = "43X03.U"; 1038    String RTS_ROWS_SEEN = "43X04.U"; 1039    String RTS_SOURCE_RS = "43X05.U"; 1040    String RTS_END_SQ_NUMBER = "43X06.U"; 1041    String RTS_OPT_EST_RC = "43X07.U"; 1042    String RTS_OPT_EST_COST = "43X08.U"; 1043    String RTS_SECONDS = "43X09.U"; 1044    String RTS_TOTAL = "43X10.U"; 1045    String RTS_NODE = "43X11.U"; 1046    String RTS_NOT_IMPL = "43X12.U"; 1047    String RTS_DELETE_RS_USING = "43X13.U"; 1048    String RTS_TABLE_LOCKING = "43X14.U"; 1049    String RTS_ROW_LOCKING = "43X15.U"; 1050    String RTS_DEFERRED = "43X16.U"; 1051    String RTS_ROWS_DELETED = "43X17.U"; 1052    String RTS_INDEXES_UPDATED = "43X18.U"; 1053    String RTS_DELETE = "43X19.U"; 1054    String RTS_DSARS = "43X20.U"; 1055    String RTS_ROWS_INPUT = "43X21.U"; 1056    String RTS_DISTINCT_SCALAR_AGG = "43X22.U"; 1057    String RTS_DISTINCT_SCAN_RS_USING = "43X23.U"; 1058    String RTS_CONSTRAINT = "43X24.U"; 1059    String RTS_INDEX = "43X25.U"; 1060    String RTS_DISTINCT_SCAN_RS = "43X26.U"; 1061    String RTS_LOCKING = "43X27.U"; 1062    String RTS_SCAN_INFO = "43X28.U"; 1063    String RTS_DISTINCT_COL = "43X29.U"; 1064    String RTS_DISTINCT_COLS = "43X30.U"; 1065    String RTS_HASH_TABLE_SIZE = "43X31.U"; 1066    String RTS_ROWS_FILTERED = "43X32.U"; 1067    String RTS_NEXT_TIME = "43X33.U"; 1068    String RTS_START_POSITION = "43X34.U"; 1069    String RTS_STOP_POSITION = "43X35.U"; 1070    String RTS_SCAN_QUALS = "43X36.U"; 1071    String RTS_NEXT_QUALS = "43X37.U"; 1072    String RTS_ON_USING = "43X38.U"; 1073    String RTS_DISTINCT_SCAN = "43X39.U"; 1074    String RTS_SORT_INFO = "43X40.U"; 1075    String RTS_GROUPED_AGG_RS = "43X41.U"; 1076    String RTS_HAS_DISTINCT_AGG = "43X42.U"; 1077    String RTS_IN_SORTED_ORDER = "43X43.U"; 1078    String RTS_GROUPED_AGG = "43X44.U"; 1079    String RTS_HASH_EXISTS_JOIN = "43X45.U"; 1080    String RTS_HASH_EXISTS_JOIN_RS = "43X46.U"; 1081    String RTS_HASH_JOIN = "43X47.U"; 1082    String RTS_HASH_JOIN_RS = "43X48.U"; 1083    String RTS_HASH_LEFT_OJ = "43X49.U"; 1084    String RTS_HASH_LEFT_OJ_RS = "43X50.U"; 1085    String RTS_HASH_SCAN_RS_USING = "43X51.U"; 1086    String RTS_HASH_SCAN_RS = "43X52.U"; 1087    String RTS_HASH_KEY = "43X53.U"; 1088    String RTS_HASH_KEYS = "43X54.U"; 1089    String RTS_HASH_SCAN = "43X55.U"; 1090    String RTS_ATTACHED_SQS = "43X56.U"; 1091    String RTS_HASH_TABLE_RS = "43X57.U"; 1092    String RTS_HASH_TABLE = "43X58.U"; 1093    String RTS_ALL = "43X59.U"; 1094    String RTS_IRTBR_RS = "43X60.U"; 1095    String RTS_COLS_ACCESSED_FROM_HEAP = "43X61.U"; 1096    String RTS_FOR_TAB_NAME = "43X62.U"; 1097    String RTS_IRTBR = "43X63.U"; 1098    String RTS_INSERT_MODE_BULK = "43X64.U"; 1099    String RTS_INSERT_MODE_NOT_BULK = "43X65.U"; 1100    String RTS_INSERT_MODE_NORMAL = "43X66.U"; 1101    String RTS_INSERT_USING = "43X67.U"; 1102    String RTS_ROWS_INSERTED = "43X68.U"; 1103    String RTS_INSERT = "43X69.U"; 1104    String RTS_JOIN = "43X70.U"; 1105    String RTS_LKIS_RS = "43X71.U"; 1106    String RTS_LOCKING_OPTIMIZER = "43X72.U"; 1107    String RTS_TABLE_SCAN = "43X73.U"; 1108    String RTS_INDEX_SCAN = "43X74.U"; 1109    String RTS_ON = "43X75.U"; 1110    String RTS_MATERIALIZED_RS = "43X76.U"; 1111    String RTS_TEMP_CONGLOM_CREATE_TIME = "43X77.U"; 1112    String RTS_TEMP_CONGLOM_FETCH_TIME = "43X78.U"; 1113    String RTS_ROWS_SEEN_LEFT = "43X79.U"; 1114    String RTS_ROWS_SEEN_RIGHT = "43X80.U"; 1115    String RTS_ROWS_RETURNED = "43X81.U"; 1116    String RTS_LEFT_RS = "43X82.U"; 1117    String RTS_RIGHT_RS = "43X83.U"; 1118    String RTS_NESTED_LOOP_EXISTS_JOIN = "43X84.U"; 1119    String RTS_NESTED_LOOP_EXISTS_JOIN_RS = "43X85.U"; 1120    String RTS_NESTED_LOOP_JOIN = "43X86.U"; 1121    String RTS_NESTED_LOOP_JOIN_RS = "43X87.U"; 1122    String RTS_EMPTY_RIGHT_ROWS = "43X88.U"; 1123    String RTS_NESTED_LOOP_LEFT_OJ = "43X89.U"; 1124    String RTS_NESTED_LOOP_LEFT_OJ_RS = "43X90.U"; 1125    String RTS_NORMALIZE_RS = "43X91.U"; 1126    String RTS_ONCE_RS = "43X92.U"; 1127    String RTS_PR_RS = "43X93.U"; 1128    String RTS_RESTRICTION = "43X94.U"; 1129    String RTS_PROJECTION = "43X95.U"; 1130    String RTS_RESTRICTION_TIME = "43X96.U"; 1131    String RTS_PROJECTION_TIME = "43X97.U"; 1132    String RTS_PR = "43X98.U"; 1133    String RTS_ROW_RS = "43X99.U"; 1134 1135    String RTS_SCALAR_AGG_RS = "43Y00.U"; 1136    String RTS_INDEX_KEY_OPT = "43Y01.U"; 1137    String RTS_SCALAR_AGG = "43Y02.U"; 1138    String RTS_SCROLL_INSENSITIVE_RS = "43Y03.U"; 1139    String RTS_READS_FROM_HASH = "43Y04.U"; 1140    String RTS_WRITES_TO_HASH = "43Y05.U"; 1141    String RTS_SORT_RS = "43Y06.U"; 1142    String RTS_ELIMINATE_DUPS = "43Y07.U"; 1143    String RTS_SORT = "43Y08.U"; 1144    String RTS_IS_RS_USING = "43Y09.U"; 1145    String RTS_TS_RS_FOR = "43Y10.U"; 1146    String RTS_ACTUAL_TABLE = "43Y11.U"; 1147    String RTS_FETCH_SIZE = "43Y12.U"; 1148    String RTS_QUALS = "43Y13.U"; 1149    String RTS_UNION_RS = "43Y14.U"; 1150    String RTS_UNION = "43Y15.U"; 1151    String RTS_UPDATE_RS_USING = "43Y16.U"; 1152    String RTS_ROWS_UPDATED = "43Y17.U"; 1153    String RTS_UPDATE = "43Y18.U"; 1154    String RTS_VTI_RS = "43Y19.U"; 1155    String RTS_VTI = "43Y20.U"; 1156    String RTS_MATERIALIZED_SUBQS = "43Y21.U"; 1157    String RTS_STATEMENT_NAME = "43Y22.U"; 1158    String RTS_STATEMENT_TEXT = "43Y23.U"; 1159    String RTS_PARSE_TIME = "43Y24.U"; 1160    String RTS_BIND_TIME = "43Y25.U"; 1161    String RTS_OPTIMIZE_TIME = "43Y26.U"; 1162    String RTS_GENERATE_TIME = "43Y27.U"; 1163    String RTS_COMPILE_TIME = "43Y28.U"; 1164    String RTS_EXECUTE_TIME = "43Y29.U"; 1165    String RTS_BEGIN_COMP_TS = "43Y30.U"; 1166    String RTS_END_COMP_TS = "43Y31.U"; 1167    String RTS_BEGIN_EXE_TS = "43Y32.U"; 1168    String RTS_END_EXE_TS = "43Y33.U"; 1169    String RTS_STMT_EXE_PLAN_TXT = "43Y44.U"; 1170    String RTS_RUN_TIME = "43Y45.U"; 1171    String RTS_INSERT_VTI_RESULT_SET = "43Y46.U"; 1172    String RTS_DELETE_VTI_RESULT_SET = "43Y47.U"; 1173    String RTS_INSERT_VTI = "43Y49.U"; 1174    String RTS_DELETE_VTI = "43Y50.U"; 1175    String RTS_DELETE_CASCADE = "43Y51.U"; 1176    String RTS_DELETE_CASCADE_RS_USING = "43Y52.U"; 1177    String RTS_REFACTION_DEPENDENT = "43Y53.U"; 1178    String RTS_BEGIN_DEPENDENT_NUMBER = "43Y54.U"; 1179    String RTS_END_DEPENDENT_NUMBER = "43Y55.U"; 1180    String RTS_USER_SUPPLIED_OPTIMIZER_OVERRIDES_FOR_TABLE = "43Y56.U"; 1181    String RTS_USER_SUPPLIED_OPTIMIZER_OVERRIDES_FOR_JOIN = "43Y57.U"; 1182    String RTS_INTERSECT_RS = "43Y58.U"; 1183    String RTS_INTERSECT = "43Y59.U"; 1184    String RTS_EXCEPT_RS = "43Y60.U"; 1185    String RTS_EXCEPT = "43Y61.U"; 1186 1187    // org.apache.derby.catalog.types 1188 String TI_SQL_TYPE_NAME = "44X00.U"; 1189    String TI_NEXT_ERROR = "44X05.U"; 1190 1191    // INTERNAL EXCEPTIONS 1192 String LANG_UNABLE_TO_GENERATE = "42Z50"; 1193    String LANG_UNAVAILABLE_ACTIVATION_NEED = "42Z53"; 1194    String LANG_PARSE_ONLY = "42Z54.U"; 1195    String LANG_STOP_AFTER_PARSING = "42Z55.U"; 1196    String LANG_STOP_AFTER_BINDING = "42Z56.U"; 1197    String LANG_STOP_AFTER_OPTIMIZING = "42Z57.U"; 1198    String LANG_STOP_AFTER_GENERATING = "42Z58.U"; 1199 1200    // PARSER EXCEPTIONS 1201 String LANG_UNBINDABLE_REWRITE = "X0A00.S"; 1202     1203    // EXECUTION EXCEPTIONS 1204 String LANG_CANT_LOCK_TABLE = "X0X02.S"; 1205    String LANG_TABLE_NOT_FOUND_DURING_EXECUTION = "X0X05.S"; 1206    String LANG_CANT_DROP_JAR_ON_DB_CLASS_PATH_DURING_EXECUTION = "X0X07.S"; 1207    String LANG_USING_CARDINALITY_VIOLATION_DURING_EXECUTION = "X0X10.S"; 1208    String LANG_NO_ROWS_FROM_USING_DURING_EXECUTION = "X0X11.S"; 1209    String LANG_FILE_DOES_NOT_EXIST = "X0X13.S"; 1210    String LANG_NO_CORRESPONDING_S_Q_L_TYPE = "X0X57.S"; 1211    String LANG_CURSOR_ALREADY_EXISTS = "X0X60.S"; 1212    String LANG_INDEX_COLUMN_NOT_EQUAL = "X0X61.S"; 1213    String LANG_INCONSISTENT_ROW_LOCATION = "X0X62.S"; 1214    String LANG_FILE_ERROR = "X0X63.S"; 1215    String LANG_COLUMN_NOT_ORDERABLE_DURING_EXECUTION = "X0X67.S"; 1216    String LANG_OBJECT_NOT_FOUND_DURING_EXECUTION = "X0X81.S"; 1217    String LANG_NON_KEYED_INDEX = "X0X85.S"; 1218    String LANG_ZERO_INVALID_FOR_R_S_ABSOLUTE = "X0X86.S"; 1219    String LANG_NO_CURRENT_ROW_FOR_RELATIVE = "X0X87.S"; 1220    String LANG_CANT_INVALIDATE_OPEN_RESULT_SET = "X0X95.S"; 1221    String LANG_CANT_CHANGE_ISOLATION_HOLD_CURSOR = "X0X03.S"; 1222    //following three for auto-generated keys feature in JDBC3.0 1223 String LANG_COLUMN_POSITION_NOT_FOUND = "X0X0E.S"; 1224    String LANG_COLUMN_NAME_NOT_FOUND = "X0X0F.S"; 1225 1226    String LANG_INDEX_NOT_FOUND_DURING_EXECUTION = "X0X99.S"; 1227 1228    // X0Y01 used to be DUPLICATE_KEY_CONSTRAINT 1229 String LANG_DROP_VIEW_ON_NON_VIEW = "X0Y16.S"; 1230    // String LANG_DROP_SYSTEM_TABLE_ATTEMPTED_DURING_EXECUTION = "X0Y17.S"; 1231 String LANG_PROVIDER_HAS_DEPENDENT_VIEW = "X0Y23.S"; 1232    String LANG_PROVIDER_HAS_DEPENDENT_S_P_S = "X0Y24.S"; 1233    String LANG_PROVIDER_HAS_DEPENDENT_OBJECT = "X0Y25.S"; 1234    String LANG_INDEX_AND_TABLE_IN_DIFFERENT_SCHEMAS = "X0Y26.S"; 1235    String LANG_CREATE_SYSTEM_INDEX_ATTEMPTED = "X0Y28.S"; 1236    String LANG_OBJECT_ALREADY_EXISTS_IN_OBJECT = "X0Y32.S"; 1237    String LANG_CREATE_INDEX_NO_TABLE = "X0Y38.S"; 1238    String LANG_INVALID_FK_NO_PK = "X0Y41.S"; 1239    String LANG_INVALID_FK_COL_TYPES_DO_NOT_MATCH = "X0Y42.S"; 1240    String LANG_INVALID_FK_DIFFERENT_COL_COUNT = "X0Y43.S"; 1241    String LANG_INVALID_FK_NO_REF_KEY = "X0Y44.S"; 1242    String LANG_ADD_FK_CONSTRAINT_VIOLATION = "X0Y45.S"; 1243    String LANG_INVALID_FK_NO_REF_TAB = "X0Y46.S"; 1244    String LANG_SCHEMA_NOT_EMPTY = "X0Y54.S"; 1245    String LANG_INDEX_ROW_COUNT_MISMATCH = "X0Y55.S"; 1246    String LANG_INVALID_OPERATION_ON_SYSTEM_TABLE = "X0Y56.S"; 1247    String LANG_ADDING_NON_NULL_COLUMN_TO_NON_EMPTY_TABLE = "X0Y57.S"; 1248    String LANG_ADD_PRIMARY_KEY_FAILED1 = "X0Y58.S"; 1249    String LANG_ADD_CHECK_CONSTRAINT_FAILED = "X0Y59.S"; 1250    String LANG_NULL_DATA_IN_PRIMARY_KEY = "X0Y63.S"; 1251    String LANG_NO_COMMIT_IN_NESTED_CONNECTION = "X0Y66.S"; 1252    String LANG_NO_ROLLBACK_IN_NESTED_CONNECTION = "X0Y67.S"; 1253    String LANG_OBJECT_ALREADY_EXISTS = "X0Y68.S"; 1254    String LANG_NO_DDL_IN_TRIGGER = "X0Y69.S"; 1255    String LANG_NO_DML_IN_TRIGGER = "X0Y70.S"; 1256    String LANG_NO_XACT_IN_TRIGGER = "X0Y71.S"; 1257    String LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER_DURING_EXECUTION = "X0Y72.S"; 1258    String LANG_NO_SET_TRAN_ISO_IN_GLOBAL_CONNECTION = "X0Y77.S"; 1259    String LANG_INVALID_CALL_TO_EXECUTE_QUERY = "X0Y78.S"; 1260    String MULTIPLE_RESULTS_ON_EXECUTE_QUERY = "X0Y78.S.1"; 1261    String USE_EXECUTE_UPDATE_WITH_NO_RESULTS = "X0Y78.S.2"; 1262    String LANG_INVALID_CALL_TO_EXECUTE_UPDATE = "X0Y79.S"; 1263    String LANG_NULL_DATA_IN_NON_NULL_COLUMN = "X0Y80.S"; 1264    String LANG_IGNORE_MISSING_INDEX_ROW_DURING_DELETE = "X0Y83.S"; 1265 1266 1267    // TEMPORARY EXECUTION RESTRICTIONS 1268 1269    // Non-SQLSTATE errors 1270 String LANG_DOES_NOT_RETURN_ROWS = "XCL01.S"; 1271    String LANG_ACTIVATION_CLOSED = "XCL05.S"; 1272    String LANG_CURSOR_CLOSED = "XCL07.S"; 1273    String LANG_NO_CURRENT_ROW = "XCL08.S"; 1274    String LANG_WRONG_ACTIVATION = "XCL09.S"; 1275    String LANG_OBSOLETE_PARAMETERS = "XCL10.S"; 1276    String LANG_DATA_TYPE_SET_MISMATCH = "XCL12.S"; 1277    String LANG_INVALID_PARAM_POSITION = "XCL13.S"; 1278    String LANG_INVALID_COLUMN_POSITION = "XCL14.S"; 1279    String LANG_INVALID_COMPARE_TO = "XCL15.S"; 1280    String LANG_RESULT_SET_NOT_OPEN = "XCL16.S.0"; 1281    String CLIENT_RESULT_SET_NOT_OPEN = "XCL16.S.1"; 1282    String LANG_STREAM_RETRIEVED_ALREADY = "XCL18.S"; 1283    String LANG_MISSING_ROW = "XCL19.S"; 1284    String LANG_CANT_UPGRADE_CATALOGS = "XCL20.S"; 1285    String LANG_DDL_IN_BIND = "XCL21.S"; 1286    String LANG_NOT_OUT_PARAM = "XCL22.S"; 1287    String LANG_INVALID_S_Q_L_TYPE = "XCL23.S"; 1288    String LANG_PARAMETER_MUST_BE_OUTPUT = "XCL24.S"; 1289    String LANG_INVALID_OUT_PARAM_MAP = "XCL25.S"; 1290    String LANG_NOT_OUTPUT_PARAMETER = "XCL26.S"; 1291    String LANG_RETURN_OUTPUT_PARAM_CANNOT_BE_SET = "XCL27.S"; 1292    String LANG_STREAMING_COLUMN_I_O_EXCEPTION = "XCL30.S"; 1293    String LANG_STATEMENT_CLOSED_NO_REASON = "XCL31.S"; 1294    String LANG_STATEMENT_NEEDS_RECOMPILE = "XCL32.S"; 1295 1296 1297     1298    //delete rule restriction violation errors 1299 String LANG_CANT_BE_DEPENDENT_ESELF = "XCL33.S"; 1300    String LANG_CANT_BE_DEPENDENT_ECYCLE = "XCL34.S"; 1301    String LANG_CANT_BE_DEPENDENT_MPATH = "XCL35.S"; 1302    String LANG_DELETE_RULE_MUSTBE_ESELF = "XCL36.S"; 1303    String LANG_DELETE_RULE_MUSTBE_ECASCADE = "XCL37.S"; 1304    String LANG_DELETE_RULE_MUSTBE_MPATH = "XCL38.S"; 1305    String LANG_DELETE_RULE_CANT_BE_CASCADE_ESELF = "XCL39.S"; 1306    String LANG_DELETE_RULE_CANT_BE_CASCADE_ECYCLE = "XCL40.S"; 1307    String LANG_DELETE_RULE_CANT_BE_CASCADE_MPATH = "XCL41.S"; 1308 1309    // referential action types 1310 String LANG_DELETE_RULE_CASCADE = "XCL42.S"; 1311    String LANG_DELETE_RULE_SETNULL = "XCL43.S"; 1312    String LANG_DELETE_RULE_RESTRICT = "XCL44.S"; 1313    String LANG_DELETE_RULE_NOACTION = "XCL45.S"; 1314    String LANG_DELETE_RULE_SETDEFAULT = "XCL46.S"; 1315 1316    String LANG_STATEMENT_UPGRADE_REQUIRED = "XCL47.S"; 1317 1318    //truncate table 1319 String LANG_NO_TRUNCATE_ON_FK_REFERENCE_TABLE = "XCL48.S"; 1320    String LANG_NO_TRUNCATE_ON_ENABLED_DELETE_TRIGGERS = "XCL49.S"; 1321 1322    // Initial release of DB2 Cloudscape does not support upgrade 1323 String LANG_CANT_UPGRADE_DATABASE = "XCL50.S"; 1324 1325    String LANG_STATEMENT_CANCELLED_OR_TIMED_OUT = "XCL52.S"; 1326 1327    /* 1328    ** Language errors that match DB2 1329    */ 1330 1331    String INVALID_SCHEMA_SYS = "42939"; 1332 1333    /* 1334        SQL standard 0A - feature not supported 1335    */ 1336    String UNSUPPORTED_PREFIX="0A"; 1337 1338    String NOT_IMPLEMENTED = "0A000.S"; 1339    String JDBC_METHOD_NOT_IMPLEMENTED = "0A000.S.1"; 1340    String JDBC_METHOD_NOT_SUPPORTED_BY_SERVER = "0A000.S.2"; 1341    String UNSUPPORTED_HOLDABILITY_PROPERTY = "0A000.S.3"; 1342    String CANCEL_NOT_SUPPORTED_BY_SERVER = "0A000.S.4"; 1343    String SECMECH_NOT_SUPPORTED = "0A000.S.5"; 1344    String DRDA_COMMAND_NOT_IMPLEMENTED = "0A000.C.6"; 1345    String DATA_TYPE_NOT_SUPPORTED = "0A000.S.7"; 1346 1347 1348 1349     1350 1351    /* 1352    ** Authorization and Authentication 1353    */ 1354    String AUTHORIZATION_PREFIX="28"; 1355     1356    String AUTH_DATABASE_CONNECTION_REFUSED = "04501.C"; 1357    String AUTH_SET_CONNECTION_READ_ONLY_IN_ACTIVE_XACT = "25501"; 1358    String AUTH_WRITE_WITH_READ_ONLY_CONNECTION = "25502"; 1359    String AUTH_DDL_WITH_READ_ONLY_CONNECTION = "25503"; 1360    String AUTH_CANNOT_SET_READ_WRITE = "25505"; 1361    String AUTH_INVALID_AUTHORIZATION_PROPERTY = "28501"; 1362    String AUTH_INVALID_USER_NAME = "28502.C"; 1363    String AUTH_USER_IN_READ_AND_WRITE_LISTS = "28503"; 1364    String AUTH_DUPLICATE_USERS = "28504"; 1365    String AUTH_INTERNAL_BAD_UUID = "28505"; 1366    String AUTH_NO_TABLE_PERMISSION = "28506"; 1367    String AUTH_NO_TABLE_PERMISSION_FOR_GRANT = "28507"; 1368    String AUTH_NO_COLUMN_PERMISSION = "28508"; 1369    String AUTH_NO_COLUMN_PERMISSION_FOR_GRANT = "28509"; 1370    String AUTH_NO_EXECUTE_PERMISSION = "2850A"; 1371    String AUTH_NO_EXECUTE_PERMISSION_FOR_GRANT = "2850B"; 1372    String AUTH_NOT_OWNER = "2850C"; 1373    String AUTH_NO_ACCESS_NOT_OWNER = "2850D"; 1374    String AUTH_NOT_DATABASE_OWNER = "2850E"; 1375    String AUTH_GRANT_REVOKE_NOT_ALLOWED = "2850F"; 1376    String AUTH_NO_OBJECT_PERMISSION = "2850G"; 1377 1378    /* 1379    ** Dependency manager 1380    */ 1381    String DEP_UNABLE_TO_RESTORE = "XD003.S"; 1382    String DEP_UNABLE_TO_STORE = "XD004.S"; 1383 1384    /* 1385    ** Connectivity 1386    */ 1387    //following have statement severity. 1388 String NO_CURRENT_ROW = "24000"; 1389    // String NULL_TYPE_PARAMETER_MISMATCH = "37000"; 1390 String NO_INPUT_PARAMETERS = "07009"; 1391    String NEED_TO_REGISTER_PARAM = "07004"; 1392    String COLUMN_NOT_FOUND = "S0022"; 1393    //String NO_COMMIT_WHEN_AUTO = "XJ007.S"; 1394 String NO_SAVEPOINT_ROLLBACK_OR_RELEASE_WHEN_AUTO = "XJ008.S"; 1395    String REQUIRES_CALLABLE_STATEMENT = "XJ009.S"; 1396    String NO_SAVEPOINT_WHEN_AUTO = "XJ010.S"; 1397    String NULL_NAME_FOR_SAVEPOINT = "XJ011.S"; 1398    String ALREADY_CLOSED = "XJ012.S"; 1399    String NO_ID_FOR_NAMED_SAVEPOINT = "XJ013.S"; 1400    String NO_NAME_FOR_UNNAMED_SAVEPOINT = "XJ014.S"; 1401    String NOT_FOR_PREPARED_STATEMENT = "XJ016.S"; 1402    String NO_SAVEPOINT_IN_TRIGGER = "XJ017.S"; 1403    String NULL_COLUMN_NAME = "XJ018.S"; 1404    String TYPE_MISMATCH = "XJ020.S"; 1405    String UNSUPPORTED_TYPE = "XJ021.S"; 1406    String SET_STREAM_FAILURE = "XJ022.S"; 1407    String SET_STREAM_INEXACT_LENGTH_DATA = "XJ023.S"; 1408    String NEGATIVE_STREAM_LENGTH = "XJ025.S"; 1409    String NO_AUTO_COMMIT_ON = "XJ030.S"; 1410    String BAD_PROPERTY_VALUE = "XJ042.S"; 1411    String BAD_SCALE_VALUE = "XJ044.S"; 1412    String UNIMPLEMENTED_ISOLATION_LEVEL = "XJ045.S"; 1413    String RESULTSET_RETURN_NOT_ALLOWED = "XJ04B.S"; 1414    String OUTPUT_PARAMS_NOT_ALLOWED = "XJ04C.S"; 1415    String CANNOT_AUTOCOMMIT_XA = "XJ056.S"; 1416    String CANNOT_COMMIT_XA = "XJ057.S"; 1417    String CANNOT_ROLLBACK_XA = "XJ058.S"; 1418    String CANNOT_CLOSE_ACTIVE_XA_CONNECTION = "XJ059.S"; 1419    String CANNOT_HOLD_CURSOR_XA = "XJ05C.S"; 1420    String NOT_ON_FORWARD_ONLY_CURSOR = "XJ061.S"; 1421    String INVALID_FETCH_SIZE = "XJ062.S"; 1422    String INVALID_MAX_ROWS_VALUE = "XJ063.S"; 1423    String INVALID_FETCH_DIRECTION = "XJ064.S"; 1424    String INVALID_ST_FETCH_SIZE = "XJ065.S"; 1425    String INVALID_MAXFIELD_SIZE = "XJ066.S"; 1426    String NULL_SQL_TEXT = "XJ067.S"; 1427    String MIDDLE_OF_BATCH = "XJ068.S"; 1428    String NO_SETXXX_FOR_EXEC_USING = "XJ069.S"; 1429    String BLOB_BAD_POSITION = "XJ070.S"; 1430    String BLOB_NONPOSITIVE_LENGTH = "XJ071.S"; 1431    String BLOB_NULL_PATTERN_OR_SEARCH_STR = "XJ072.S"; 1432    String BLOB_ACCESSED_AFTER_COMMIT = "XJ073.S"; 1433    String INVALID_QUERYTIMEOUT_VALUE = "XJ074.S"; 1434    String BLOB_POSITION_TOO_LARGE = "XJ076.S"; 1435    String BLOB_UNABLE_TO_READ_PATTERN = "XJ077.S"; 1436    String BLOB_INVALID_OFFSET = "XJ078.S"; 1437    String BLOB_LENGTH_TOO_LONG = "XJ079.S"; 1438    String LANG_NUM_PARAMS_INCORRECT = "XJ080.S"; 1439    String INVALID_API_PARAMETER = "XJ081.S"; 1440    String LOB_AS_METHOD_ARGUMENT_OR_RECEIVER = "XJ082.U"; 1441    String UPDATABLE_RESULTSET_API_DISALLOWED = "XJ083.U"; 1442    String COLUMN_NOT_FROM_BASE_TABLE = "XJ084.U"; 1443    String STREAM_EOF = "XJ085.S"; 1444    String CURSOR_NOT_POSITIONED_ON_INSERT_ROW = "XJ086.S"; 1445     1446     1447    String WASNULL_INVALID = "XJ088.S"; 1448    String INVALID_PARAM_USE_GETINT = "XJ089.S"; 1449    String CALENDAR_IS_NULL = "XJ090.S"; 1450    String PARAM_NOT_OUT_OR_INOUT = "XJ091.S"; 1451    String RETURN_PARAM_MUST_BE_INT = "XJ092.S"; 1452    String BLOB_TOO_LARGE_FOR_CLIENT = "XJ093.S"; 1453    String OBJECT_ALREADY_CLOSED = "XJ094.S"; 1454    String ERROR_PRIVILEGED_ACTION = "XJ095.S"; 1455    String MISSING_RESOURCE_BUNDLE = "XJ096.S"; 1456    String SAVEPOINT_NOT_CREATED_BY_CONNECTION = "XJ097.S"; 1457    String BAD_AUTO_GEN_KEY_VALUE = "XJ098.S"; 1458    String READER_UNDER_RUN = "XJ099.S"; 1459    String REGOUTPARAM_SCALE_DOESNT_MATCH_SETTER = "XJ100.S"; 1460    String TABLE_NAME_CANNOT_BE_NULL = "XJ103.S"; 1461    String SHARED_KEY_LENGTH_ERROR = "XJ104.S"; 1462    String DES_KEY_HAS_WRONG_LENGTH = "XJ105.S"; 1463    String CRYPTO_NO_SUCH_PADDING = "XJ106.S"; 1464    String CRYPTO_BAD_PADDING = "XJ107.S"; 1465    String CRYPTO_ILLEGAL_BLOCK_SIZE = "XJ108.S"; 1466    String PRIMARY_TABLE_NAME_IS_NULL = "XJ110.S"; 1467    String FOREIGN_TABLE_NAME_IS_NULL = "XJ111.S"; 1468    String SECURITY_EXCEPTION_ENCOUNTERED = "XJ112.S"; 1469    String UNABLE_TO_OPEN_FILE = "XJ113.S"; 1470    String CURSOR_INVALID_CURSOR_NAME = "XJ114.S"; 1471    String UNABLE_TO_OPEN_RESULTSET_WITH_REQUESTED_HOLDABILTY = "XJ115.S"; 1472    String TOO_MANY_COMMANDS_FOR_BATCH = "XJ116.S"; 1473    String CANNOT_BATCH_QUERIES = "XJ117.S"; 1474    String QUERY_BATCH_ON_NON_QUERY_STATEMENT = "XJ118.S"; 1475    String CURSOR_INVALID_OPERATION_AT_CURRENT_POSITION = "XJ121.S"; 1476    String CURSOR_NO_UPDATE_CALLS_ON_CURRENT_ROW = "XJ122.S"; 1477    String CURSOR_NOT_ON_CURRENT_OR_INSERT_ROW = "XJ123.S"; 1478    String CURSOR_COLUMN_NOT_UPDATABLE = "XJ124.S"; 1479    String CURSOR_MUST_BE_SCROLLABLE = "XJ125.S"; 1480    String CURSOR_INVALID_FOR_SENSITIVE_DYNAMIC = "XJ126.S"; 1481    //wrapper related 1482 String UNABLE_TO_UNWRAP = "XJ128.S"; 1483     1484    String EXCEEDED_MAX_SECTIONS = "XJ200.S"; 1485    String CURSOR_INVALID_NAME = "XJ202.S"; 1486    String CURSOR_DUPLICATE_NAME = "XJ203.S"; 1487    String UNABLE_TO_OPEN_RS_WITH_REQUESTED_HOLDABILITY = "XJ204.S"; 1488    String NO_TOKENS_IN_SQL_TEXT = "XJ206.S"; 1489    String CANT_USE_EXEC_QUERY_FOR_UPDATE = "XJ207.S"; 1490    String BATCH_NON_ATOMIC_FAILURE = "XJ208.S"; 1491    String STORED_PROC_NOT_INSTALLED = "XJ209.S"; 1492    String STORED_PROC_LOAD_MODULE_NOT_FOUND = "XJ210.S"; 1493    String BATCH_CHAIN_BREAKING_EXCEPTION = "XJ211.S"; 1494    String INVALID_ATTRIBUTE_SYNTAX = "XJ212.S"; 1495    String TRACELEVEL_FORMAT_INVALID = "XJ213.C"; 1496    String IO_ERROR_UPON_LOB_FREE = "XJ214.S"; 1497    String LOB_OBJECT_INVALID = "XJ215.S"; 1498     1499    //XN - Network-level messages 1500 String NET_CONNECTION_RESET_NOT_ALLOWED_IN_UNIT_OF_WORK = "XN001.S"; 1501    String NET_SECKTKN_NOT_RETURNED = "XN002.U"; 1502    String NET_QUERY_PROCESSING_TERMINATED = "XN008.S"; 1503    String NET_ERROR_GETTING_BLOB_LENGTH = "XN009.S"; 1504    String NET_NULL_PROCEDURE_NAME = "XN010.S"; 1505    String NET_PROCEDURE_NAME_LENGTH_OUT_OF_RANGE = "XN011.S"; 1506    String NET_WRONG_XA_VERSION = "XN012.S"; 1507    String NET_INVALID_SCROLL_ORIENTATION = "XN013.S"; 1508    String NET_IOEXCEPTION_ON_READ = "XN014.S"; 1509    String NET_INPUTSTREAM_LENGTH_TOO_SMALL = "XN015.S"; 1510    String NET_IOEXCEPTION_ON_STREAMLEN_VERIFICATION = "XN016.S"; 1511    String NET_PREMATURE_EOS = "XN017.S"; 1512    String NET_READER_LENGTH_TOO_SMALL = "XN018.S"; 1513    String NET_XARETVAL_ERROR = "XN019.S"; 1514     1515    // XML - Derby-specific XML errors not covered by 1516 // SQL standard. 1517 String LANG_MISSING_XML_CLASSES = "XML00"; 1518    String LANG_UNEXPECTED_XML_EXCEPTION = "XML01"; 1519 1520    // Used by server for scrollable updatable insensitive result sets 1521 // to transmit updated state to client. Internal, not seen by user. 1522 // Has no message in messages.properties as it is never printed. 1523 String ROW_UPDATED = "rwupd"; 1524    // Used by server to signal delete holes to the client. Internal, not 1525 // seen by user. Has no message in messages.properties as it is never 1526 // printed. 1527 String ROW_DELETED = "02502"; 1528 1529    //following are session severity. 1530 String DATABASE_NOT_FOUND = "XJ004.C"; 1531    String MALFORMED_URL = "XJ028.C"; 1532    String BOOT_DATABASE_FAILED = "XJ040.C"; 1533    String CREATE_DATABASE_FAILED = "XJ041.C"; 1534    String CONFLICTING_CREATE_ATTRIBUTES = "XJ049.C"; 1535    String CONFLICTING_RESTORE_ATTRIBUTES = "XJ081.C"; 1536    String INVALID_ATTRIBUTE = "XJ05B.C"; 1537    String NO_SUCH_DATABASE = "X0RQ3.C"; 1538     1539    // Connection exceptions - SQL State class 08 1540 1541    // 08004 SQL State means the server rejected the connection request 1542 String LOGIN_FAILED = "08004"; 1543    String NET_CONNECT_AUTH_FAILED = "08004.C.1"; 1544    String NET_DATABASE_NOT_FOUND = "08004.C.2"; 1545         1546    // There can be multiple causes for 08003, which according 1547 // to SQL2003 spec means "connection does not exist" 1548 // We use a suffix to distinguish them. Because of the suffix 1549 // you *must* add a severity code 1550 String NO_CURRENT_CONNECTION = "08003"; 1551    String NOGETCONN_ON_CLOSED_POOLED_CONNECTION = "08003.C.1"; 1552    String LOB_METHOD_ON_CLOSED_CONNECTION = "08003.C.2"; 1553    String PHYSICAL_CONNECTION_ALREADY_CLOSED = "08003.C.3"; 1554 1555     1556    // 08006 means connection exception - connection failure 1557 String CONNECTION_FAILED_ON_RESET = "08006.C.1"; 1558 1559     1560    // 08001 is specifically about the SQL client not being able to establish 1561 // a connection with the server. Should only be used for errors that 1562 // occur upon attempting to open a connection. 1563 // NOTE that if the server *rejects* the connection, that's a different 1564 // SQLState- 08004' 1565 String CONNECT_REQUIRED_PROPERTY_NOT_SET = "08001.C.1"; 1566    String CONNECT_UNABLE_TO_CONNECT_TO_SERVER = "08001.C.2"; 1567    // Use this version of socket exception occurs when trying to establish 1568 // a connection to the server, as the SQL State 08001 indicates failure 1569 // to establish a connection. If you aren't trying to connect, just 1570 // use SOCKET_EXCEPTION 1571 String CONNECT_SOCKET_EXCEPTION = "08001.C.3"; 1572    String CONNECT_UNABLE_TO_OPEN_SOCKET_STREAM = "08001.C.4"; 1573    String CONNECT_USERID_LENGTH_OUT_OF_RANGE = "08001.C.5"; 1574    String CONNECT_PASSWORD_LENGTH_OUT_OF_RANGE = "08001.C.6"; 1575    String CONNECT_USERID_ISNULL = "08001.C.7"; 1576    String CONNECT_PASSWORD_ISNULL = "08001.C.8"; 1577    String NET_DBNAME_TOO_LONG = "08001.C.9"; 1578    String NET_SECTKN_TOO_LONG = "08001.C.10"; 1579    String NET_USERID_TOO_LONG = "08001.C.11"; 1580    String NET_PASSWORD_TOO_LONG = "08001.C.12"; 1581 1582         1583    // system severity 1584 String SHUTDOWN_DATABASE = "08006.D"; 1585         1586    //the following 2 exceptions are internal and never get seen by the user. 1587 String CLOSE_REQUEST = "close.C.1"; // no message in messages.properties as it is never printed 1588 1589    //this one had no sqlstate associated with it. 1590 String NORMAL_CLOSE = "XXXXX.C.6"; 1591 1592    //following are system severity. 1593 String CLOUDSCAPE_SYSTEM_SHUTDOWN = "XJ015.M"; 1594 1595    //following are warning severity. 1596 String DATABASE_EXISTS = "01J01"; 1597    String NO_SCROLL_SENSITIVE_CURSORS = "01J02"; 1598    String UPDATABLE_RESULTSET_FOR_FORWARD_ONLY = "01J03"; 1599    String LANG_TYPE_NOT_SERIALIZABLE = "01J04"; 1600    String UPGRADE_SPSRECOMPILEFAILED = "01J05"; 1601    String QUERY_NOT_QUALIFIED_FOR_UPDATABLE_RESULTSET = "01J06"; 1602    String HOLDABLE_RESULT_SET_NOT_AVAILABLE = "01J07"; 1603    String INVALID_RESULTSET_TYPE = "01J08"; 1604    String INVALID_RESULTSET_CONCURRENCY = "01J09"; 1605    String SCROLL_SENSITIVE_NOT_SUPPORTED = "01J10"; 1606    String INSENSITIVE_UPDATABLE_NOT_SUPPORTED = "01J11"; 1607    String UNABLE_TO_OBTAIN_MESSAGE_TEXT_FROM_SERVER = "01J12"; 1608    String NUMBER_OF_ROWS_TOO_LARGE_FOR_INT = "01J13"; 1609    String SQL_AUTHORIZATION_WITH_NO_AUTHENTICATION = "01J14"; 1610         1611    String CURSOR_OPERATION_CONFLICT = "01001"; 1612 1613 1614 1615    //following are no applicable severity 1616 String JAVA_EXCEPTION = "XJ001.U"; 1617    String NO_UPGRADE = "XJ050.U"; 1618         1619    /* 1620     ** Messages whose SQL states are proscribed by DRDA 1621     */ 1622    String DRDA_NO_AUTOCOMMIT_UNDER_XA = "2D521.S.1"; 1623    String DRDA_INVALID_XA_STATE_ON_COMMIT_OR_ROLLBACK = "2D521.S.2"; 1624    String DRDA_CURSOR_NOT_OPEN = "24501.S"; 1625 1626    // 58009 means connection is terminated. This can be caused by any number 1627 // of reasons, so this SQL State has a lot of instances. 1628 // 1629 // NOTE: if the disconnection is not caused by DRDA-level error, you should 1630 // use SQL State 08006. The way I determined this is if the error occurs 1631 // in the 'client.net' package, use 58009. If it occurs in the 'client.am' 1632 // or any other client package, use 08006. It's really not at all clear 1633 // from the specs when you should use one SQL state or the other, but that's 1634 // the approach I chose (David Van Couvering). 1635 String DRDA_CONNECTION_TERMINATED = "58009.C"; 1636    // Use this version of SOCKET_EXCEPTION any time *except* when trying to 1637 // establish a connection, as the SQLState is different. When trying 1638 // to establish a connection, use CONNECT_SOCKET_EXCEPTION. 1639 String SOCKET_EXCEPTION = "58009.C.2"; 1640    String COMMUNICATION_ERROR = "58009.C.3"; 1641    String CONNECTION_FAILED_ON_DEFERRED_RESET = "58009.C.4"; 1642    String NET_INSUFFICIENT_DATA = "58009.C.5"; 1643    String NET_LOB_DATA_TOO_LARGE_FOR_JVM = "58009.C.6"; 1644    String NET_SQLCDTA_INVALID_FOR_RDBCOLID = "58009.C.7"; 1645    String NET_SQLCDTA_INVALID_FOR_PKGID = "58009.C.8"; 1646    String NET_PGNAMCSN_INVALID_AT_SQLAM = "58009.C.9"; 1647    String NET_VCM_VCS_LENGTHS_INVALID = "58009.C.10"; 1648    String NET_ENCODING_NOT_SUPPORTED = "58009.C.11"; 1649    String NET_NOT_EXPECTED_CODEPOINT = "58009.C.12"; 1650    String NET_DDM_COLLECTION_TOO_SMALL = "58009.C.13"; 1651    String NET_COLLECTION_STACK_NOT_EMPTY = "58009.C.14"; 1652    String NET_DSS_NOT_ZERO = "58009.C.15"; 1653    String NET_DSS_CHAINED_WITH_SAME_ID = "58009.C.16"; 1654    String NET_PREMATURE_EOS_DISCONNECT = "58009.C.17"; 1655    String NET_INVALID_FDOCA_ID = "58009.C.18"; 1656    String NET_SECTKN_NOT_RETURNED = "58009.C.19"; 1657    String NET_NVCM_NVCS_BOTH_NON_NULL = "58009.C.20"; 1658    String NET_SQLCDTA_INVALID_FOR_RDBNAM = "58009.C.21"; 1659 1660    String DRDA_MGRLVLRM = "58010.C"; 1661    String DRDA_DDM_COMMAND_NOT_SUPPORTED = "58014.C"; 1662    String DRDA_DDM_OBJECT_NOT_SUPPORTED = "58015.C"; 1663    String DRDA_DDM_PARAM_NOT_SUPPORTED = "58016.C"; 1664    String DRDA_DDM_PARAMVAL_NOT_SUPPORTED = "58017.C"; 1665    String DRDA_NO_AVAIL_CODEPAGE_CONVERSION = "57017.C"; 1666     1667    /* 1668    ** org.apache.derby.database.UserUtility 1669        */ 1670    String UU_UNKNOWN_PERMISSION = "XCZ00.S"; 1671    String UU_UNKNOWN_USER = "XCZ01.S"; 1672    String UU_INVALID_PARAMETER = "XCZ02.S"; 1673 1674    /* 1675    ** SQL Java DDL 46xxx 1676    ** SQLJ jar file support 1677    */ 1678    String SQLJ_INVALID_JAR = "46001"; 1679    String SQLJ_SIGNATURE_INVALID = "46J01"; 1680    String SQLJ_SIGNATURE_PARAMETER_COUNT = "46J02"; 1681 1682    /* 1683    ** Import/Export 1684    */ 1685    String CONNECTION_NULL ="XIE01.S"; 1686    String DATA_AFTER_STOP_DELIMITER ="XIE03.S"; 1687    String DATA_FILE_NOT_FOUND ="XIE04.S"; 1688    String DATA_FILE_NULL ="XIE05.S"; 1689    String ENTITY_NAME_MISSING ="XIE06.S"; 1690    String FIELD_IS_RECORD_SEPERATOR_SUBSET ="XIE07.S"; 1691    String INVALID_COLUMN_NAME ="XIE08.S"; 1692    String INVALID_COLUMN_NUMBER ="XIE09.S"; 1693    String UNSUPPORTED_COLUMN_TYPE ="XIE0B.S"; 1694    String RECORD_SEPERATOR_MISSING ="XIE0D.S"; 1695    String UNEXPECTED_END_OF_FILE ="XIE0E.S"; 1696    String ERROR_WRITING_DATA ="XIE0I.S"; 1697    String DELIMITERS_ARE_NOT_MUTUALLY_EXCLUSIVE ="XIE0J.S"; 1698    String PERIOD_AS_CHAR_DELIMITER_NOT_ALLOWED ="XIE0K.S"; 1699    String TABLE_NOT_FOUND ="XIE0M.S"; 1700} 1701 1702

A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame Popular Tags