Hi

Regarding error handling - it would be nice to have some common set of
error codes (enum?) propagated together with exception - in my app I
don't know which database will be supported until runtime (I link only
core, and modules are loaded dynamically), so I can't link specific DB
modules to get DB-specific exceptions. What I can see right now,
something like:
 - Connection exceptions:
  - server isnt' available
  - authorization error
  - ...
 - Query/commands exceptions:
  - bad command
  - permission error
  - ....

What do you think?

On Thu, Mar 28, 2013 at 10:40 PM, Vadim Zeitlin <[email protected]> wrote:
>  This is the major stuff, yes. I'd also like to implement #51, already
> mentioned in the roadmap, and work on tracing/error reporting. I didn't
> have time to really think about it yet, so I'm not even sure if it's going
> to be one thing or two but, in brief, I'd like to be able to:
>
> (a) Optionally log all SQL statements being sent to the database.
> (b) Be able to show not only the text of failing request but also the
>     values of parameters used for it.
>
> The last one is especially important as currently our application can give
> error messages of the form
>
>         Violation of PRIMARY or UNIQUE KEY constraint "unique_foo_bar"
>         on table "table_name" while executing
>         "insert into table_name(foo, bar) values (:foo, :bar)"
>
> which is singularly unhelpful -- we really need to have the values this
> statement was executed with and not just the placeholders.


-- 
With best wishes,                    Alex Ott
http://alexott.net/
Twitter: alexott_en (English), alexott (Russian)
Skype: alex.ott

------------------------------------------------------------------------------
Own the Future-Intel(R) Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest. Compete 
for recognition, cash, and the chance to get your game on Steam. 
$5K grand prize plus 10 genre and skill prizes. Submit your demo 
by 6/6/13. http://altfarm.mediaplex.com/ad/ck/12124-176961-30367-2
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users

Reply via email to