Recently upgraded Vertica to 6.1.3, found that the error code is not complete in the 6.1.x document, or perhaps no update, the following is a complete JDBC error code list below:
Com/vertica/dsi/core/impl/jdbcmessages.properties # Format is Key = (nativeerrorcode) message.
In all translations of this file, # the (Nativeerrorcode) _must_ is unmodified and _must_ be included.
Batch_not_empty = (10000) BATCH must either to executed with ExecuteBatch () or cleared with Clearbatch (). Column_display_overflow = (10020) Numeric OVERFLOW in column DISPLAY size for size: {0}. commit_autocommit = (10040) Canno
T use commit while Connection be in Auto-commit mode.
connection_closed = (10060) CONNECTION has been CLOSED.
Connection_open = (10080) OPEN CONNECTION is opened again by pool manager. connection_refused = (10100) CONNECTION refused: {0} Conversion_error_input_param = (10120) ERROR converting data, invalid
Type for parameter: {0}. convert_to_err = (10140) Error converting value to {0}.
Convert_utf_support = (10160) Java does not SUPPORT UTF-8 encoding.
Cursor_after_last_row = (10170) Error fetching data, CURSOR positioned after the last ROW. Cursor_before_first_row = (10180) Error fetching data, cursor positioned before-a-row.
Data_truncated_err = (10200) String or binary data right truncation for column {0}.
Driver_not_capable = (10220) DRIVER not capable. Initialize_factory = (10260) Null JDBC object FACTORY has been returned.
A valid JDBC object factory should be returned via Createjdbcobjectfactory ().
Interval_field_overflow = (10280) INTERVAL FIELD OVERFLOW. Invalid_action_on_insert_row = (10300) only updater, getter, and InsertRow methods May is called when positioned on the in
SERT row. Invalid_attribute = (10320) INVALID custom ATTRIBUTE: {0}. invalid_column_index = (10340) INVALID COLUMN INDEX: {0}. inval Id_column_name = (10360) COLUMN NAME not found: {0}. invalid_column_set_type = (10380) INVALID column TYPE for column: {0}
. Invalid_column_type = (10400) INVALID type for Data-column: {0}, type: {1}. invalid_cursor_transition = (10440) INVALID
Cursor Transition:at last row and more rows left. Invalid_fetch_size = (10460) INVALID fetcH size: {0}. Valid Size range: {1} to {2}.
Invalid_field_size = (10480) INVALID FIELD size: {0}. Valid Size range: {1} to {2}.
Invalid_forwardonly_action = (10500) INVALID operation for forward only resultsets. Invalid_get_update_stream = (10520) INVALID action, columns updated as streams may not is fetched while before InsertRow ()
or Updaterow ().
Invalid_interval_data_type = (10540) INVALID INTERVAL DATA TYPE. Invalid_interval_day_format = (10560) INVALID Day INTERVAL FORMAT: "{0}".
The value should is in the format of "DD". Invalid_interval_day_hour_format = (10580) INVALID day to HOUR INTERVAL FORMAT: "{0}".
The value should is in the format of "DD HH". Invalid_interval_day_minute_format = (10600) INVALID day to MINUTE INTERVAL FORMAT: "{0}".
The value should is in the format of "DD hh:mm". Invalid_interval_day_second_format = (10620) INVALID day to SECOND INTERVAL FORMAT: "{0}".
The value should is in the format of "DD HH:MM:SS[.FFFFFFFFF]". Invalid_interval_hour_format = (10640) INvalid hour interval format: ' {0} '.
The value should is in the format of "HH". Invalid_interval_hour_minute_format = (10660) INVALID HOUR to MINUTE INTERVAL FORMAT: "{0}".
The value should is in the format of "hh:mm". Invalid_interval_hour_second_format = (10680) INVALID HOUR to SECOND INTERVAL FORMAT: "{0}".
The value should is in the format of "HH:MM:SS[.FFFFFFFFF]". Invalid_interval_minute_format = (10700) INVALID MINUTE INTERVAL FORMAT: "{0}".
The value should is in the format of "MM". Invalid_interval_minute_second_format = (10720) INVALID MINUTE to SECOND INTERVAL FORMAT: "{0}".
The value should is in the format of "MM:SS[.FFFFFFFFF]". Invalid_interval_month_format = (10740) INVALID MONTH INTERVAL FORMAT: "{0}".
The value should is in the format of "MM". Invalid_interval_second_format = (10760) INVALID SECOND INTERVAL FORMAT: "{0}".
The value should is in the format of "SS[.FFFFFFFFF]". Invalid_interval_year_format = (10780) INVALID year INTERVAL FORMAT: "{0}". The value should bE in the format of ' YYYY '. Invalid_interval_year_month_format = (10800) INVALID year to MONTH INTERVAL FORMAT: "{0}".
The value should is in the format of "yyyy-mm".
Invalid_moreresults_value = (10820) INVALID VALUE passed to Getmoreresults (): "{0}".
Invalid_null_insert = (10840) NULL value can be inserted to column {0}, it is marked non-nullable.
Invalid_null_update = (10860) NULL value can not being set for column {0}, the it is marked non-nullable.
Invalid_number_metadata = (10880) Zero or multiple results created when fetching METADATA.
Invalid_number_params = (10900) Not all parameters have been populated. Invalid_output_index = (10920) No OUTPUT value found for parameter INDEX: {0}. invalid_param_index = (10940) INVALID PARAM Eter index: {0}. invalid_param_input_only = (10960) INVALID parameter type for parameter: {0}. Only INPUT parameters allow
Ed for PreparedStatement. Invalid_param_name = (10980) Parameter NAME not found: {0}. invalid_param_object = (11000) INVALID OBJECT for PARameter: {0}. invalid_param_set_type = (11020) INVALID parameter TYPE for parameter: {0}. invalid_param_type = (11040) INV Alid type for Data-parameter: {0}, type: {1}. invalid_readonly_action = (11060) INVALID operation for Read-only
Ts. Invalid_register_type = (11080) cannot REGISTER input parameter: {0}. invalid_retrieve_type = (11100) parameter {0} is
Input parameter.
Invalid_max_row = (11120) INVALID maximum ROW size: {0}. Valid range: {1} to {2}. Invalid_savepoint = (11140) INVALID savepoint.
The savepoint must be created from the connection it are used on, and within the transaction it was created it. Invalid_scale = (11160) INVALID SCALE: {0}. Minimum value: {1}. invalid_set_type = (11180) cannot SET output parameter: {0
}.
Invalid_stmt_action = (11200) INVALID operation for this statement object.
Invalid_stmt_param = (11220) Parameters cannot is used with normal Statement objects, use preparedstatements instead. Invalid_timeout = (11240) INVALID TIMEOUT: {0}. Valid TImeout range: {1} to {2}.
Invalid_url = (11260) INVALID connection URL.
Invalid_version = (11280) INVALID VERSION returned: {0}. license_expired = (11285) LICENSE file ' {0} ' is expired.
license_file_corrupted = (11286) LICENSE FILE ' {0} ' is corrupt. License_read_error = (11286) ERROR reading LICENSE file "{0}".
Please verify this file exists and permissions have been for it. no_resultset_generated = (11300) A RESULTSET is expected but not generated from query "{0}".
Query not executed. no_rowcount_generated = (11320) A rowcount is expected but not generated from query "{0}".
Query not executed.
not_output_registered = (11340) Not all OUTPUT parameters are registered.
Null_calendar_param = (11360) Invalid data given for CALENDAR.
Null_error = (11380) Null pointer exception.
Null_metadata_columnmap = (11400) Null METADATA column mapping info.
Null_param_metadata = (11420) Error, parameter METADATA not populated. null_sql_string = (11440) Null SQL STRING passed for ExecutiOn. one_result_not_returned = (11460) Exactly one result expected, but {0} results created from query "{1}".
Query not executed. Optional_keys_msg = (11480) OPTIONAL Connection Key (s) param_object_mismatch = (11500) Given type does not match Given obj
ECT: {0}. param_not_nullable = (11520) Parameter {0} is not NULLABLE. Processed_keys_msg = (11540) processed Connection Key (s) register_driver = (11560) A database access error occurred while
Registering the driver.
result_delete_not_supported = (11580) Deletes are not supported for read-write to result sets.
result_insert_not_supported = (11600) inserts are not supported for read-write to result sets.
result_update_not_supported = (11620) Updates are not supported for read-write to result sets. Required_keys_msg = (11640) REQUIRED Connection Key (s) resultset_returned = (11660) Query returns a RESULTSET when a row C
Ount is expected.
Rollback_autocommit = (11680) cannot use ROLLBACK while Connection be in Auto-commit mode. Savepoint_autocommit = (11Cannot set savepoint while Connection be in Auto-commit mode.
savepoint_id_from_named = (11720) cannot retrieve numeric ID from NAMED savepoint.
savepoint_named_from_id = (11740) cannot retrieve name from unnamed savepoint.
Setreadonly_in_transaction = (11760) cannot call setreadonly while Connection be in a TRANSACTION.
transaction_already_started = (11780) TRANSACTION already started. transaction_callbacks_not_allowed = (11800) TRANSACTION callbacks are not allowed during explicit JDBC API TRANSACTION cal
Ls. Unknown_cursor_position = (11820) UNKNOWN CURSOR POSITION: {0}. unknown_data_type = (11840) UNKNOWN DATA TYPE: {0}. unknow N_fetch_direction = (11860) Unknown FETCH DIRECTION: {0}. unknown_holdability = (11880) Unknown ResultSet holdability: {0}
. Unknown_isolation = (11900) UNKNOWN transaction Isolation level: {0}. unknown_metadata_type = (11920) UNKNOWN METADATA Typ E: {0}. unknown_scope = (11940) UNKNOWN SCOPE: {0}. unknown_sqlstate_type = (11960) UNKNOWN SQLSTATE TYPE: {0}.
Unsupported_holdability = (11970) Unsupported holdability: {0}. unsupported_txn_isolation = (11975) UNSUPPORTED transact
Ion Isolation Level: {0}. dbmeta_closed = (11980) DatabaseMetaData object has been.
parammeta_closed = (12000) Parametermetadata object has been CLOSED.
parent_closed = (12020) Parent has been CLOSED, object is invalid.
resultmeta_closed = (12040) ResultSetMetaData object has been CLOSED.
resultset_closed = (12060) RESULTSET object has been CLOSED.
statement_closed = (12080) STATEMENT object has been CLOSED.
stream_closed = (12100) Stream CLOSED, invalid action.
Stream_corrupt_utf = (12120) corrupt UTF byte value.
Stream_empty = (12140) No more data to is read from stream.
Stream_invalid_buffer = (12160) INVALID character Buffer:null.
Stream_invalid_offset = (12180) INVALID OFFSET: {0}. Values can be between 0 and {1}. Stream_read_error = (12200) ERROR reading data from data source: {0} stream_unexpected_end = (12220) unexpected end of Str
Eam reached. WARN_ddl_ignored = (12240) DDL statement in transaction being ignored because Sql_txn_capable is sql_tc_ddl_ignore.
Warn_ddl_force_commit = (12260) DDL statement forced transaction to COMMIT because Sql_txn_capable is sql_tc_ddl_commit.
Warn_fractional_trunc = (12280) fractional truncation of numeric.