hi Thomson
just 1 month back i have started using h2 database its really great
but iam facing problem with csv..As in document it has suggested the only
way to insert bulk database is using csv
but when ever iam using csv...iam getting Io exception
CALL CSVREAD('test.csv');
IO Exception: "IOException reading test.csv"; SQL statement:
CALL CSVREAD('test.csv')
[90028-168]<http://192.168.0.12:8082/query.do?jsessionid=b2bbf024f1a19510ef88a1392f646b68#>90028/90028
(Help) <http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90028>
CALL CSVREAD('test.csv');
SELECT * FROM CSVREAD('test.csv');
IO Exception: "IOException reading test.csv"; SQL statement:
SELECT * FROM CSVREAD('test.csv')
[90028-168]<http://192.168.0.12:8082/query.do?jsessionid=b2bbf024f1a19510ef88a1392f646b68#>90028/90028
(Help) <http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90028>
can you please suggest me correct procedure of using csv...and is csv
really useful for bulk insert.
Thanks in advance
On Tuesday, August 7, 2012 1:29:24 PM UTC-7, Thomas Mueller wrote:
>
> Hi,
>
> I guess CSVREAD is the only option for bulk insert.
>>
>
> You can use CREATE TABLE ... AS SELECT ... FROM
> yourOwnFunctionReturningAResultSet(...)
>
> Regards,
> Thomas
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/h6OK0CdeM-wJ.
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.
