>That would be a useful improvement to Derby, could you log a improvement
>entry in Jira? If you want to get involved in Derby this might be an

OK, I will report it on Jira.

If Derby has come this far it,  might as well get
the niceities too!

Jim

On 10/13/05, Daniel John Debrunner <djd@debrunners.com> wrote:
James Pannozzi wrote:

> I started using Derby, so far very very impressive,
> I never used all Java database before.
>
> Here is a question on import CSV file.
>
> I try to import 90,000 line CSV file (see Subject,
> this message) and get some exception, for example if
>
> too many commas in a line, I naturally get Java array
> bounds violation exception.

Hmmmm, that's a bad error for the situation you describe. I would expect
a SQLException indicating badly formed input or something. Could you log
a bug in Jira, with an example?


> BUT-- How do I know on
> which line of the CSV file the error is happening??

That would be a useful improvement to Derby, could you log a improvement
entry in Jira? If you want to get involved in Derby this might be an
easy one to start with, since Java does provide streams/readers that
produce line numbers. Therefore it could be as simple as changing the
stream/reader used by the import code, getting the line number on an
error and adding it to the error message.

Jira details at:

http://db.apache.org/derby/DerbyBugGuidelines.html

Thanks,
Dan.