0001: /*
0002:
0003: Derby - Class org.apache.derby.shared.common.reference.SQLState
0004:
0005: Licensed to the Apache Software Foundation (ASF) under one or more
0006: contributor license agreements. See the NOTICE file distributed with
0007: this work for additional information regarding copyright ownership.
0008: The ASF licenses this file to You under the Apache License, Version 2.0
0009: (the "License"); you may not use this file except in compliance with
0010: the License. You may obtain a copy of the License at
0011:
0012: http://www.apache.org/licenses/LICENSE-2.0
0013:
0014: Unless required by applicable law or agreed to in writing, software
0015: distributed under the License is distributed on an "AS IS" BASIS,
0016: WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
0017: See the License for the specific language governing permissions and
0018: limitations under the License.
0019:
0020: */
0021:
0022: package org.apache.derby.shared.common.reference;
0023:
0024: /**
0025: List of error message identifiers.
0026: This is the set of message identifiers. The message identifier
0027: also encodes the SQLState as the first five characters.
0028: StandardExceptions must be created using the static
0029: StandardException.newException() method calls, passing in a
0030: field from this class.
0031: <BR>
0032: The five character SQL State is obtained from a StandardException
0033: using the zero-argument StandardException.getSQLState() method.
0034: <BR>
0035: The message identifier (ie. the value that matches a field in this class)
0036: is obtained using the zero-argument StandardException.getMessageId() method.
0037: <BR>
0038: Thus if checking for a specific error using a field from this interface
0039: the correct code is
0040: <PRE>
0041: if (se.getMessageId().equals(SQLState.DEADLOCK))
0042: </PRE>
0043: <BR>
0044: A utility static method StandardException.getSQLState(String messageId)
0045: exists to convert an field from this class into a five character SQLState.
0046: <P>
0047:
0048: <P>
0049: The SQL state of an error message dictates the error's severity.
0050: The severity is determined from the first two characters of the
0051: state if the state is five characters long, otherwise the state
0052: is expected to be 7 characters long and the last character determines
0053: the state. If the state is seven characters long then only the first
0054: five will be seen by the error reporting code and exception.
0055: <BR>
0056: If the state is 9 characters long, the last two characters encode
0057: an exception category, which Synchronization uses to determine whether
0058: the error causes REFRESH to halt or to simply skip the failed transaction.
0059: All 5 and 7 character states default to the ENVIRONMENTAL exception
0060: category.
0061: <BR>
0062: Here is the encoding of the SQL state, broken down by severity.
0063: <UL>
0064: <LI> <B> SYSTEM_SEVERITY </B>
0065: xxxxx.M
0066:
0067: <LI> <B> DATABASE_SEVERITY </B>
0068: xxxxx.D
0069:
0070: <LI> <B> SESSION_SEVERITY </B>
0071: 08xxx
0072: xxxxx.C
0073:
0074: <LI> <B> TRANSACTION_SEVERITY </B>
0075: 40xxx or xxxxx.T
0076:
0077: <LI> <B> STATEMENT_SEVERITY </B>
0078: {2,3}xxxx, 42xxx, 07xxx or xxxxx.S
0079:
0080: <LI> <B> WARNING_SEVERITY </B>
0081: 01xxx <EM> SQL State rules require that warnings have states starting with 01</EM>
0082:
0083: <LI> <B> NO_APPLICABLE_SEVERITY </B>
0084: YYxxx (YY means none of the above) or xxxxx.U
0085:
0086: <LI> <B> TRANSIENT exception category </B>
0087: xxxxx.Y#T (Y can be any of the preceding severities)
0088:
0089: <LI> <B> CONSISTENCY exception category </B>
0090: xxxxx.Y#C (Y can be any of the preceding severities)
0091:
0092: <LI> <B> ENVIRONMENTAL exception category (the default)</B>
0093: xxxxx.Y#E (Y can be any of the preceding severities)
0094:
0095: <LI> <B> WRAPPED exception category</B>
0096: xxxxx.Y#W (Y can be any of the preceding severities)
0097:
0098: </UL>
0099: <HR>
0100: <P>
0101: <B>SQL State ranges</B>
0102: <UL>
0103: <LI>Basic Services
0104: <UL>
0105: <LI> XBCA CacheService
0106: <LI> XBCM ClassManager
0107: <LI> XBCX Cryptography
0108: <LI> XBM0 Monitor
0109: <LI> XBDA DataComm
0110: <LI> XCY0 Properties
0111: </UL>
0112:
0113: <LI>Connectivity
0114: <UL>
0115: <LI> 08XXX Connection Exceptions
0116: </UL>
0117:
0118:
0119: <LI>Language
0120: <UL>
0121: <LI> 2200J-2200R for SQL/XML errors (based on SQL/XML[2006]) </LI>
0122: <LI> 42800-? for compatible DB2 errors
0123: <LI> 42X00-42Zxx for compilation errors </LI>
0124: <LI> 43X00-43Yxx for org.apache.derby.impl.sql.execute.rts
0125: <LI> 44X00 for all other org.apache.derby.catalog.types
0126: <LI> 46000 for SQLJ errors (for now, leave this range empty) </LI>
0127: <LI> 38000 SQL3 ranges </LI>
0128: <LI> XD00x Dependency mgr </LI>
0129: <LI> XMLxx Misc XML errors not covered by SQL standard </LI>
0130: <LI>
0131: </UL>
0132:
0133: <LI>Store
0134: <UL>
0135: <LI> XSCG0 Conglomerate
0136: <LI> XSCH0 Heap
0137: </UL>
0138:
0139: <LI>Reserved for IBM Use: XQC00 - XQCZZ
0140: </UL>
0141: */
0142:
0143: public interface SQLState {
0144:
0145: /*
0146: ** BasicServices
0147: */
0148:
0149: /*
0150: ** Monitor
0151: */
0152: String SERVICE_STARTUP_EXCEPTION = "XBM01.D";
0153: String SERVICE_MISSING_IMPLEMENTATION = "XBM02.D";
0154: String MISSING_PRODUCT_VERSION = "XBM05.D";
0155: String SERVICE_WRONG_BOOT_PASSWORD = "XBM06.D";
0156: String SERVICE_BOOT_PASSWORD_TOO_SHORT = "XBM07.D";
0157: String MISSING_ENCRYPTION_PROVIDER = "XBM0G.D";
0158: String SERVICE_DIRECTORY_CREATE_ERROR = "XBM0H.D";
0159: String SERVICE_DIRECTORY_REMOVE_ERROR = "XBM0I.D";
0160: String SERVICE_DIRECTORY_EXISTS_ERROR = "XBM0J.D";
0161: String PROTOCOL_UNKNOWN = "XBM0K.D";
0162:
0163: // these were originally ModuleStartupExceptions
0164: String AUTHENTICATION_NOT_IMPLEMENTED = "XBM0L.D";
0165: String AUTHENTICATION_SCHEME_ERROR = "XBM0M.D";
0166: String JDBC_DRIVER_REGISTER = "XBM0N.D";
0167: String READ_ONLY_SERVICE = "XBM0P.D";
0168: String UNABLE_TO_RENAME_FILE = "XBM0S.D";
0169: String AMBIGIOUS_PROTOCOL = "XBM0T.D";
0170:
0171: String REGISTERED_CLASS_NONE = "XBM0U.S";
0172: String REGISTERED_CLASS_LINAKGE_ERROR = "XBM0V.S";
0173: String REGISTERED_CLASS_INSTANCE_ERROR = "XBM0W.S";
0174: String INVALID_LOCALE_DESCRIPTION = "XBM0X.D";
0175: String SERVICE_DIRECTORY_NOT_IN_BACKUP = "XBM0Y.D";
0176: String UNABLE_TO_COPY_FILE_FROM_BACKUP = "XBM0Z.D";
0177: String PROPERTY_FILE_NOT_FOUND_IN_BACKUP = "XBM0Q.D";
0178: String UNABLE_TO_DELETE_FILE = "XBM0R.D";
0179: String INSTANTIATE_STORAGE_FACTORY_ERROR = "XBM08.D";
0180:
0181: /*
0182: ** Upgrade
0183: */
0184: String UPGRADE_UNSUPPORTED = "XCW00.D";
0185: // Note: UPGRADE_SPSRECOMPILEFAILED is now in the warnings section.
0186:
0187: /*
0188: ** ContextService
0189: */
0190: String CONN_INTERRUPT = "08000";
0191:
0192: /*
0193: ** ClassManager
0194: */
0195: String GENERATED_CLASS_LINKAGE_ERROR = "XBCM1.S";
0196: String GENERATED_CLASS_INSTANCE_ERROR = "XBCM2.S";
0197: String GENERATED_CLASS_NO_SUCH_METHOD = "XBCM3.S";
0198: String GENERATED_CLASS_LIMIT_EXCEEDED = "XBCM4.S";
0199:
0200: /*
0201: ** Cryptography
0202: */
0203: String CRYPTO_EXCEPTION = "XBCX0.S";
0204: String ILLEGAL_CIPHER_MODE = "XBCX1.S";
0205: String ILLEGAL_BP_LENGTH = "XBCX2.S";
0206: String NULL_BOOT_PASSWORD = "XBCX5.S";
0207: String NON_STRING_BP = "XBCX6.S";
0208: String WRONG_PASSWORD_CHANGE_FORMAT = "XBCX7.S";
0209: String DATABASE_NOT_ENCRYPTED = "XBCX8.S";
0210: String DATABASE_READ_ONLY = "XBCX9.S";
0211: String WRONG_BOOT_PASSWORD = "XBCXA.S";
0212: String ENCRYPTION_BAD_PADDING = "XBCXB.S";
0213: String ENCRYPTION_NOSUCH_ALGORITHM = "XBCXC.S";
0214: String ENCRYPTION_NOCHANGE_ALGORITHM = "XBCXD.S";
0215: String ENCRYPTION_NOCHANGE_PROVIDER = "XBCXE.S";
0216: String ENCRYPTION_NO_PROVIDER_CLASS = "XBCXF.S";
0217: String ENCRYPTION_BAD_PROVIDER = "XBCXG.S";
0218: String ENCRYPTION_BAD_ALG_FORMAT = "XBCXH.S";
0219: String ENCRYPTION_BAD_FEEDBACKMODE = "XBCXI.S";
0220: String ENCRYPTION_BAD_JCE = "XBCXJ.S";
0221: String ENCRYPTION_BAD_EXTERNAL_KEY = "XBCXK.S";
0222: String ENCRYPTION_UNABLE_KEY_VERIFICATION = "XBCXL.S";
0223: String ENCRYPTION_INVALID_EXKEY_LENGTH = "XBCXM.S";
0224: String ENCRYPTION_ILLEGAL_EXKEY_CHARS = "XBCXN.S";
0225: String ENCRYPTION_PREPARED_XACT_EXIST = "XBCXO.S";
0226: String REENCRYPTION_PREPARED_XACT_EXIST = "XBCXP.S";
0227: String CANNOT_ENCRYPT_READONLY_DATABASE = "XBCXQ.S";
0228: String CANNOT_REENCRYPT_READONLY_DATABASE = "XBCXR.S";
0229: String CANNOT_ENCRYPT_LOG_ARCHIVED_DATABASE = "XBCXS.S";
0230: String CANNOT_REENCRYPT_LOG_ARCHIVED_DATABASE = "XBCXT.S";
0231: String DATABASE_ENCRYPTION_FAILED = "XBCXU.S";
0232: String DATABASE_REENCRYPTION_FAILED = "XBCXV.S";
0233:
0234: /*
0235: ** Cache Service
0236: */
0237: String OBJECT_EXISTS_IN_CACHE = "XBCA0.S";
0238:
0239: /*
0240: ** Properties
0241: */
0242: String PROPERTY_INVALID_VALUE = "XCY00.S";
0243: String PROPERTY_UNSUPPORTED_CHANGE = "XCY02.S";
0244: String PROPERTY_MISSING = "XCY03.S";
0245: String PROPERTY_SYNTAX_INVALID = "XCY04.S";
0246:
0247: /*
0248: ** LockManager
0249: */
0250: String DEADLOCK = "40001";
0251: String LOCK_TIMEOUT = "40XL1";
0252: String LOCK_TIMEOUT_LOG = "40XL2";
0253:
0254: /*
0255: ** Store - access.protocol.Interface statement exceptions
0256: */
0257: String STORE_CONGLOMERATE_DOES_NOT_EXIST = "XSAI2.S";
0258: String STORE_FEATURE_NOT_IMPLEMENTED = "XSAI3.S";
0259:
0260: /*
0261: ** Store - access.protocol.Interface RunTimeStatistics property names
0262: ** and values.
0263: */
0264: String STORE_RTS_SCAN_TYPE = "XSAJ0.U";
0265: String STORE_RTS_NUM_PAGES_VISITED = "XSAJ1.U";
0266: String STORE_RTS_NUM_ROWS_VISITED = "XSAJ2.U";
0267: String STORE_RTS_NUM_DELETED_ROWS_VISITED = "XSAJ3.U";
0268: String STORE_RTS_NUM_ROWS_QUALIFIED = "XSAJ4.U";
0269: String STORE_RTS_NUM_COLUMNS_FETCHED = "XSAJ5.U";
0270: String STORE_RTS_COLUMNS_FETCHED_BIT_SET = "XSAJ6.U";
0271: String STORE_RTS_TREE_HEIGHT = "XSAJ7.U";
0272: String STORE_RTS_SORT_TYPE = "XSAJ8.U";
0273: String STORE_RTS_NUM_ROWS_INPUT = "XSAJA.U";
0274: String STORE_RTS_NUM_ROWS_OUTPUT = "XSAJB.U";
0275: String STORE_RTS_NUM_MERGE_RUNS = "XSAJC.U";
0276: String STORE_RTS_MERGE_RUNS_SIZE = "XSAJD.U";
0277: String STORE_RTS_ALL = "XSAJE.U";
0278: String STORE_RTS_BTREE = "XSAJF.U";
0279: String STORE_RTS_HEAP = "XSAJG.U";
0280: String STORE_RTS_SORT = "XSAJH.U";
0281: String STORE_RTS_EXTERNAL = "XSAJI.U";
0282: String STORE_RTS_INTERNAL = "XSAJJ.U";
0283:
0284: /*
0285: ** Store - access.protocol.XA statement exceptions
0286: */
0287: String STORE_XA_PROTOCOL_VIOLATION = "XSAX0.S";
0288: // STORE_XA_PROTOCOL_VIOLATION_SQLSTATE has no associated message it is
0289: // just a constant used by the code so that an exception can be caught
0290: // and programatically determined to be a STORE_XA_PROTOCOL_VIOLATION.
0291: String STORE_XA_PROTOCOL_VIOLATION_SQLSTATE = "XSAX0";
0292: String STORE_XA_XAER_DUPID = "XSAX1.S";
0293: // STORE_XA_XAER_DUPID_SQLSTATE has no associated message it is
0294: // just a constant used by the code so that an exception can be caught
0295: // and programatically determined to be a STORE_XA_XAER_DUPID.
0296: String STORE_XA_XAER_DUPID_SQLSTATE = "XSAX1";
0297:
0298: /*
0299: ** Store - Conglomerate
0300: */
0301: String CONGLOMERATE_TEMPLATE_CREATE_ERROR = "XSCG0.S";
0302:
0303: /*
0304: ** Store - AccessManager
0305: */
0306: String AM_NO_FACTORY_FOR_IMPLEMENTATION = "XSAM0.S";
0307: String AM_NO_SUCH_CONGLOMERATE_DROP = "XSAM2.S";
0308: String AM_NO_SUCH_CONGLOMERATE_TYPE = "XSAM3.S";
0309: String AM_NO_SUCH_SORT = "XSAM4.S";
0310: String AM_SCAN_NOT_POSITIONED = "XSAM5.S";
0311: String AM_RECORD_NOT_FOUND = "XSAM6.S";
0312:
0313: /*
0314: ** Store - Heap
0315: */
0316: String HEAP_CANT_CREATE_CONTAINER = "XSCH0.S";
0317: String HEAP_CONTAINER_NOT_FOUND = "XSCH1.S";
0318: String HEAP_COULD_NOT_CREATE_CONGLOMERATE = "XSCH4.S";
0319: String HEAP_TEMPLATE_MISMATCH = "XSCH5.S";
0320: String HEAP_IS_CLOSED = "XSCH6.S";
0321: String HEAP_SCAN_NOT_POSITIONED = "XSCH7.S";
0322: String HEAP_UNIMPLEMENTED_FEATURE = "XSCH8.S";
0323:
0324: /*
0325: ** Store - BTree
0326: */
0327: String BTREE_CANT_CREATE_CONTAINER = "XSCB0.S";
0328: String BTREE_CONTAINER_NOT_FOUND = "XSCB1.S";
0329: String BTREE_PROPERTY_NOT_FOUND = "XSCB2.S";
0330: String BTREE_UNIMPLEMENTED_FEATURE = "XSCB3.S";
0331: String BTREE_SCAN_NOT_POSITIONED = "XSCB4.S";
0332: String BTREE_ROW_NOT_FOUND_DURING_UNDO = "XSCB5.S";
0333: String BTREE_NO_SPACE_FOR_KEY = "XSCB6.S";
0334: String BTREE_SCAN_INTERNAL_ERROR = "XSCB7.S";
0335: String BTREE_IS_CLOSED = "XSCB8.S";
0336: String BTREE_ABORT_THROUGH_TRACE = "XSCB9.S";
0337:
0338: /*
0339: ** Store - Sort
0340: */
0341: String SORT_IMPROPER_SCAN_METHOD = "XSAS0.S";
0342: String SORT_SCAN_NOT_POSITIONED = "XSAS1.S";
0343:
0344: String SORT_TYPE_MISMATCH = "XSAS3.S";
0345: String SORT_COULD_NOT_INIT = "XSAS6.S";
0346:
0347: /*
0348: ** RawStore
0349: */
0350:
0351: /*
0352: ** RawStore - protocol.Interface statement exceptions
0353: */
0354: String RAWSTORE_NESTED_FREEZE = "XSRS0.S";
0355: String RAWSTORE_CANNOT_BACKUP_TO_NONDIRECTORY = "XSRS1.S";
0356: String RAWSTORE_ERROR_RENAMING_FILE = "XSRS4.S";
0357: String RAWSTORE_ERROR_COPYING_FILE = "XSRS5.S";
0358: String RAWSTORE_CANNOT_CREATE_BACKUP_DIRECTORY = "XSRS6.S";
0359: String RAWSTORE_UNEXPECTED_EXCEPTION = "XSRS7.S";
0360: String RAWSTORE_CANNOT_CHANGE_LOGDEVICE = "XSRS8.S";
0361: String RAWSTORE_RECORD_VANISHED = "XSRS9.S";
0362: String BACKUP_BLOCKING_OPERATIONS_IN_PROGRESS = "XSRSA.S";
0363: String BACKUP_OPERATIONS_NOT_ALLOWED = "XSRSB.S";
0364: String RAWSTORE_CANNOT_BACKUP_INTO_DATABASE_DIRECTORY = "XSRSC.S";
0365:
0366: /*
0367: ** RawStore - Log.Generic statement exceptions
0368: */
0369: String LOG_WRITE_LOG_RECORD = "XSLB1.S";
0370: String LOG_BUFFER_FULL = "XSLB2.S";
0371: String LOG_TRUNC_LWM_NULL = "XSLB4.S";
0372: String LOG_TRUNC_LWM_ILLEGAL = "XSLB5.S";
0373: String LOG_ZERO_LENGTH_LOG_RECORD = "XSLB6.S";
0374: String LOG_RESET_BEYOND_SCAN_LIMIT = "XSLB8.S";
0375: String LOG_FACTORY_STOPPED = "XSLB9.S";
0376:
0377: /*
0378: ** RawStore - Log.Generic database exceptions
0379: */
0380: String LOG_CANNOT_FLUSH = "XSLA0.D";
0381: String LOG_DO_ME_FAIL = "XSLA1.D";
0382: String LOG_IO_ERROR = "XSLA2.D";
0383: String LOG_CORRUPTED = "XSLA3.D";
0384: String LOG_FULL = "XSLA4.D";
0385: String LOG_READ_LOG_FOR_UNDO = "XSLA5.D";
0386: String LOG_RECOVERY_FAILED = "XSLA6.D";
0387: String LOG_REDO_FAILED = "XSLA7.D";
0388: String LOG_UNDO_FAILED = "XSLA8.D";
0389: String LOG_STORE_CORRUPT = "XSLAA.D";
0390: String LOG_FILE_NOT_FOUND = "XSLAB.D";
0391: String LOG_INCOMPATIBLE_FORMAT = "XSLAC.D";
0392: String LOG_RECORD_CORRUPTED = "XSLAD.D";
0393: String LOG_CONTROL_FILE = "XSLAE.D";
0394: String LOG_READ_ONLY_DB_NEEDS_UNDO = "XSLAF.D";
0395: String LOG_READ_ONLY_DB_UPDATE = "XSLAH.D";
0396: String LOG_CANNOT_LOG_CHECKPOINT = "XSLAI.D";
0397: String LOG_NULL = "XSLAJ.D";
0398: String LOG_EXCEED_MAX_LOG_FILE_NUMBER = "XSLAK.D";
0399: String LOG_EXCEED_MAX_LOG_FILE_SIZE = "XSLAL.D";
0400: String LOG_CANNOT_VERIFY_LOG_FORMAT = "XSLAM.D";
0401: String LOG_INCOMPATIBLE_VERSION = "XSLAN.D";
0402: String LOG_UNEXPECTED_RECOVERY_PROBLEM = "XSLAO.D";
0403: String LOG_CANNOT_UPGRADE_BETA = "XSLAP.D";
0404: String LOG_SEGMENT_NOT_EXIST = "XSLAQ.D";
0405: String UNABLE_TO_COPY_LOG_FILE = "XSLAR.D";
0406: String LOG_DIRECTORY_NOT_FOUND_IN_BACKUP = "XSLAS.D";
0407: String LOG_SEGMENT_EXIST = "XSLAT.D";
0408:
0409: /*
0410: ** RawStore - Transactions.Basic statement exceptions
0411: */
0412: String XACT_MAX_SAVEPOINT_LEVEL_REACHED = "3B002.S";
0413: //Bug 4466 - changed sqlstate for following two to match DB2 sqlstates.
0414: String XACT_SAVEPOINT_EXISTS = "3B501.S";
0415: String XACT_SAVEPOINT_NOT_FOUND = "3B001.S";
0416: //Bug 4468 - release/rollback of savepoint failed because it doesn't exist
0417: String XACT_SAVEPOINT_RELEASE_ROLLBACK_FAIL = "3B502.S";
0418: String XACT_TRANSACTION_ACTIVE = "XSTA2.S";
0419:
0420: /*
0421: ** RawStore - Transactions.Basic transaction exceptions
0422: */
0423: String TRANSACTION_PREFIX = "40";
0424:
0425: String XACT_PROTOCOL_VIOLATION = "40XT0";
0426: String XACT_COMMIT_EXCEPTION = "40XT1";
0427: String XACT_ROLLBACK_EXCEPTION = "40XT2";
0428: String XACT_TRANSACTION_NOT_IDLE = "40XT4";
0429: String XACT_INTERNAL_TRANSACTION_EXCEPTION = "40XT5";
0430: String XACT_CANNOT_ACTIVATE_TRANSACTION = "40XT6";
0431: String XACT_NOT_SUPPORTED_IN_INTERNAL_XACT = "40XT7";
0432:
0433: /*
0434: ** RawStore - Transactions.Basic system exceptions
0435: */
0436: String XACT_ABORT_EXCEPTION = "XSTB0.M";
0437: String XACT_CANNOT_LOG_CHANGE = "XSTB2.M";
0438: String XACT_CANNOT_ABORT_NULL_LOGGER = "XSTB3.M";
0439: String XACT_CREATE_NO_LOG = "XSTB5.M";
0440: String XACT_TRANSACTION_TABLE_IN_USE = "XSTB6.M";
0441:
0442: /*
0443: ** RawStore - Data.Generic statement exceptions
0444: */
0445: String DATA_SLOT_NOT_ON_PAGE = "XSDA1.S";
0446: String DATA_UPDATE_DELETED_RECORD = "XSDA2.S";
0447: String DATA_NO_SPACE_FOR_RECORD = "XSDA3.S";
0448: String DATA_UNEXPECTED_EXCEPTION = "XSDA4.S";
0449: String DATA_UNDELETE_RECORD = "XSDA5.S";
0450: String DATA_NULL_STORABLE_COLUMN = "XSDA6.S";
0451: String DATA_STORABLE_READ_MISMATCH = "XSDA7.S";
0452: String DATA_STORABLE_READ_EXCEPTION = "XSDA8.S";
0453: String DATA_STORABLE_READ_MISSING_CLASS = "XSDA9.S";
0454: String DATA_TIME_STAMP_ILLEGAL = "XSDAA.S";
0455: String DATA_TIME_STAMP_NULL = "XSDAB.S";
0456: String DATA_DIFFERENT_CONTAINER = "XSDAC.S";
0457: String DATA_NO_ROW_COPIED = "XSDAD.S";
0458: String DATA_CANNOT_MAKE_RECORD_HANDLE = "XSDAE.S";
0459: String DATA_INVALID_RECORD_HANDLE = "XSDAF.S";
0460: String DATA_ALLOC_NTT_CANT_OPEN = "XSDAG.S";
0461: String DATA_CANNOT_GET_DEALLOC_LOCK = "XSDAI.S";
0462: String DATA_STORABLE_WRITE_EXCEPTION = "XSDAJ.S";
0463: String DATA_WRONG_PAGE_FOR_HANDLE = "XSDAK.S";
0464: String DATA_UNEXPECTED_OVERFLOW_PAGE = "XSDAL.S";
0465: String DATA_SQLDATA_READ_INSTANTIATION_EXCEPTION = "XSDAM.S";
0466: String DATA_SQLDATA_READ_ILLEGAL_ACCESS_EXCEPTION = "XSDAN.S";
0467:
0468: /*
0469: ** RawStore - Data.Generic transaction exceptions
0470: */
0471: String DATA_CORRUPT_PAGE = "XSDB0.D";
0472: String DATA_UNKNOWN_PAGE_FORMAT = "XSDB1.D";
0473: String DATA_UNKNOWN_CONTAINER_FORMAT = "XSDB2.D";
0474: String DATA_CHANGING_CONTAINER_INFO = "XSDB3.D";
0475: String DATA_MISSING_LOG = "XSDB4.D";
0476: String DATA_MISSING_PAGE = "XSDB5.D";
0477: String DATA_MULTIPLE_JBMS_ON_DB = "XSDB6.D";
0478: String DATA_MULTIPLE_JBMS_WARNING = "XSDB7.D";
0479: String DATA_MULTIPLE_JBMS_FORCE_LOCK = "XSDB8.D";
0480: String DATA_CORRUPT_STREAM_CONTAINER = "XSDB9.D";
0481: String DATA_OBJECT_ALLOCATION_FAILED = "XSDBA.D";
0482:
0483: /*
0484: ** RawStore - Data.Filesystem statement exceptions
0485: */
0486: String FILE_EXISTS = "XSDF0.S";
0487: String FILE_CREATE = "XSDF1.S";
0488: String FILE_CREATE_NO_CLEANUP = "XSDF2.S";
0489: String FILE_CANNOT_CREATE_SEGMENT = "XSDF3.S";
0490: String FILE_CANNOT_REMOVE_FILE = "XSDF4.S";
0491: String FILE_NO_ALLOC_PAGE = "XSDF6.S";
0492: String FILE_NEW_PAGE_NOT_LATCHED = "XSDF7.S";
0493: String FILE_REUSE_PAGE_NOT_FOUND = "XSDF8.S";
0494: String FILE_READ_ONLY = "XSDFB.S";
0495: String FILE_IO_GARBLED = "XSDFD.S";
0496: String FILE_UNEXPECTED_EXCEPTION = "XSDFF.S";
0497: String BACKUP_FILE_IO_ERROR = "XSDFH.S";
0498: String FILE_NEW_PAGE_DURING_RECOVERY = "XSDFI.S";
0499:
0500: /*
0501: ** RawStore - Data.FSLDemo transaction exceptions
0502: */
0503:
0504: /*
0505: ** RawStore - Data.Filesystem database exceptions
0506: */
0507: String FILE_READ_PAGE_EXCEPTION = "XSDG0.D";
0508: String FILE_WRITE_PAGE_EXCEPTION = "XSDG1.D";
0509: String FILE_BAD_CHECKSUM = "XSDG2.D";
0510: String FILE_CONTAINER_EXCEPTION = "XSDG3.D";
0511: String FILE_DATABASE_NOT_IN_CREATE = "XSDG5.D";
0512: String DATA_DIRECTORY_NOT_FOUND_IN_BACKUP = "XSDG6.D";
0513: String UNABLE_TO_REMOVE_DATA_DIRECTORY = "XSDG7.D";
0514: String UNABLE_TO_COPY_DATA_DIRECTORY = "XSDG8.D";
0515:
0516: /*
0517: ** InternalUtil - Id Parsing
0518: ** Note that the code catches ID parsing errors.
0519: ** (Range XCXA0-XCXAZ)
0520: */
0521: String ID_PARSE_ERROR = "XCXA0.S";
0522:
0523: /*
0524: ** InternalUtil - Database Class Path Parsing
0525: ** Note that the code catches database class path parsing errors.
0526: ** (Range XCXB0-XCXBZ)
0527: */
0528: String DB_CLASS_PATH_PARSE_ERROR = "XCXB0.S";
0529:
0530: /*
0531: ** InternalUtil - Id List Parsing
0532: ** Note that the code catches id list parsing errors.
0533: ** (Range XCXC0-XCXCZ)
0534: */
0535: String ID_LIST_PARSE_ERROR = "XCXC0.S";
0536:
0537: /*
0538: ** InternalUtil - IO Errors
0539: ** (Range XCXD0-XCXDZ)
0540: */
0541:
0542: /*
0543: ** InternalUtil - LocaleFinder interface
0544: */
0545: String NO_LOCALE = "XCXE0.S";
0546:
0547: String DATA_CONTAINER_CLOSED = "40XD0";
0548: String DATA_CONTAINER_READ_ONLY = "40XD1";
0549: String DATA_CONTAINER_VANISHED = "40XD2";
0550:
0551: /*
0552: ** Connectivity - Connection Exceptions: 08XXX
0553: */
0554: String CONNECTIVITY_PREFIX = "08";
0555:
0556: /*
0557: ** Language
0558: */
0559:
0560: /*
0561: ** Language Statement Exception
0562: */
0563: String LSE_COMPILATION_PREFIX = "42";
0564:
0565: /*
0566: ** Language
0567: **
0568: ** The entries in this file are sorted into groups. Add your entry
0569: ** to the appropriate group. Language errors are divided into 3 groups:
0570: ** A group for standard SQLExceptions.
0571: **
0572: ** 2200J-00R - For SQL/XML errors (based on SQL/XML[2006]).
0573: ** 428?? - adding some DB2 compatible errors
0574: ** 42X00-42Zxx for compilation errors
0575: ** 46000 for SQLJ errors (for now, leave this range empty)
0576: ** 38000 SQL3 ranges
0577: ** 39001 SQL3
0578: ** X0X00-X0Xxx for implementation-defined execution errors.
0579: **
0580: ** NOTE: If an error can occur during both compilation and execution, then
0581: ** you need 2 different errors.
0582: **
0583: ** In addition to the above groups, this file also contains SQLStates
0584: ** for language transaction severity errors. These are in the range
0585: **
0586: ** 40XC0 - 40XCZ
0587: **
0588: ** implementation-defined range reserved for class 23 is L01-LZZ
0589: **
0590: **
0591: ** Errors that have standard SQLStates
0592: **
0593: ** Implementation-defined subclasses must begin with a digit from 5 through 9,
0594: ** or a letter from I through Z (capitals only).
0595: **
0596: */
0597:
0598: /*
0599: **
0600: ** SQL-J ERRORS -- see jamie for further info
0601: **
0602: ** DDL
0603: ** 46001 - invalid URL
0604: ** 46002 - invalid JAR name
0605: ** 46003 - invalid class deletion
0606: ** 46004 - invalid JAR name
0607: ** 46005 - invalid replacement
0608: ** 46006 - invalid grantee
0609: ** 46007 - invalid signature
0610: ** 46008 - invalid method specification
0611: ** 46009 - invalid REVOKE
0612: **
0613: ** Execution
0614: ** 46102 - invalid jar name in path
0615: ** 46103 - unresolved class name
0616: ** 0100E - too many result sets
0617: ** 39001 - invalid SQLSTATE
0618: ** 39004 - invalid null value
0619: ** 38000 - uncaught java exception
0620: ** 38mmm - user defined error numbers
0621: ** to be used in the future
0622: ** InvalidNullValue.sqlstate=39004
0623: */
0624:
0625: // WARNINGS (start with 01)
0626: String LANG_CONSTRAINT_DROPPED = "01500";
0627: String LANG_VIEW_DROPPED = "01501";
0628: String LANG_TRIGGER_DROPPED = "01502";
0629: String LANG_COL_NOT_NULL = "01503";
0630: String LANG_INDEX_DUPLICATE = "01504";
0631: String LANG_VALUE_TRUNCATED = "01505";
0632: String LANG_SYNONYM_UNDEFINED = "01522";
0633: String LANG_NULL_ELIMINATED_IN_SET_FUNCTION = "01003";
0634: String LANG_PRIVILEGE_NOT_REVOKED = "01006";
0635:
0636: String LANG_NO_ROW_FOUND = "02000";
0637:
0638: String LANG_TOO_MANY_DYNAMIC_RESULTS_RETURNED = "0100E";
0639:
0640: // TRANSACTION severity language errors. These are in the range:
0641: // 40XC0 - 40XCZ
0642: String LANG_DEAD_STATEMENT = "40XC0";
0643:
0644: /*
0645: ** SQL Data exceptions
0646: */
0647: String SQL_DATA_PREFIX = "22";
0648:
0649: String LANG_MISSING_PARMS = "07000";
0650: String LANG_SCALAR_SUBQUERY_CARDINALITY_VIOLATION = "21000";
0651: String LANG_STRING_TRUNCATION = "22001";
0652: String LANG_CONCAT_STRING_OVERFLOW = "54006";
0653: String LANG_OUTSIDE_RANGE_FOR_DATATYPE = "22003";
0654: String YEAR_EXCEEDS_MAXIMUM = "22003.S.1";
0655: String DECIMAL_TOO_MANY_DIGITS = "22003.S.2";
0656: String NUMERIC_OVERFLOW = "22003.S.3";
0657: String CLIENT_LENGTH_OUTSIDE_RANGE_FOR_DATATYPE = "22003.S.4";
0658:
0659: String LANG_DATA_TYPE_GET_MISMATCH = "22005"; // same 22005 error
0660: String UNSUPPORTED_ENCODING = "22005.S.1";
0661: String CHARACTER_CONVERTER_NOT_AVAILABLE = "22005.S.2";
0662: String CANT_CONVERT_UNICODE_TO_EBCDIC = "22005.S.3";
0663: String NET_UNRECOGNIZED_JDBC_TYPE = "22005.S.4";
0664: String NET_INVALID_JDBC_TYPE_FOR_PARAM = "22005.S.5";
0665: String UNRECOGNIZED_JAVA_SQL_TYPE = "22005.S.6";
0666:
0667: String LANG_DATE_RANGE_EXCEPTION = "22007.S.180";
0668: String LANG_DATE_SYNTAX_EXCEPTION = "22007.S.181";
0669: String LANG_INVALID_FUNCTION_ARGUMENT = "22008.S";
0670: String LANG_SUBSTR_START_OR_LEN_OUT_OF_RANGE = "22011";
0671: String LANG_DIVIDE_BY_ZERO = "22012";
0672: String LANG_SQRT_OF_NEG_NUMBER = "22013";
0673: String LANG_INVALID_PARAMETER_FOR_SEARCH_POSITION = "22014";
0674: String LANG_INVALID_TYPE_FOR_LOCATE_FUNCTION = "22015";
0675: String LOSS_OF_PRECISION_EXCEPTION = "22015.S.1";
0676: String LANG_FORMAT_EXCEPTION = "22018";
0677: String LANG_INVALID_ESCAPE_CHARACTER = "22019";
0678: String LANG_INVALID_ESCAPE_SEQUENCE = "22025";
0679: String LANG_INVALID_TRIM_SET = "22027";
0680: String LANG_STRING_TOO_LONG = "22028";
0681: String LANG_ESCAPE_IS_NULL = "22501";
0682:
0683: /*
0684: ** Integrity violations.
0685: */
0686: String INTEGRITY_VIOLATION_PREFIX = "23";
0687:
0688: String LANG_NULL_INTO_NON_NULL = "23502";
0689: String LANG_DUPLICATE_KEY_CONSTRAINT = "23505";
0690: String LANG_FK_VIOLATION = "23503";
0691: String LANG_CHECK_CONSTRAINT_VIOLATED = "23513";
0692:
0693: // From SQL/XML[2006] spec; there are others, but
0694: // these are the ones we actually use with our
0695: // current XML support.
0696: String LANG_XML_QUERY_ERROR = "10000";
0697: String LANG_NOT_AN_XML_DOCUMENT = "2200L";
0698: String LANG_INVALID_XML_DOCUMENT = "2200M";
0699: String LANG_INVALID_XML_CONTEXT_ITEM = "2200V";
0700: String LANG_XQUERY_SERIALIZATION_ERROR = "2200W";
0701:
0702: String LANG_INVALID_TRANSACTION_STATE = "25000";
0703: String CANNOT_CLOSE_ACTIVE_CONNECTION = "25001";
0704:
0705: String LANG_UNEXPECTED_USER_EXCEPTION = "38000";
0706: String EXTERNAL_ROUTINE_NO_SQL = "38001";
0707: String EXTERNAL_ROUTINE_NO_MODIFIES_SQL = "38002";
0708: String EXTERNAL_ROUTINE_NO_READS_SQL = "38004";
0709:
0710: String LANG_NULL_TO_PRIMITIVE_PARAMETER = "39004";
0711: String LANG_SYNTAX_OR_ACCESS_VIOLATION = "42000";
0712: String LANG_DB2_NOT_NULL_COLUMN_INVALID_DEFAULT = "42601";
0713: String LANG_DB2_INVALID_HEXADECIMAL_CONSTANT = "42606";
0714: String LANG_DB2_STRING_CONSTANT_TOO_LONG = "54002";
0715: String LANG_DB2_NUMBER_OF_ARGS_INVALID = "42605";
0716: String LANG_DB2_COALESCE_FUNCTION_ALL_PARAMS = "42610";
0717: String LANG_DB2_LENGTH_PRECISION_SCALE_VIOLATION = "42611";
0718: String LANG_DB2_MULTIPLE_ELEMENTS = "42613";
0719: String LANG_DB2_INVALID_CHECK_CONSTRAINT = "42621";
0720: String LANG_DB2_DUPLICATE_NAMES = "42734";
0721: String LANG_DB2_INVALID_COLS_SPECIFIED = "42802";
0722: String LANG_DB2_INVALID_SELECT_COL_FOR_HAVING = "42803";
0723: String LANG_DB2_ADD_UNIQUE_OR_PRIMARY_KEY_ON_NULL_COLS = "42831";
0724: String LANG_DB2_REPLACEMENT_ERROR = "42815.S.713";
0725: String LANG_DB2_COALESCE_DATATYPE_MISMATCH = "42815.S.171";
0726: String LANG_DB2_TOO_LONG_FLOATING_POINT_LITERAL = "42820";
0727: String LANG_DB2_LIKE_SYNTAX_ERROR = "42824";
0728: String LANG_INVALID_FK_COL_FOR_SETNULL = "42834";
0729: String LANG_INVALID_ALTER_TABLE_ATTRIBUTES = "42837";
0730: String LANG_DB2_FUNCTION_INCOMPATIBLE = "42884";
0731:
0732: String LANG_DB2_PARAMETER_NEEDS_MARKER = "42886";
0733: String LANG_DB2_INVALID_DEFAULT_VALUE = "42894";
0734:
0735: String LANG_NO_AGGREGATES_IN_WHERE_CLAUSE = "42903";
0736: String LANG_DB2_VIEW_REQUIRES_COLUMN_NAMES = "42908";
0737: String LANG_DELETE_RULE_VIOLATION = "42915";
0738: String LANG_SYNONYM_CIRCULAR = "42916";
0739: String LANG_DB2_ON_CLAUSE_INVALID = "42972";
0740: String LANG_SYNTAX_ERROR = "42X01";
0741: String LANG_LEXICAL_ERROR = "42X02";
0742: String LANG_AMBIGUOUS_COLUMN_NAME = "42X03";
0743: String LANG_COLUMN_NOT_FOUND = "42X04";
0744: String LANG_TABLE_NOT_FOUND = "42X05";
0745: String LANG_TOO_MANY_RESULT_COLUMNS = "42X06";
0746: String LANG_NULL_IN_VALUES_CLAUSE = "42X07";
0747: String LANG_DOES_NOT_IMPLEMENT = "42X08";
0748: String LANG_FROM_LIST_DUPLICATE_TABLE_NAME = "42X09";
0749: String LANG_EXPOSED_NAME_NOT_FOUND = "42X10";
0750: String LANG_IDENTIFIER_TOO_LONG = "42622";
0751: String LANG_DUPLICATE_COLUMN_NAME_CREATE = "42X12";
0752: String LANG_TOO_MANY_COLUMNS_IN_TABLE_OR_VIEW = "54011";
0753: String LANG_TOO_MANY_INDEXES_ON_TABLE = "42Z9F";
0754: String LANG_DUPLICATE_COLUMN_NAME_INSERT = "42X13";
0755: String LANG_COLUMN_NOT_FOUND_IN_TABLE = "42X14";
0756: String LANG_ILLEGAL_COLUMN_REFERENCE = "42X15";
0757: String LANG_DUPLICATE_COLUMN_NAME_UPDATE = "42X16";
0758: String LANG_INVALID_JOIN_ORDER_SPEC = "42X17";
0759: String LANG_NOT_COMPARABLE = "42818";
0760: String LANG_NON_BOOLEAN_WHERE_CLAUSE = "42X19";
0761: String LANG_CURSOR_NOT_UPDATABLE = "42X23";
0762: // String LANG_UNARY_MINUS_BAD_TYPE = "42X24";
0763: String LANG_UNARY_FUNCTION_BAD_TYPE = "42X25";
0764: String LANG_TYPE_DOESNT_EXIST = "42X26";
0765: String LANG_CURSOR_DELETE_MISMATCH = "42X28";
0766: String LANG_CURSOR_UPDATE_MISMATCH = "42X29";
0767: String LANG_CURSOR_NOT_FOUND = "42X30";
0768: String LANG_COLUMN_NOT_UPDATABLE_IN_CURSOR = "42X31";
0769: String LANG_CORRELATION_NAME_FOR_UPDATABLE_COLUMN_DISALLOWED_IN_CURSOR = "42X42";
0770: String LANG_DERIVED_COLUMN_LIST_MISMATCH = "42X32";
0771: String LANG_DUPLICATE_COLUMN_NAME_DERIVED = "42X33";
0772: String LANG_PARAM_IN_SELECT_LIST = "42X34";
0773: String LANG_BINARY_OPERANDS_BOTH_PARMS = "42X35";
0774: String LANG_UNARY_OPERAND_PARM = "42X36";
0775: String LANG_UNARY_ARITHMETIC_BAD_TYPE = "42X37";
0776: String LANG_CANT_SELECT_STAR_SUBQUERY = "42X38";
0777: String LANG_NON_SINGLE_COLUMN_SUBQUERY = "42X39";
0778: String LANG_UNARY_LOGICAL_NON_BOOLEAN = "42X40";
0779: String LANG_INVALID_FROM_LIST_PROPERTY = "42X41";
0780: String LANG_NOT_STORABLE = "42821";
0781: String LANG_NULL_RESULT_SET_META_DATA = "42X43";
0782: String LANG_INVALID_COLUMN_LENGTH = "42X44";
0783: String LANG_INVALID_FUNCTION_ARG_TYPE = "42X45";
0784: String LANG_AMBIGUOUS_FUNCTION_NAME = "42X46";
0785: String LANG_AMBIGUOUS_PROCEDURE_NAME = "42X47";
0786: String LANG_INVALID_PRECISION = "42X48";
0787: String LANG_INVALID_INTEGER_LITERAL = "42X49";
0788: String LANG_NO_METHOD_FOUND = "42X50";
0789: String LANG_TYPE_DOESNT_EXIST2 = "42X51";
0790: String LANG_PRIMITIVE_RECEIVER = "42X52";
0791: String LANG_LIKE_BAD_TYPE = "42X53";
0792: String LANG_PARAMETER_RECEIVER = "42X54";
0793: String LANG_TABLE_NAME_MISMATCH = "42X55";
0794: String LANG_VIEW_DEFINITION_R_C_L_MISMATCH = "42X56";
0795: String LANG_INVALID_V_T_I_COLUMN_COUNT = "42X57";
0796: String LANG_UNION_UNMATCHED_COLUMNS = "42X58";
0797: String LANG_ROW_VALUE_CONSTRUCTOR_UNMATCHED_COLUMNS = "42X59";
0798: String LANG_INVALID_INSERT_MODE = "42X60";
0799: String LANG_NOT_UNION_COMPATIBLE = "42X61";
0800: String LANG_NO_USER_DDL_IN_SYSTEM_SCHEMA = "42X62";
0801: String LANG_NO_ROWS_FROM_USING = "42X63";
0802: String LANG_INVALID_STATISTICS_SPEC = "42X64";
0803: String LANG_INDEX_NOT_FOUND = "42X65";
0804: String LANG_DUPLICATE_COLUMN_NAME_CREATE_INDEX = "42X66";
0805: //42X67
0806: String LANG_NO_FIELD_FOUND = "42X68";
0807: String LANG_PRIMITIVE_REFERENCING_EXPRESSION = "42X69";
0808: String LANG_NO_STATIC_FIELD_FOUND = "42X72";
0809: String LANG_AMBIGUOUS_METHOD_INVOCATION = "42X73";
0810: String LANG_INVALID_CALL_STATEMENT = "42X74";
0811: String LANG_NO_CONSTRUCTOR_FOUND = "42X75";
0812: String LANG_ADDING_PRIMARY_KEY_ON_EXPLICIT_NULLABLE_COLUMN = "42X76";
0813: String LANG_COLUMN_OUT_OF_RANGE = "42X77";
0814: String LANG_ORDER_BY_COLUMN_NOT_FOUND = "42X78";
0815: String LANG_DUPLICATE_COLUMN_FOR_ORDER_BY = "42X79";
0816: String LANG_QUALIFIED_COLUMN_NAME_NOT_ALLOWED = "42877";
0817: String LANG_EMPTY_VALUES_CLAUSE = "42X80";
0818: String LANG_USING_CARDINALITY_VIOLATION = "42X82";
0819: String LANG_ADDING_COLUMN_WITH_NULL_AND_NOT_NULL_CONSTRAINT = "42X83";
0820: String LANG_CANT_DROP_BACKING_INDEX = "42X84";
0821: String LANG_CONSTRAINT_SCHEMA_MISMATCH = "42X85";
0822: String LANG_DROP_NON_EXISTENT_CONSTRAINT = "42X86";
0823: String LANG_ALL_RESULT_EXPRESSIONS_PARAMS = "42X87";
0824: String LANG_CONDITIONAL_NON_BOOLEAN = "42X88";
0825: String LANG_NOT_TYPE_COMPATIBLE = "42X89";
0826: String LANG_TOO_MANY_PRIMARY_KEY_CONSTRAINTS = "42X90";
0827: String LANG_DUPLICATE_CONSTRAINT_NAME_CREATE = "42X91";
0828: String LANG_DUPLICATE_CONSTRAINT_COLUMN_NAME = "42X92";
0829: String LANG_INVALID_CREATE_CONSTRAINT_COLUMN_LIST = "42X93";
0830: String LANG_OBJECT_NOT_FOUND = "42X94";
0831: String LANG_DB_CLASS_PATH_HAS_MISSING_JAR = "42X96";
0832: String LANG_NO_PARAMS_IN_VIEWS = "42X98";
0833: String LANG_INVALID_USER_AGGREGATE_DEFINITION2 = "42Y00";
0834: String LANG_INVALID_CHECK_CONSTRAINT = "42Y01";
0835: // String LANG_NO_ALTER_TABLE_COMPRESS_ON_TARGET_TABLE = "42Y02";
0836: String LANG_NO_SUCH_METHOD_ALIAS = "42Y03";
0837: String LANG_INVALID_FULL_STATIC_METHOD_NAME = "42Y04";
0838: String LANG_NO_SUCH_FOREIGN_KEY = "42Y05";
0839: //String LANG_METHOD_ALIAS_NOT_FOUND = "42Y06";
0840: String LANG_SCHEMA_DOES_NOT_EXIST = "42Y07";
0841: String LANG_NO_FK_ON_SYSTEM_SCHEMA = "42Y08";
0842: String LANG_VOID_METHOD_CALL = "42Y09";
0843: String LANG_TABLE_CONSTRUCTOR_ALL_PARAM_COLUMN = "42Y10";
0844: String LANG_MISSING_JOIN_SPECIFICATION = "42Y11";
0845: String LANG_NON_BOOLEAN_JOIN_CLAUSE = "42Y12";
0846: String LANG_DUPLICATE_COLUMN_NAME_CREATE_VIEW = "42Y13";
0847: // String LANG_DROP_TABLE_ON_NON_TABLE = "42Y15"; -- replaced by 42Y62
0848: String LANG_NO_METHOD_MATCHING_ALIAS = "42Y16";
0849: // String LANG_DROP_SYSTEM_TABLE_ATTEMPTED = "42Y17"; -- replaced by 42X62
0850: String LANG_INVALID_CAST = "42846";
0851: // String LANG_AMBIGUOUS_GROUPING_COLUMN = "42Y19"; -- unused post 883.
0852: // String LANG_UNMATCHED_GROUPING_COLUMN = // "42Y20"; -- not used
0853: String LANG_USER_AGGREGATE_BAD_TYPE = "42Y22";
0854: String LANG_BAD_J_D_B_C_TYPE_INFO = "42Y23";
0855: String LANG_VIEW_NOT_UPDATEABLE = "42Y24";
0856: String LANG_UPDATE_SYSTEM_TABLE_ATTEMPTED = "42Y25";
0857: String LANG_AGGREGATE_IN_GROUPBY_LIST = "42Y26";
0858: String LANG_NO_PARAMS_IN_TRIGGER_ACTION = "42Y27";
0859: // String LANG_NO_TRIGGER_ON_SYSTEM_TABLE = "42Y28"; -- replaced by 42X62
0860: String LANG_INVALID_NON_GROUPED_SELECT_LIST = "42Y29";
0861: String LANG_INVALID_GROUPED_SELECT_LIST = "42Y30";
0862:
0863: String LANG_TOO_MANY_ELEMENTS = "54004";
0864: String LANG_BAD_AGGREGATOR_CLASS2 = "42Y32";
0865: String LANG_USER_AGGREGATE_CONTAINS_AGGREGATE = "42Y33";
0866: String LANG_AMBIGUOUS_COLUMN_NAME_IN_TABLE = "42Y34";
0867: String LANG_INVALID_COL_REF_NON_GROUPED_SELECT_LIST = "42Y35";
0868: String LANG_INVALID_COL_REF_GROUPED_SELECT_LIST = "42Y36";
0869: String LANG_TYPE_DOESNT_EXIST3 = "42Y37";
0870: String LANG_INVALID_BULK_INSERT_REPLACE = "42Y38";
0871: String LANG_UNRELIABLE_QUERY_FRAGMENT = "42Y39";
0872: String LANG_DUPLICATE_COLUMN_IN_TRIGGER_UPDATE = "42Y40";
0873: String LANG_TRIGGER_SPS_CANNOT_BE_EXECED = "42Y41";
0874: String LANG_INVALID_DECIMAL_SCALE = "42Y42";
0875: String LANG_INVALID_DECIMAL_PRECISION_SCALE = "42Y43";
0876: String LANG_INVALID_FROM_TABLE_PROPERTY = "42Y44";
0877: String LANG_CANNOT_BIND_TRIGGER_V_T_I = "42Y45";
0878: String LANG_INVALID_FORCED_INDEX1 = "42Y46";
0879: // String LANG_INVALID_FORCED_INDEX2 = "42Y47";
0880: String LANG_INVALID_FORCED_INDEX2 = "42Y48";
0881: String LANG_DUPLICATE_PROPERTY = "42Y49";
0882: String LANG_BOTH_FORCE_INDEX_AND_CONSTRAINT_SPECIFIED = "42Y50";
0883: // String LANG_INVALID_FORCED_INDEX4 = "42Y51";
0884: String LANG_OBJECT_DOES_NOT_EXIST = "42Y55";
0885: String LANG_INVALID_JOIN_STRATEGY = "42Y56";
0886: String LANG_INVALID_NUMBER_FORMAT_FOR_OVERRIDE = "42Y58";
0887: String LANG_INVALID_HASH_INITIAL_CAPACITY = "42Y59";
0888: String LANG_INVALID_HASH_LOAD_FACTOR = "42Y60";
0889: String LANG_INVALID_HASH_MAX_CAPACITY = "42Y61";
0890: String LANG_INVALID_OPERATION_ON_VIEW = "42Y62";
0891: String LANG_HASH_NO_EQUIJOIN_FOUND = "42Y63";
0892: String LANG_INVALID_BULK_FETCH_VALUE = "42Y64";
0893: String LANG_INVALID_BULK_FETCH_WITH_JOIN_TYPE = "42Y65";
0894: String LANG_INVALID_BULK_FETCH_UPDATEABLE = "42Y66";
0895: String LANG_CANNOT_DROP_SYSTEM_SCHEMAS = "42Y67";
0896: String LANG_NO_BEST_PLAN_FOUND = "42Y69";
0897: String LANG_ILLEGAL_FORCED_JOIN_ORDER = "42Y70";
0898: String LANG_CANNOT_DROP_SYSTEM_ALIASES = "42Y71";
0899: String LANG_CANNOT_DROP_TRIGGER_S_P_S = "42Y82";
0900: String LANG_USER_AGGREGATE_BAD_TYPE_NULL = "42Y83";
0901: String LANG_INVALID_DEFAULT_DEFINITION = "42Y84";
0902: String LANG_INVALID_USE_OF_DEFAULT = "42Y85";
0903: String LANG_STMT_NOT_UPDATABLE = "42Y90";
0904: String LANG_NO_SPS_USING_IN_TRIGGER = "42Y91";
0905: String LANG_TRIGGER_BAD_REF_MISMATCH = "42Y92";
0906: String LANG_TRIGGER_BAD_REF_CLAUSE_DUPS = "42Y93";
0907: String LANG_BINARY_LOGICAL_NON_BOOLEAN = "42Y94";
0908: String LANG_BINARY_OPERATOR_NOT_SUPPORTED = "42Y95";
0909: String LANG_UNKNOWN = "42Y96.U";
0910: String LANG_INVALID_ESCAPE = "42Y97";
0911: String LANG_JAVACC_SYNTAX = "42Y98.U";
0912: String LANG_JAVACC_LEXICAL_ERROR = "42Y99.U";
0913: String LANG_JAVA_METHOD_CALL_OR_FIELD_REF = "42Z00.U";
0914: String LANG_UNTYPED = "42Z01.U";
0915: // TEMPORARY COMPILATION RESTRICTIONS
0916: String LANG_USER_AGGREGATE_MULTIPLE_DISTINCTS = "42Z02";
0917: String LANG_NO_AGGREGATES_IN_ON_CLAUSE = "42Z07";
0918: String LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER = "42Z08";
0919:
0920: // MORE GENERIC LANGUAGE STUFF
0921: String LANG_COLUMN_DEFAULT = "42Z09.U";
0922: String LANG_STREAM = "42Z11.U";
0923:
0924: // String LANG_UPDATABLE_VTI_BAD_GETMETADATA = "42Z14";
0925:
0926: // for alter table modify column ...
0927: String LANG_MODIFY_COLUMN_CHANGE_TYPE = "42Z15";
0928: String LANG_MODIFY_COLUMN_INVALID_TYPE = "42Z16";
0929: String LANG_MODIFY_COLUMN_INVALID_LENGTH = "42Z17";
0930: String LANG_MODIFY_COLUMN_FKEY_CONSTRAINT = "42Z18";
0931: String LANG_MODIFY_COLUMN_REFERENCED = "42Z19";
0932: String LANG_MODIFY_COLUMN_EXISTING_CONSTRAINT = "42Z20";
0933:
0934: String LANG_AI_INVALID_INCREMENT = "42Z21";
0935: String LANG_AI_INVALID_TYPE = "42Z22";
0936: String LANG_AI_CANNOT_MODIFY_AI = "42Z23";
0937: String LANG_AI_OVERFLOW = "42Z24";
0938: String LANG_AI_COUNTER_ERROR = "42Z25";
0939: String LANG_AI_CANNOT_NULL_AI = "42Z26";
0940: String LANG_AI_CANNOT_ADD_AI_TO_NULLABLE = "42Z27";
0941: // String LANG_BUILT_IN_ALIAS_NAME = "42Z28";
0942: // RUNTIMESTATISTICS
0943: String LANG_TIME_SPENT_THIS = "42Z30.U";
0944: String LANG_TIME_SPENT_THIS_AND_BELOW = "42Z31.U";
0945: String LANG_TOTAL_TIME_BREAKDOWN = "42Z32.U";
0946: String LANG_CONSTRUCTOR_TIME = "42Z33.U";
0947: String LANG_OPEN_TIME = "42Z34.U";
0948: String LANG_NEXT_TIME = "42Z35.U";
0949: String LANG_CLOSE_TIME = "42Z36.U";
0950: String LANG_NONE = "42Z37.U";
0951: String LANG_POSITION_NOT_AVAIL = "42Z38.U";
0952: String LANG_UNEXPECTED_EXC_GETTING_POSITIONER = "42Z39.U";
0953: String LANG_POSITIONER = "42Z40.U";
0954: String LANG_ORDERED_NULL_SEMANTICS = "42Z41.U";
0955: String LANG_COLUMN_ID = "42Z42.U";
0956: String LANG_OPERATOR = "42Z43.U";
0957: String LANG_ORDERED_NULLS = "42Z44.U";
0958: String LANG_UNKNOWN_RETURN_VALUE = "42Z45.U";
0959: String LANG_NEGATE_COMPARISON_RESULT = "42Z46.U";
0960: String LANG_GQPT_NOT_SUPPORTED = "42Z47.U";
0961: String LANG_COLUMN_ID_ARRAY = "42Z48.U";
0962:
0963: String LANG_GRANT_REVOKE_WITH_LEGACY_ACCESS = "42Z60";
0964:
0965: // 42Z70 - 42Z7Z: For Derby-specific XML compilation errors
0966: // (not defined by SQL/XML standard).
0967: String LANG_ATTEMPT_TO_BIND_XML = "42Z70";
0968: String LANG_ATTEMPT_TO_SELECT_XML = "42Z71";
0969: String LANG_XML_KEYWORD_MISSING = "42Z72";
0970: String LANG_INVALID_XMLSERIALIZE_TYPE = "42Z73";
0971: String LANG_UNSUPPORTED_XML_FEATURE = "42Z74";
0972: String LANG_INVALID_XML_QUERY_EXPRESSION = "42Z75";
0973: String LANG_MULTIPLE_XML_CONTEXT_ITEMS = "42Z76";
0974: String LANG_INVALID_CONTEXT_ITEM_TYPE = "42Z77";
0975: String LANG_XMLPARSE_UNKNOWN_PARAM_TYPE = "42Z79";
0976:
0977: String LANG_SERIALIZABLE = "42Z80.U";
0978: String LANG_READ_COMMITTED = "42Z81.U";
0979: String LANG_EXCLUSIVE = "42Z82.U";
0980: String LANG_INSTANTANEOUS_SHARE = "42Z83.U";
0981: String LANG_SHARE = "42Z84.U";
0982: String LANG_TABLE = "42Z85.U";
0983: String LANG_ROW = "42Z86.U";
0984: String LANG_SHARE_TABLE = "42Z87.U";
0985: String LANG_SHARE_ROW = "42Z88.U";
0986:
0987: // MORE GENERIC LANGUAGE STUFF
0988: // String LANG_UPDATABLE_VTI_BAD_GETRESULTSETCONCURRENCY = "42Z89";
0989: String LANG_UPDATABLE_VTI_NON_UPDATABLE_RS = "42Z90";
0990: String LANG_SUBQUERY = "42Z91";
0991: String LANG_REPEATABLE_READ = "42Z92";
0992: String LANG_MULTIPLE_CONSTRAINTS_WITH_SAME_COLUMNS = "42Z93";
0993: // String LANG_ALTER_SYSTEM_TABLE_ATTEMPTED = "42Z94"; -- replaced by 42X62
0994: // String LANG_ALTER_TABLE_ON_NON_TABLE = "42Z95"; -- replaced by 42Y62
0995: String LANG_RENAME_COLUMN_WILL_BREAK_CHECK_CONSTRAINT = "42Z97";
0996: // beetle 2758. For now just raise an error for literals > 64K
0997: String LANG_INVALID_LITERAL_LENGTH = "42Z99";
0998: String LANG_READ_UNCOMMITTED = "42Z9A";
0999: String LANG_VTI_BLOB_CLOB_UNSUPPORTED = "42Z9B";
1000: String LANG_UNSUPPORTED_TRIGGER_STMT = "42Z9D";
1001: String LANG_UNSUPPORTED_TRIGGER_PROC = "42Z9D.S.1";
1002: String LANG_DROP_CONSTRAINT_TYPE = "42Z9E";
1003: String LANG_QUERY_TOO_COMPLEX = "42ZA0";
1004: String LANG_INVALID_SQL_IN_BATCH = "42ZA1";
1005:
1006: //following 3 matches the DB2 sql states
1007: String LANG_DECLARED_GLOBAL_TEMP_TABLE_ONLY_IN_SESSION_SCHEMA = "428EK";
1008: String LANG_NOT_ALLOWED_FOR_DECLARED_GLOBAL_TEMP_TABLE = "42995";
1009: String LANG_LONG_DATA_TYPE_NOT_ALLOWED = "42962";
1010:
1011: String LANG_MULTIPLE_AUTOINCREMENT_COLUMNS = "428C1";
1012: String LANG_ALTER_TABLE_AUTOINCREMENT_COLUMN_NOT_ALLOWED = "42601.S.372";
1013: String LANG_TOO_MANY_INDEX_KEY_COLS = "54008";
1014: String LANG_TRIGGER_RECURSION_EXCEEDED = "54038";
1015: String LANG_TOO_MANY_PARAMETERS_FOR_STORED_PROC = "54023";
1016:
1017: //following 1 does not match the DB2 sql state, it is a Cloudscape specific behavior which is not compatible with DB2
1018: String LANG_OPERATION_NOT_ALLOWED_ON_SESSION_SCHEMA_TABLES = "XCL51.S";
1019:
1020: // org.apache.derby.impl.sql.execute.rts
1021: String RTS_ATTACHED_TO = "43X00.U";
1022: String RTS_BEGIN_SQ_NUMBER = "43X01.U";
1023: String RTS_ANY_RS = "43X02.U";
1024: String RTS_NUM_OPENS = "43X03.U";
1025: String RTS_ROWS_SEEN = "43X04.U";
1026: String RTS_SOURCE_RS = "43X05.U";
1027: String RTS_END_SQ_NUMBER = "43X06.U";
1028: String RTS_OPT_EST_RC = "43X07.U";
1029: String RTS_OPT_EST_COST = "43X08.U";
1030: String RTS_SECONDS = "43X09.U";
1031: String RTS_TOTAL = "43X10.U";
1032: String RTS_NODE = "43X11.U";
1033: String RTS_NOT_IMPL = "43X12.U";
1034: String RTS_DELETE_RS_USING = "43X13.U";
1035: String RTS_TABLE_LOCKING = "43X14.U";
1036: String RTS_ROW_LOCKING = "43X15.U";
1037: String RTS_DEFERRED = "43X16.U";
1038: String RTS_ROWS_DELETED = "43X17.U";
1039: String RTS_INDEXES_UPDATED = "43X18.U";
1040: String RTS_DELETE = "43X19.U";
1041: String RTS_DSARS = "43X20.U";
1042: String RTS_ROWS_INPUT = "43X21.U";
1043: String RTS_DISTINCT_SCALAR_AGG = "43X22.U";
1044: String RTS_DISTINCT_SCAN_RS_USING = "43X23.U";
1045: String RTS_CONSTRAINT = "43X24.U";
1046: String RTS_INDEX = "43X25.U";
1047: String RTS_DISTINCT_SCAN_RS = "43X26.U";
1048: String RTS_LOCKING = "43X27.U";
1049: String RTS_SCAN_INFO = "43X28.U";
1050: String RTS_DISTINCT_COL = "43X29.U";
1051: String RTS_DISTINCT_COLS = "43X30.U";
1052: String RTS_HASH_TABLE_SIZE = "43X31.U";
1053: String RTS_ROWS_FILTERED = "43X32.U";
1054: String RTS_NEXT_TIME = "43X33.U";
1055: String RTS_START_POSITION = "43X34.U";
1056: String RTS_STOP_POSITION = "43X35.U";
1057: String RTS_SCAN_QUALS = "43X36.U";
1058: String RTS_NEXT_QUALS = "43X37.U";
1059: String RTS_ON_USING = "43X38.U";
1060: String RTS_DISTINCT_SCAN = "43X39.U";
1061: String RTS_SORT_INFO = "43X40.U";
1062: String RTS_GROUPED_AGG_RS = "43X41.U";
1063: String RTS_HAS_DISTINCT_AGG = "43X42.U";
1064: String RTS_IN_SORTED_ORDER = "43X43.U";
1065: String RTS_GROUPED_AGG = "43X44.U";
1066: String RTS_HASH_EXISTS_JOIN = "43X45.U";
1067: String RTS_HASH_EXISTS_JOIN_RS = "43X46.U";
1068: String RTS_HASH_JOIN = "43X47.U";
1069: String RTS_HASH_JOIN_RS = "43X48.U";
1070: String RTS_HASH_LEFT_OJ = "43X49.U";
1071: String RTS_HASH_LEFT_OJ_RS = "43X50.U";
1072: String RTS_HASH_SCAN_RS_USING = "43X51.U";
1073: String RTS_HASH_SCAN_RS = "43X52.U";
1074: String RTS_HASH_KEY = "43X53.U";
1075: String RTS_HASH_KEYS = "43X54.U";
1076: String RTS_HASH_SCAN = "43X55.U";
1077: String RTS_ATTACHED_SQS = "43X56.U";
1078: String RTS_HASH_TABLE_RS = "43X57.U";
1079: String RTS_HASH_TABLE = "43X58.U";
1080: String RTS_ALL = "43X59.U";
1081: String RTS_IRTBR_RS = "43X60.U";
1082: String RTS_COLS_ACCESSED_FROM_HEAP = "43X61.U";
1083: String RTS_FOR_TAB_NAME = "43X62.U";
1084: String RTS_IRTBR = "43X63.U";
1085: String RTS_INSERT_MODE_BULK = "43X64.U";
1086: String RTS_INSERT_MODE_NOT_BULK = "43X65.U";
1087: String RTS_INSERT_MODE_NORMAL = "43X66.U";
1088: String RTS_INSERT_USING = "43X67.U";
1089: String RTS_ROWS_INSERTED = "43X68.U";
1090: String RTS_INSERT = "43X69.U";
1091: String RTS_JOIN = "43X70.U";
1092: String RTS_LKIS_RS = "43X71.U";
1093: String RTS_LOCKING_OPTIMIZER = "43X72.U";
1094: String RTS_TABLE_SCAN = "43X73.U";
1095: String RTS_INDEX_SCAN = "43X74.U";
1096: String RTS_ON = "43X75.U";
1097: String RTS_MATERIALIZED_RS = "43X76.U";
1098: String RTS_TEMP_CONGLOM_CREATE_TIME = "43X77.U";
1099: String RTS_TEMP_CONGLOM_FETCH_TIME = "43X78.U";
1100: String RTS_ROWS_SEEN_LEFT = "43X79.U";
1101: String RTS_ROWS_SEEN_RIGHT = "43X80.U";
1102: String RTS_ROWS_RETURNED = "43X81.U";
1103: String RTS_LEFT_RS = "43X82.U";
1104: String RTS_RIGHT_RS = "43X83.U";
1105: String RTS_NESTED_LOOP_EXISTS_JOIN = "43X84.U";
1106: String RTS_NESTED_LOOP_EXISTS_JOIN_RS = "43X85.U";
1107: String RTS_NESTED_LOOP_JOIN = "43X86.U";
1108: String RTS_NESTED_LOOP_JOIN_RS = "43X87.U";
1109: String RTS_EMPTY_RIGHT_ROWS = "43X88.U";
1110: String RTS_NESTED_LOOP_LEFT_OJ = "43X89.U";
1111: String RTS_NESTED_LOOP_LEFT_OJ_RS = "43X90.U";
1112: String RTS_NORMALIZE_RS = "43X91.U";
1113: String RTS_ONCE_RS = "43X92.U";
1114: String RTS_PR_RS = "43X93.U";
1115: String RTS_RESTRICTION = "43X94.U";
1116: String RTS_PROJECTION = "43X95.U";
1117: String RTS_RESTRICTION_TIME = "43X96.U";
1118: String RTS_PROJECTION_TIME = "43X97.U";
1119: String RTS_PR = "43X98.U";
1120: String RTS_ROW_RS = "43X99.U";
1121:
1122: String RTS_SCALAR_AGG_RS = "43Y00.U";
1123: String RTS_INDEX_KEY_OPT = "43Y01.U";
1124: String RTS_SCALAR_AGG = "43Y02.U";
1125: String RTS_SCROLL_INSENSITIVE_RS = "43Y03.U";
1126: String RTS_READS_FROM_HASH = "43Y04.U";
1127: String RTS_WRITES_TO_HASH = "43Y05.U";
1128: String RTS_SORT_RS = "43Y06.U";
1129: String RTS_ELIMINATE_DUPS = "43Y07.U";
1130: String RTS_SORT = "43Y08.U";
1131: String RTS_IS_RS_USING = "43Y09.U";
1132: String RTS_TS_RS_FOR = "43Y10.U";
1133: String RTS_ACTUAL_TABLE = "43Y11.U";
1134: String RTS_FETCH_SIZE = "43Y12.U";
1135: String RTS_QUALS = "43Y13.U";
1136: String RTS_UNION_RS = "43Y14.U";
1137: String RTS_UNION = "43Y15.U";
1138: String RTS_UPDATE_RS_USING = "43Y16.U";
1139: String RTS_ROWS_UPDATED = "43Y17.U";
1140: String RTS_UPDATE = "43Y18.U";
1141: String RTS_VTI_RS = "43Y19.U";
1142: String RTS_VTI = "43Y20.U";
1143: String RTS_MATERIALIZED_SUBQS = "43Y21.U";
1144: String RTS_STATEMENT_NAME = "43Y22.U";
1145: String RTS_STATEMENT_TEXT = "43Y23.U";
1146: String RTS_PARSE_TIME = "43Y24.U";
1147: String RTS_BIND_TIME = "43Y25.U";
1148: String RTS_OPTIMIZE_TIME = "43Y26.U";
1149: String RTS_GENERATE_TIME = "43Y27.U";
1150: String RTS_COMPILE_TIME = "43Y28.U";
1151: String RTS_EXECUTE_TIME = "43Y29.U";
1152: String RTS_BEGIN_COMP_TS = "43Y30.U";
1153: String RTS_END_COMP_TS = "43Y31.U";
1154: String RTS_BEGIN_EXE_TS = "43Y32.U";
1155: String RTS_END_EXE_TS = "43Y33.U";
1156: String RTS_STMT_EXE_PLAN_TXT = "43Y44.U";
1157: String RTS_RUN_TIME = "43Y45.U";
1158: String RTS_INSERT_VTI_RESULT_SET = "43Y46.U";
1159: String RTS_DELETE_VTI_RESULT_SET = "43Y47.U";
1160: String RTS_INSERT_VTI = "43Y49.U";
1161: String RTS_DELETE_VTI = "43Y50.U";
1162: String RTS_DELETE_CASCADE = "43Y51.U";
1163: String RTS_DELETE_CASCADE_RS_USING = "43Y52.U";
1164: String RTS_REFACTION_DEPENDENT = "43Y53.U";
1165: String RTS_BEGIN_DEPENDENT_NUMBER = "43Y54.U";
1166: String RTS_END_DEPENDENT_NUMBER = "43Y55.U";
1167: String RTS_USER_SUPPLIED_OPTIMIZER_OVERRIDES_FOR_TABLE = "43Y56.U";
1168: String RTS_USER_SUPPLIED_OPTIMIZER_OVERRIDES_FOR_JOIN = "43Y57.U";
1169: String RTS_INTERSECT_RS = "43Y58.U";
1170: String RTS_INTERSECT = "43Y59.U";
1171: String RTS_EXCEPT_RS = "43Y60.U";
1172: String RTS_EXCEPT = "43Y61.U";
1173:
1174: // org.apache.derby.catalog.types
1175: String TI_SQL_TYPE_NAME = "44X00.U";
1176: String TI_NEXT_ERROR = "44X05.U";
1177:
1178: // INTERNAL EXCEPTIONS
1179: String LANG_UNABLE_TO_GENERATE = "42Z50";
1180: String LANG_UNAVAILABLE_ACTIVATION_NEED = "42Z53";
1181: String LANG_PARSE_ONLY = "42Z54.U";
1182: String LANG_STOP_AFTER_PARSING = "42Z55.U";
1183: String LANG_STOP_AFTER_BINDING = "42Z56.U";
1184: String LANG_STOP_AFTER_OPTIMIZING = "42Z57.U";
1185: String LANG_STOP_AFTER_GENERATING = "42Z58.U";
1186:
1187: // PARSER EXCEPTIONS
1188: String LANG_UNBINDABLE_REWRITE = "X0A00.S";
1189:
1190: // EXECUTION EXCEPTIONS
1191: String LANG_CANT_LOCK_TABLE = "X0X02.S";
1192: String LANG_TABLE_NOT_FOUND_DURING_EXECUTION = "X0X05.S";
1193: String LANG_CANT_DROP_JAR_ON_DB_CLASS_PATH_DURING_EXECUTION = "X0X07.S";
1194: String LANG_USING_CARDINALITY_VIOLATION_DURING_EXECUTION = "X0X10.S";
1195: String LANG_NO_ROWS_FROM_USING_DURING_EXECUTION = "X0X11.S";
1196: String LANG_FILE_DOES_NOT_EXIST = "X0X13.S";
1197: String LANG_NO_CORRESPONDING_S_Q_L_TYPE = "X0X57.S";
1198: String LANG_CURSOR_ALREADY_EXISTS = "X0X60.S";
1199: String LANG_INDEX_COLUMN_NOT_EQUAL = "X0X61.S";
1200: String LANG_INCONSISTENT_ROW_LOCATION = "X0X62.S";
1201: String LANG_FILE_ERROR = "X0X63.S";
1202: String LANG_COLUMN_NOT_ORDERABLE_DURING_EXECUTION = "X0X67.S";
1203: String LANG_OBJECT_NOT_FOUND_DURING_EXECUTION = "X0X81.S";
1204: String LANG_NON_KEYED_INDEX = "X0X85.S";
1205: String LANG_ZERO_INVALID_FOR_R_S_ABSOLUTE = "X0X86.S";
1206: String LANG_NO_CURRENT_ROW_FOR_RELATIVE = "X0X87.S";
1207: String LANG_CANT_INVALIDATE_OPEN_RESULT_SET = "X0X95.S";
1208: String LANG_CANT_CHANGE_ISOLATION_HOLD_CURSOR = "X0X03.S";
1209: //following three for auto-generated keys feature in JDBC3.0
1210: String LANG_COLUMN_POSITION_NOT_FOUND = "X0X0E.S";
1211: String LANG_COLUMN_NAME_NOT_FOUND = "X0X0F.S";
1212:
1213: String LANG_INDEX_NOT_FOUND_DURING_EXECUTION = "X0X99.S";
1214:
1215: // X0Y01 used to be DUPLICATE_KEY_CONSTRAINT
1216: String LANG_DROP_VIEW_ON_NON_VIEW = "X0Y16.S";
1217: // String LANG_DROP_SYSTEM_TABLE_ATTEMPTED_DURING_EXECUTION = "X0Y17.S";
1218: String LANG_PROVIDER_HAS_DEPENDENT_VIEW = "X0Y23.S";
1219: String LANG_PROVIDER_HAS_DEPENDENT_S_P_S = "X0Y24.S";
1220: String LANG_PROVIDER_HAS_DEPENDENT_OBJECT = "X0Y25.S";
1221: String LANG_INDEX_AND_TABLE_IN_DIFFERENT_SCHEMAS = "X0Y26.S";
1222: String LANG_CREATE_SYSTEM_INDEX_ATTEMPTED = "X0Y28.S";
1223: String LANG_OBJECT_ALREADY_EXISTS_IN_OBJECT = "X0Y32.S";
1224: String LANG_CREATE_INDEX_NO_TABLE = "X0Y38.S";
1225: String LANG_INVALID_FK_NO_PK = "X0Y41.S";
1226: String LANG_INVALID_FK_COL_TYPES_DO_NOT_MATCH = "X0Y42.S";
1227: String LANG_INVALID_FK_DIFFERENT_COL_COUNT = "X0Y43.S";
1228: String LANG_INVALID_FK_NO_REF_KEY = "X0Y44.S";
1229: String LANG_ADD_FK_CONSTRAINT_VIOLATION = "X0Y45.S";
1230: String LANG_INVALID_FK_NO_REF_TAB = "X0Y46.S";
1231: String LANG_SCHEMA_NOT_EMPTY = "X0Y54.S";
1232: String LANG_INDEX_ROW_COUNT_MISMATCH = "X0Y55.S";
1233: String LANG_INVALID_OPERATION_ON_SYSTEM_TABLE = "X0Y56.S";
1234: String LANG_ADDING_NON_NULL_COLUMN_TO_NON_EMPTY_TABLE = "X0Y57.S";
1235: String LANG_ADD_PRIMARY_KEY_FAILED1 = "X0Y58.S";
1236: String LANG_ADD_CHECK_CONSTRAINT_FAILED = "X0Y59.S";
1237: String LANG_NULL_DATA_IN_PRIMARY_KEY = "X0Y63.S";
1238: String LANG_NO_COMMIT_IN_NESTED_CONNECTION = "X0Y66.S";
1239: String LANG_NO_ROLLBACK_IN_NESTED_CONNECTION = "X0Y67.S";
1240: String LANG_OBJECT_ALREADY_EXISTS = "X0Y68.S";
1241: String LANG_NO_DDL_IN_TRIGGER = "X0Y69.S";
1242: String LANG_NO_DML_IN_TRIGGER = "X0Y70.S";
1243: String LANG_NO_XACT_IN_TRIGGER = "X0Y71.S";
1244: String LANG_NO_BULK_INSERT_REPLACE_WITH_TRIGGER_DURING_EXECUTION = "X0Y72.S";
1245: String LANG_NO_SET_TRAN_ISO_IN_GLOBAL_CONNECTION = "X0Y77.S";
1246: String LANG_INVALID_CALL_TO_EXECUTE_QUERY = "X0Y78.S";
1247: String MULTIPLE_RESULTS_ON_EXECUTE_QUERY = "X0Y78.S.1";
1248: String USE_EXECUTE_UPDATE_WITH_NO_RESULTS = "X0Y78.S.2";
1249: String LANG_INVALID_CALL_TO_EXECUTE_UPDATE = "X0Y79.S";
1250: String LANG_NULL_DATA_IN_NON_NULL_COLUMN = "X0Y80.S";
1251: String LANG_IGNORE_MISSING_INDEX_ROW_DURING_DELETE = "X0Y83.S";
1252:
1253: // TEMPORARY EXECUTION RESTRICTIONS
1254:
1255: // Non-SQLSTATE errors
1256: String LANG_DOES_NOT_RETURN_ROWS = "XCL01.S";
1257: String LANG_ACTIVATION_CLOSED = "XCL05.S";
1258: String LANG_CURSOR_CLOSED = "XCL07.S";
1259: String LANG_NO_CURRENT_ROW = "XCL08.S";
1260: String LANG_WRONG_ACTIVATION = "XCL09.S";
1261: String LANG_OBSOLETE_PARAMETERS = "XCL10.S";
1262: String LANG_DATA_TYPE_SET_MISMATCH = "XCL12.S";
1263: String LANG_INVALID_PARAM_POSITION = "XCL13.S";
1264: String LANG_INVALID_COLUMN_POSITION = "XCL14.S";
1265: String LANG_INVALID_COMPARE_TO = "XCL15.S";
1266: String LANG_RESULT_SET_NOT_OPEN = "XCL16.S.0";
1267: String CLIENT_RESULT_SET_NOT_OPEN = "XCL16.S.1";
1268: String LANG_STREAM_RETRIEVED_ALREADY = "XCL18.S";
1269: String LANG_MISSING_ROW = "XCL19.S";
1270: String LANG_CANT_UPGRADE_CATALOGS = "XCL20.S";
1271: String LANG_DDL_IN_BIND = "XCL21.S";
1272: String LANG_NOT_OUT_PARAM = "XCL22.S";
1273: String LANG_INVALID_S_Q_L_TYPE = "XCL23.S";
1274: String LANG_PARAMETER_MUST_BE_OUTPUT = "XCL24.S";
1275: String LANG_INVALID_OUT_PARAM_MAP = "XCL25.S";
1276: String LANG_NOT_OUTPUT_PARAMETER = "XCL26.S";
1277: String LANG_RETURN_OUTPUT_PARAM_CANNOT_BE_SET = "XCL27.S";
1278: String LANG_STREAMING_COLUMN_I_O_EXCEPTION = "XCL30.S";
1279: String LANG_STATEMENT_CLOSED_NO_REASON = "XCL31.S";
1280: String LANG_STATEMENT_NEEDS_RECOMPILE = "XCL32.S";
1281:
1282: //delete rule restriction violation errors
1283: String LANG_CANT_BE_DEPENDENT_ESELF = "XCL33.S";
1284: String LANG_CANT_BE_DEPENDENT_ECYCLE = "XCL34.S";
1285: String LANG_CANT_BE_DEPENDENT_MPATH = "XCL35.S";
1286: String LANG_DELETE_RULE_MUSTBE_ESELF = "XCL36.S";
1287: String LANG_DELETE_RULE_MUSTBE_ECASCADE = "XCL37.S";
1288: String LANG_DELETE_RULE_MUSTBE_MPATH = "XCL38.S";
1289: String LANG_DELETE_RULE_CANT_BE_CASCADE_ESELF = "XCL39.S";
1290: String LANG_DELETE_RULE_CANT_BE_CASCADE_ECYCLE = "XCL40.S";
1291: String LANG_DELETE_RULE_CANT_BE_CASCADE_MPATH = "XCL41.S";
1292:
1293: // referential action types
1294: String LANG_DELETE_RULE_CASCADE = "XCL42.S";
1295: String LANG_DELETE_RULE_SETNULL = "XCL43.S";
1296: String LANG_DELETE_RULE_RESTRICT = "XCL44.S";
1297: String LANG_DELETE_RULE_NOACTION = "XCL45.S";
1298: String LANG_DELETE_RULE_SETDEFAULT = "XCL46.S";
1299:
1300: String LANG_STATEMENT_UPGRADE_REQUIRED = "XCL47.S";
1301:
1302: //truncate table
1303: String LANG_NO_TRUNCATE_ON_FK_REFERENCE_TABLE = "XCL48.S";
1304: String LANG_NO_TRUNCATE_ON_ENABLED_DELETE_TRIGGERS = "XCL49.S";
1305:
1306: // Initial release of DB2 Cloudscape does not support upgrade
1307: String LANG_CANT_UPGRADE_DATABASE = "XCL50.S";
1308:
1309: String LANG_STATEMENT_CANCELLED_OR_TIMED_OUT = "XCL52.S";
1310:
1311: /*
1312: ** Language errors that match DB2
1313: */
1314:
1315: String INVALID_SCHEMA_SYS = "42939";
1316:
1317: /*
1318: SQL standard 0A - feature not supported
1319: */
1320: String UNSUPPORTED_PREFIX = "0A";
1321:
1322: String NOT_IMPLEMENTED = "0A000.S";
1323: String JDBC_METHOD_NOT_IMPLEMENTED = "0A000.S.1";
1324: String JDBC_METHOD_NOT_SUPPORTED_BY_SERVER = "0A000.S.2";
1325: String UNSUPPORTED_HOLDABILITY_PROPERTY = "0A000.S.3";
1326: String CANCEL_NOT_SUPPORTED_BY_SERVER = "0A000.S.4";
1327: String SECMECH_NOT_SUPPORTED = "0A000.S.5";
1328: String DRDA_COMMAND_NOT_IMPLEMENTED = "0A000.C.6";
1329: String DATA_TYPE_NOT_SUPPORTED = "0A000.S.7";
1330:
1331: /*
1332: ** Authorization and Authentication
1333: */
1334: String AUTHORIZATION_PREFIX = "28";
1335:
1336: String AUTH_DATABASE_CONNECTION_REFUSED = "04501.C";
1337: String AUTH_SET_CONNECTION_READ_ONLY_IN_ACTIVE_XACT = "25501";
1338: String AUTH_WRITE_WITH_READ_ONLY_CONNECTION = "25502";
1339: String AUTH_DDL_WITH_READ_ONLY_CONNECTION = "25503";
1340: String AUTH_CANNOT_SET_READ_WRITE = "25505";
1341: String AUTH_INVALID_AUTHORIZATION_PROPERTY = "28501";
1342: String AUTH_INVALID_USER_NAME = "28502.C";
1343: String AUTH_USER_IN_READ_AND_WRITE_LISTS = "28503";
1344: String AUTH_DUPLICATE_USERS = "28504";
1345: String AUTH_INTERNAL_BAD_UUID = "28505";
1346: String AUTH_NO_TABLE_PERMISSION = "28506";
1347: String AUTH_NO_TABLE_PERMISSION_FOR_GRANT = "28507";
1348: String AUTH_NO_COLUMN_PERMISSION = "28508";
1349: String AUTH_NO_COLUMN_PERMISSION_FOR_GRANT = "28509";
1350: String AUTH_NO_EXECUTE_PERMISSION = "2850A";
1351: String AUTH_NO_EXECUTE_PERMISSION_FOR_GRANT = "2850B";
1352: String AUTH_NOT_OWNER = "2850C";
1353: String AUTH_NO_ACCESS_NOT_OWNER = "2850D";
1354: String AUTH_NOT_DATABASE_OWNER = "2850E";
1355: String AUTH_GRANT_REVOKE_NOT_ALLOWED = "2850F";
1356: String AUTH_NO_OBJECT_PERMISSION = "2850G";
1357:
1358: /*
1359: ** Dependency manager
1360: */
1361: String DEP_UNABLE_TO_RESTORE = "XD003.S";
1362: String DEP_UNABLE_TO_STORE = "XD004.S";
1363:
1364: /*
1365: ** Connectivity
1366: */
1367: //following have statement severity.
1368: String NO_CURRENT_ROW = "24000";
1369: // String NULL_TYPE_PARAMETER_MISMATCH = "37000";
1370: String NO_INPUT_PARAMETERS = "07009";
1371: String NEED_TO_REGISTER_PARAM = "07004";
1372: String COLUMN_NOT_FOUND = "S0022";
1373: //String NO_COMMIT_WHEN_AUTO = "XJ007.S";
1374: String NO_SAVEPOINT_ROLLBACK_OR_RELEASE_WHEN_AUTO = "XJ008.S";
1375: String REQUIRES_CALLABLE_STATEMENT = "XJ009.S";
1376: String NO_SAVEPOINT_WHEN_AUTO = "XJ010.S";
1377: String NULL_NAME_FOR_SAVEPOINT = "XJ011.S";
1378: String ALREADY_CLOSED = "XJ012.S";
1379: String NO_ID_FOR_NAMED_SAVEPOINT = "XJ013.S";
1380: String NO_NAME_FOR_UNNAMED_SAVEPOINT = "XJ014.S";
1381: String NOT_FOR_PREPARED_STATEMENT = "XJ016.S";
1382: String NO_SAVEPOINT_IN_TRIGGER = "XJ017.S";
1383: String NULL_COLUMN_NAME = "XJ018.S";
1384: String TYPE_MISMATCH = "XJ020.S";
1385: String UNSUPPORTED_TYPE = "XJ021.S";
1386: String SET_STREAM_FAILURE = "XJ022.S";
1387: String SET_STREAM_INEXACT_LENGTH_DATA = "XJ023.S";
1388: String NEGATIVE_STREAM_LENGTH = "XJ025.S";
1389: String NO_AUTO_COMMIT_ON = "XJ030.S";
1390: String BAD_PROPERTY_VALUE = "XJ042.S";
1391: String BAD_SCALE_VALUE = "XJ044.S";
1392: String UNIMPLEMENTED_ISOLATION_LEVEL = "XJ045.S";
1393: String RESULTSET_RETURN_NOT_ALLOWED = "XJ04B.S";
1394: String OUTPUT_PARAMS_NOT_ALLOWED = "XJ04C.S";
1395: String CANNOT_AUTOCOMMIT_XA = "XJ056.S";
1396: String CANNOT_COMMIT_XA = "XJ057.S";
1397: String CANNOT_ROLLBACK_XA = "XJ058.S";
1398: String CANNOT_CLOSE_ACTIVE_XA_CONNECTION = "XJ059.S";
1399: String CANNOT_HOLD_CURSOR_XA = "XJ05C.S";
1400: String NOT_ON_FORWARD_ONLY_CURSOR = "XJ061.S";
1401: String INVALID_FETCH_SIZE = "XJ062.S";
1402: String INVALID_MAX_ROWS_VALUE = "XJ063.S";
1403: String INVALID_FETCH_DIRECTION = "XJ064.S";
1404: String INVALID_ST_FETCH_SIZE = "XJ065.S";
1405: String INVALID_MAXFIELD_SIZE = "XJ066.S";
1406: String NULL_SQL_TEXT = "XJ067.S";
1407: String MIDDLE_OF_BATCH = "XJ068.S";
1408: String NO_SETXXX_FOR_EXEC_USING = "XJ069.S";
1409: String BLOB_BAD_POSITION = "XJ070.S";
1410: String BLOB_NONPOSITIVE_LENGTH = "XJ071.S";
1411: String BLOB_NULL_PATTERN_OR_SEARCH_STR = "XJ072.S";
1412: String BLOB_ACCESSED_AFTER_COMMIT = "XJ073.S";
1413: String INVALID_QUERYTIMEOUT_VALUE = "XJ074.S";
1414: String BLOB_POSITION_TOO_LARGE = "XJ076.S";
1415: String BLOB_UNABLE_TO_READ_PATTERN = "XJ077.S";
1416: String BLOB_INVALID_OFFSET = "XJ078.S";
1417: String BLOB_LENGTH_TOO_LONG = "XJ079.S";
1418: String LANG_NUM_PARAMS_INCORRECT = "XJ080.S";
1419: String INVALID_API_PARAMETER = "XJ081.S";
1420: String LOB_AS_METHOD_ARGUMENT_OR_RECEIVER = "XJ082.U";
1421: String UPDATABLE_RESULTSET_API_DISALLOWED = "XJ083.U";
1422: String COLUMN_NOT_FROM_BASE_TABLE = "XJ084.U";
1423: String STREAM_EOF = "XJ085.S";
1424: String CURSOR_NOT_POSITIONED_ON_INSERT_ROW = "XJ086.S";
1425:
1426: String WASNULL_INVALID = "XJ088.S";
1427: String INVALID_PARAM_USE_GETINT = "XJ089.S";
1428: String CALENDAR_IS_NULL = "XJ090.S";
1429: String PARAM_NOT_OUT_OR_INOUT = "XJ091.S";
1430: String RETURN_PARAM_MUST_BE_INT = "XJ092.S";
1431: String BLOB_TOO_LARGE_FOR_CLIENT = "XJ093.S";
1432: String OBJECT_ALREADY_CLOSED = "XJ094.S";
1433: String ERROR_PRIVILEGED_ACTION = "XJ095.S";
1434: String MISSING_RESOURCE_BUNDLE = "XJ096.S";
1435: String SAVEPOINT_NOT_CREATED_BY_CONNECTION = "XJ097.S";
1436: String BAD_AUTO_GEN_KEY_VALUE = "XJ098.S";
1437: String READER_UNDER_RUN = "XJ099.S";
1438: String REGOUTPARAM_SCALE_DOESNT_MATCH_SETTER = "XJ100.S";
1439: String TABLE_NAME_CANNOT_BE_NULL = "XJ103.S";
1440: String SHARED_KEY_LENGTH_ERROR = "XJ104.S";
1441: String DES_KEY_HAS_WRONG_LENGTH = "XJ105.S";
1442: String CRYPTO_NO_SUCH_PADDING = "XJ106.S";
1443: String CRYPTO_BAD_PADDING = "XJ107.S";
1444: String CRYPTO_ILLEGAL_BLOCK_SIZE = "XJ108.S";
1445: String PRIMARY_TABLE_NAME_IS_NULL = "XJ110.S";
1446: String FOREIGN_TABLE_NAME_IS_NULL = "XJ111.S";
1447: String SECURITY_EXCEPTION_ENCOUNTERED = "XJ112.S";
1448: String UNABLE_TO_OPEN_FILE = "XJ113.S";
1449: String CURSOR_INVALID_CURSOR_NAME = "XJ114.S";
1450: String UNABLE_TO_OPEN_RESULTSET_WITH_REQUESTED_HOLDABILTY = "XJ115.S";
1451: String TOO_MANY_COMMANDS_FOR_BATCH = "XJ116.S";
1452: String CANNOT_BATCH_QUERIES = "XJ117.S";
1453: String QUERY_BATCH_ON_NON_QUERY_STATEMENT = "XJ118.S";
1454: String CURSOR_INVALID_OPERATION_AT_CURRENT_POSITION = "XJ121.S";
1455: String CURSOR_NO_UPDATE_CALLS_ON_CURRENT_ROW = "XJ122.S";
1456: String CURSOR_NOT_ON_CURRENT_OR_INSERT_ROW = "XJ123.S";
1457: String CURSOR_COLUMN_NOT_UPDATABLE = "XJ124.S";
1458: String CURSOR_MUST_BE_SCROLLABLE = "XJ125.S";
1459: String CURSOR_INVALID_FOR_SENSITIVE_DYNAMIC = "XJ126.S";
1460: //wrapper related
1461: String UNABLE_TO_UNWRAP = "XJ128.S";
1462:
1463: String EXCEEDED_MAX_SECTIONS = "XJ200.S";
1464: String CURSOR_INVALID_NAME = "XJ202.S";
1465: String CURSOR_DUPLICATE_NAME = "XJ203.S";
1466: String UNABLE_TO_OPEN_RS_WITH_REQUESTED_HOLDABILITY = "XJ204.S";
1467: String NO_TOKENS_IN_SQL_TEXT = "XJ206.S";
1468: String CANT_USE_EXEC_QUERY_FOR_UPDATE = "XJ207.S";
1469: String BATCH_NON_ATOMIC_FAILURE = "XJ208.S";
1470: String STORED_PROC_NOT_INSTALLED = "XJ209.S";
1471: String STORED_PROC_LOAD_MODULE_NOT_FOUND = "XJ210.S";
1472: String BATCH_CHAIN_BREAKING_EXCEPTION = "XJ211.S";
1473: String INVALID_ATTRIBUTE_SYNTAX = "XJ212.S";
1474: String TRACELEVEL_FORMAT_INVALID = "XJ213.C";
1475: String IO_ERROR_UPON_LOB_FREE = "XJ214.S";
1476: String LOB_OBJECT_INVALID = "XJ215.S";
1477:
1478: //XN - Network-level messages
1479: String NET_CONNECTION_RESET_NOT_ALLOWED_IN_UNIT_OF_WORK = "XN001.S";
1480: String NET_SECKTKN_NOT_RETURNED = "XN002.U";
1481: String NET_QUERY_PROCESSING_TERMINATED = "XN008.S";
1482: String NET_ERROR_GETTING_BLOB_LENGTH = "XN009.S";
1483: String NET_NULL_PROCEDURE_NAME = "XN010.S";
1484: String NET_PROCEDURE_NAME_LENGTH_OUT_OF_RANGE = "XN011.S";
1485: String NET_WRONG_XA_VERSION = "XN012.S";
1486: String NET_INVALID_SCROLL_ORIENTATION = "XN013.S";
1487: String NET_IOEXCEPTION_ON_READ = "XN014.S";
1488: String NET_INPUTSTREAM_LENGTH_TOO_SMALL = "XN015.S";
1489: String NET_IOEXCEPTION_ON_STREAMLEN_VERIFICATION = "XN016.S";
1490: String NET_PREMATURE_EOS = "XN017.S";
1491: String NET_READER_LENGTH_TOO_SMALL = "XN018.S";
1492: String NET_XARETVAL_ERROR = "XN019.S";
1493:
1494: // XML - Derby-specific XML errors not covered by
1495: // SQL standard.
1496: String LANG_MISSING_XML_CLASSES = "XML00";
1497: String LANG_UNEXPECTED_XML_EXCEPTION = "XML01";
1498:
1499: // Used by server for scrollable updatable insensitive result sets
1500: // to transmit updated state to client. Internal, not seen by user.
1501: // Has no message in messages.properties as it is never printed.
1502: String ROW_UPDATED = "rwupd";
1503: // Used by server to signal delete holes to the client. Internal, not
1504: // seen by user. Has no message in messages.properties as it is never
1505: // printed.
1506: String ROW_DELETED = "02502";
1507:
1508: //following are session severity.
1509: String DATABASE_NOT_FOUND = "XJ004.C";
1510: String MALFORMED_URL = "XJ028.C";
1511: String BOOT_DATABASE_FAILED = "XJ040.C";
1512: String CREATE_DATABASE_FAILED = "XJ041.C";
1513: String CONFLICTING_CREATE_ATTRIBUTES = "XJ049.C";
1514: String CONFLICTING_RESTORE_ATTRIBUTES = "XJ081.C";
1515: String INVALID_ATTRIBUTE = "XJ05B.C";
1516: String NO_SUCH_DATABASE = "X0RQ3.C";
1517:
1518: // Connection exceptions - SQL State class 08
1519:
1520: // 08004 SQL State means the server rejected the connection request
1521: String LOGIN_FAILED = "08004";
1522: String NET_CONNECT_AUTH_FAILED = "08004.C.1";
1523: String NET_DATABASE_NOT_FOUND = "08004.C.2";
1524:
1525: // There can be multiple causes for 08003, which according
1526: // to SQL2003 spec means "connection does not exist"
1527: // We use a suffix to distinguish them. Because of the suffix
1528: // you *must* add a severity code
1529: String NO_CURRENT_CONNECTION = "08003";
1530: String NOGETCONN_ON_CLOSED_POOLED_CONNECTION = "08003.C.1";
1531: String LOB_METHOD_ON_CLOSED_CONNECTION = "08003.C.2";
1532: String PHYSICAL_CONNECTION_ALREADY_CLOSED = "08003.C.3";
1533:
1534: // 08006 means connection exception - connection failure
1535: String CONNECTION_FAILED_ON_RESET = "08006.C.1";
1536:
1537: // 08001 is specifically about the SQL client not being able to establish
1538: // a connection with the server. Should only be used for errors that
1539: // occur upon attempting to open a connection.
1540: // NOTE that if the server *rejects* the connection, that's a different
1541: // SQLState- 08004'
1542: String CONNECT_REQUIRED_PROPERTY_NOT_SET = "08001.C.1";
1543: String CONNECT_UNABLE_TO_CONNECT_TO_SERVER = "08001.C.2";
1544: // Use this version of socket exception occurs when trying to establish
1545: // a connection to the server, as the SQL State 08001 indicates failure
1546: // to establish a connection. If you aren't trying to connect, just
1547: // use SOCKET_EXCEPTION
1548: String CONNECT_SOCKET_EXCEPTION = "08001.C.3";
1549: String CONNECT_UNABLE_TO_OPEN_SOCKET_STREAM = "08001.C.4";
1550: String CONNECT_USERID_LENGTH_OUT_OF_RANGE = "08001.C.5";
1551: String CONNECT_PASSWORD_LENGTH_OUT_OF_RANGE = "08001.C.6";
1552: String CONNECT_USERID_ISNULL = "08001.C.7";
1553: String CONNECT_PASSWORD_ISNULL = "08001.C.8";
1554: String NET_DBNAME_TOO_LONG = "08001.C.9";
1555: String NET_SECTKN_TOO_LONG = "08001.C.10";
1556: String NET_USERID_TOO_LONG = "08001.C.11";
1557: String NET_PASSWORD_TOO_LONG = "08001.C.12";
1558:
1559: // system severity
1560: String SHUTDOWN_DATABASE = "08006.D";
1561:
1562: //the following 2 exceptions are internal and never get seen by the user.
1563: String CLOSE_REQUEST = "close.C.1"; // no message in messages.properties as it is never printed
1564:
1565: //this one had no sqlstate associated with it.
1566: String NORMAL_CLOSE = "XXXXX.C.6";
1567:
1568: //following are system severity.
1569: String CLOUDSCAPE_SYSTEM_SHUTDOWN = "XJ015.M";
1570:
1571: //following are warning severity.
1572: String DATABASE_EXISTS = "01J01";
1573: String NO_SCROLL_SENSITIVE_CURSORS = "01J02";
1574: String UPDATABLE_RESULTSET_FOR_FORWARD_ONLY = "01J03";
1575: String LANG_TYPE_NOT_SERIALIZABLE = "01J04";
1576: String UPGRADE_SPSRECOMPILEFAILED = "01J05";
1577: String QUERY_NOT_QUALIFIED_FOR_UPDATABLE_RESULTSET = "01J06";
1578: String HOLDABLE_RESULT_SET_NOT_AVAILABLE = "01J07";
1579: String INVALID_RESULTSET_TYPE = "01J08";
1580: String INVALID_RESULTSET_CONCURRENCY = "01J09";
1581: String SCROLL_SENSITIVE_NOT_SUPPORTED = "01J10";
1582: String INSENSITIVE_UPDATABLE_NOT_SUPPORTED = "01J11";
1583: String UNABLE_TO_OBTAIN_MESSAGE_TEXT_FROM_SERVER = "01J12";
1584: String NUMBER_OF_ROWS_TOO_LARGE_FOR_INT = "01J13";
1585: String SQL_AUTHORIZATION_WITH_NO_AUTHENTICATION = "01J14";
1586:
1587: String CURSOR_OPERATION_CONFLICT = "01001";
1588:
1589: //following are no applicable severity
1590: String JAVA_EXCEPTION = "XJ001.U";
1591: String NO_UPGRADE = "XJ050.U";
1592:
1593: /*
1594: ** Messages whose SQL states are proscribed by DRDA
1595: */
1596: String DRDA_NO_AUTOCOMMIT_UNDER_XA = "2D521.S.1";
1597: String DRDA_INVALID_XA_STATE_ON_COMMIT_OR_ROLLBACK = "2D521.S.2";
1598: String DRDA_CURSOR_NOT_OPEN = "24501.S";
1599:
1600: // 58009 means connection is terminated. This can be caused by any number
1601: // of reasons, so this SQL State has a lot of instances.
1602: //
1603: // NOTE: if the disconnection is not caused by DRDA-level error, you should
1604: // use SQL State 08006. The way I determined this is if the error occurs
1605: // in the 'client.net' package, use 58009. If it occurs in the 'client.am'
1606: // or any other client package, use 08006. It's really not at all clear
1607: // from the specs when you should use one SQL state or the other, but that's
1608: // the approach I chose (David Van Couvering).
1609: String DRDA_CONNECTION_TERMINATED = "58009.C";
1610: // Use this version of SOCKET_EXCEPTION any time *except* when trying to
1611: // establish a connection, as the SQLState is different. When trying
1612: // to establish a connection, use CONNECT_SOCKET_EXCEPTION.
1613: String SOCKET_EXCEPTION = "58009.C.2";
1614: String COMMUNICATION_ERROR = "58009.C.3";
1615: String CONNECTION_FAILED_ON_DEFERRED_RESET = "58009.C.4";
1616: String NET_INSUFFICIENT_DATA = "58009.C.5";
1617: String NET_LOB_DATA_TOO_LARGE_FOR_JVM = "58009.C.6";
1618: String NET_SQLCDTA_INVALID_FOR_RDBCOLID = "58009.C.7";
1619: String NET_SQLCDTA_INVALID_FOR_PKGID = "58009.C.8";
1620: String NET_PGNAMCSN_INVALID_AT_SQLAM = "58009.C.9";
1621: String NET_VCM_VCS_LENGTHS_INVALID = "58009.C.10";
1622: String NET_ENCODING_NOT_SUPPORTED = "58009.C.11";
1623: String NET_NOT_EXPECTED_CODEPOINT = "58009.C.12";
1624: String NET_DDM_COLLECTION_TOO_SMALL = "58009.C.13";
1625: String NET_COLLECTION_STACK_NOT_EMPTY = "58009.C.14";
1626: String NET_DSS_NOT_ZERO = "58009.C.15";
1627: String NET_DSS_CHAINED_WITH_SAME_ID = "58009.C.16";
1628: String NET_PREMATURE_EOS_DISCONNECT = "58009.C.17";
1629: String NET_INVALID_FDOCA_ID = "58009.C.18";
1630: String NET_SECTKN_NOT_RETURNED = "58009.C.19";
1631: String NET_NVCM_NVCS_BOTH_NON_NULL = "58009.C.20";
1632: String NET_SQLCDTA_INVALID_FOR_RDBNAM = "58009.C.21";
1633:
1634: String DRDA_MGRLVLRM = "58010.C";
1635: String DRDA_DDM_COMMAND_NOT_SUPPORTED = "58014.C";
1636: String DRDA_DDM_OBJECT_NOT_SUPPORTED = "58015.C";
1637: String DRDA_DDM_PARAM_NOT_SUPPORTED = "58016.C";
1638: String DRDA_DDM_PARAMVAL_NOT_SUPPORTED = "58017.C";
1639: String DRDA_NO_AVAIL_CODEPAGE_CONVERSION = "57017.C";
1640:
1641: /*
1642: ** org.apache.derby.database.UserUtility
1643: */
1644: String UU_UNKNOWN_PERMISSION = "XCZ00.S";
1645: String UU_UNKNOWN_USER = "XCZ01.S";
1646: String UU_INVALID_PARAMETER = "XCZ02.S";
1647:
1648: /*
1649: ** SQL Java DDL 46xxx
1650: ** SQLJ jar file support
1651: */
1652: String SQLJ_INVALID_JAR = "46001";
1653: String SQLJ_SIGNATURE_INVALID = "46J01";
1654: String SQLJ_SIGNATURE_PARAMETER_COUNT = "46J02";
1655:
1656: /*
1657: ** Import/Export
1658: */
1659: String CONNECTION_NULL = "XIE01.S";
1660: String DATA_AFTER_STOP_DELIMITER = "XIE03.S";
1661: String DATA_FILE_NOT_FOUND = "XIE04.S";
1662: String DATA_FILE_NULL = "XIE05.S";
1663: String ENTITY_NAME_MISSING = "XIE06.S";
1664: String FIELD_IS_RECORD_SEPERATOR_SUBSET = "XIE07.S";
1665: String INVALID_COLUMN_NAME = "XIE08.S";
1666: String INVALID_COLUMN_NUMBER = "XIE09.S";
1667: String UNSUPPORTED_COLUMN_TYPE = "XIE0B.S";
1668: String RECORD_SEPERATOR_MISSING = "XIE0D.S";
1669: String UNEXPECTED_END_OF_FILE = "XIE0E.S";
1670: String ERROR_WRITING_DATA = "XIE0I.S";
1671: String DELIMITERS_ARE_NOT_MUTUALLY_EXCLUSIVE = "XIE0J.S";
1672: String PERIOD_AS_CHAR_DELIMITER_NOT_ALLOWED = "XIE0K.S";
1673: String TABLE_NOT_FOUND = "XIE0M.S";
1674: }
|