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 -~----------~----~----~----~------~----~------~--~---
