Hi, row number can be hard to implement, because data conversion exception is fired during insert operation, not during csvread operation, is it not? Whole record and name of table (in case of of batch of inserts) should be sufficient and then I can parse file using let say gAWK to find problematic record. Anyway any improvement would be great!
Thank You for it. Stepan On Feb 3, 8:18 pm, Thomas Mueller <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
