>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!
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: