SQL Exception handling

Freature requests from users for ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist, mdaems

ga_301
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 13.09.2012, 14:28

SQL Exception handling

Postby ga_301 » 13.09.2012, 15:04

I am evaluating zeoslib for my project.
Is there a way to identify standard SQL errors (like for instance a Unique Key violation) by any other means than doing a string comparison with a implementation-dependent error string?
How can I retrieve either the native error code (from looking at the DBC code, this does not seem to be included in the Exception object) or (better) a database-independent error code for several kinds of SQL error.
If there would be a method on the connection to retrieve the native error code, I could probably implement the necessary mappings for the database engines in question myself.
Why not include a record in the exception object, which can hold any DB specific error information?

Why do I need this?
I have a application-defined lock table, in which the failure of inserting a record (unique key violation) means that a lock is in place. I need to be distinguish this situation from other possible SQL errors, though.

Regards,
Gunnar

Return to “Feature Requests”

Who is online

Users browsing this forum: No registered users and 1 guest