Hi, I agree, the exception message is not user friendly. In the next release, the exception message will include all values and the row number.
Regards, Thomas On Mon, Feb 2, 2009 at 5:26 PM, t603 <[email protected]> wrote: > > Hello, > > I have a problem when I load data into H2 from CSV using (something > like bulk load) > > insert into myTable select * from csvread (...) > > I get following message: > > SQ:Exception : SQL state: 90021 org.h2.jdbc.JdbcSQLException: Data > conversion error converting PRAGUE [90021-107] ErrorCode: 90021 > > Well, I can imagine, what is wrong, but it is almost unable to detect > affected line of file, which has several millions of lines and more > than 1 GB. Would it be possible to print out e.g. whole line (record), > which should usually contain some identifiers? Maybe to prevent weird > output exclude from print out CLOB, BLOB etc. data types. > > Moreover when I have SQL script with more CSV imports, exception does > not inform me, during which import is exception fired ~ to add name of > table or file. > > Thank You, Stepan > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
