[
http://tracker.firebirdsql.org/browse/CORE-1132?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Zotov reopened CORE-1132:
-------------------------------
Ticket will be closed after 'Resolved' flag will be set.
> Exception context in PSQL exception handlers
> --------------------------------------------
>
> Key: CORE-1132
> URL: http://tracker.firebirdsql.org/browse/CORE-1132
> Project: Firebird Core
> Issue Type: Improvement
> Components: Engine
> Reporter: StudSW
> Fix For: 4.0 Alpha 1
>
>
> The possibility to obtain exception text or it's parts (e.g. unique
> contraint name, FK name, deadlock on what, etc.) increases flexibility of
> PSQL exception handlers.
> It is useful if the procedure returns Error Codes, but no exceptions
> (expesially if proc cals are nested). Or, let's say, no non-fatal (e.g.
> contraint filure can be assumed for some cases) exceptions.
> This gives unified exception handling for all "user" exceptions/
> Also, commonly, to show user-friendly messages some extra queries to DB are
> required. Having handler on server side - it is more easy to obtain this
> information (or create a table for with user-messages for all UNIQUE, FOREIGN
> and so on)
> So, the procedure can catch all self-related errors and exceptions, making
> its interface more exact for callers.
> Also the client may stay uninvolved in the server-side processing.
> Currently, any proccessing in PSQL that may throw non-user exception (e.g.
> constraint violation) must break its work and return exception to client-side
> in order to obtain the needed information about it.
> So on, the name of constraint is not user-friendly (or lets say
> cleint-friendly) and to show a little bit useful information to user it needs
> to request it from server (from rdb$metadata or from applevel metadata).
> So the client must be able to catch and process things which it doesn't need.
> I think this improvement is needed to make stored procedures more autonomic
> without any need of involving client-side in "server-work".
> Best regards, StudSW
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
