Hi,
> row number can be hard to implement, because data conversion exception
> is fired during insert operation, not during csvread operation, is it
> not?
Yes, but records are inserted as they are read, so the record number
should match.
> Whole record and name of table (in case of of batch of
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 problemat
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 wrote:
>
> Hello,
>
> I have a problem when I load data into H2 from CSV using (something
> like
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