Tim Bunce wrote:
>
> 1. Specify a fairly short list of the specific SQLSTATE values that
> I'd like drivers to support as a minimum.
>
> 2. Provide a simple way for drivers to map some of their private
> err values into the corresponding SQLSTATE values.
> Something like: $drh->{SQLSTATE_map} = $hash_ref_or_code_ref;
> The DBI would then use that to set state() if it was left undef.
I like the idea of std.'ized error codes. However, there isn't much
I can do for DBD::ADO:
Source : Microsoft JET Database Engine
Description : The changes you requested to the table were not successful because
they would create duplicate values in the index, primary key, or relationship. Change
the data in the field or fields that contain duplicate data, remove the index, or
redefine the index to permit duplicate entries and try again.
NativeError : -105121349
Number : -2147467259
SQLState : 3022
Source : Microsoft OLE DB Provider for Oracle
Description : ORA-00001: unique constraint (TST.SYS_C0017282) violated
NativeError : 1
Number : -2147217873
SQLState :
Source : Microsoft OLE DB Provider for Visual FoxPro
Description : Uniqueness of index I is violated.
NativeError : 884
Number : -2147217873
SQLState :
Steffen
