General Error - can I do better than that.

Thread view:

aaronfude@gmail.com - 09 May 2006 16:23 GMT

Hi,

I'm working in Windows with an odbc driver for accessing an Access db.
Some INSERT statements throw exception with the "General Error"
message. Can I do better than that and actually find out what went
wrong? Is this the sort of thing that is DB related? For example,
would MySQL give better error message (in addition to other great
features, of course).

Many thanks in advnace!

Aaron Fude.

Reply to this Message

Axel Hallez - 10 May 2006 08:23 GMT

Hi Aaron,

Don't know if you can get a better error description, but on some
occasions I had the same problem when working with MS Access db's.

It seems that you get this 'general error' when you insert a row that
causes a primary key violation.

Hope this helps,
Axel

> Hi,
>
[quoted text clipped - 8 lines]
>
> Aaron Fude.

Reply to this Message

Oliver Wong - 10 May 2006 18:14 GMT

> Hi,
>
[quoted text clipped - 4 lines]
> would MySQL give better error message (in addition to other great
> features, of course).

There's a guide on interpreting exceptions at
http://riters.com/JINX/index.cgi/Suggestions_20for_20Asking_20Questions_20on_20N
ewsgroups#RepeatErrorsExactly
or http://tinyurl.com/kry2x

- Oliver

Reply to this Message

jennifer.grinfeld@gmail.com - 11 May 2006 03:02 GMT

Hi Oliver,

Did you post the right link in your message? Your link points to an
article on how to post messages on usegroups, not on what "General
Error" might mean in the context of java.sql.

Thanks,

Aaron Fude

Reply to this Message

Oliver Wong - 11 May 2006 15:13 GMT

> Hi Oliver,
>
> Did you post the right link in your message? Your link points to an
> article on how to post messages on usegroups, not on what "General
> Error" might mean in the context of java.sql.

Yeah that was the document I meant to link to. Specifically, I wanted
you to look at the section called "Repeat Error Messages Exactly". In that
section, it shows you what a stack trace looks like, and how to interpret
them to pinpoint the location of the bug.

- Oliver

Reply to this Message

General Error - can I do better than that.

Free Magazines