Often I also get:
2013-02-14 15:21:51,089 ERROR 119 [console.ConsoleProgram] - <Unable to do
abstraction>
org.springframework.jdbc.UncategorizedSQLException: StatementCallback;
uncategorized SQLException for SQL [CREATE TABLE PARAMS (FID INT,MEANING
VARCHAR(4),VALUE TEXT,HID INT) AS SELECT * FROM
CSVREAD('/home/joe/Desktop/SSD/analysis/28602/run0/concrete analysis
files/params.csv','FID,MEANING,VALUE,HID');]; SQL state [90108]; error code
[90108]; Out of memory.; SQL statement:
CREATE TABLE PARAMS (FID INT,MEANING VARCHAR(4),VALUE TEXT,HID INT) AS SELECT *
FROM CSVREAD('/home/joe/Desktop/SSD/analysis/28602/run0/concrete analysis
files/params.csv','FID,MEANING,VALUE,HID'); [90108-168]; nested exception is
org.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement:
CREATE TABLE PARAMS (FID INT,MEANING VARCHAR(4),VALUE TEXT,HID INT) AS SELECT *
FROM CSVREAD('/home/joe/Desktop/SSD/analysis/28602/run0/concrete analysis
files/params.csv','FID,MEANING,VALUE,HID'); [90108-168]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)
at database.CSVImporter.bulkImport(CSVImporter.java:121)
at database.CSVImporter.convertCSVDataToDB(CSVImporter.java:73)
at console.ConsoleProgram.doAbstraction(ConsoleProgram.java:107)
at console.ConsoleProgram.launch(ConsoleProgram.java:54)
at console.ConsoleProgram.main(ConsoleProgram.java:192)
Caused by: org.h2.jdbc.JdbcSQLException: Out of memory.; SQL statement:
Am Donnerstag, 14. Februar 2013 15:14:27 UTC+1 schrieb
[email protected]:
>
> Hi
>
> I am using create table from csvread to import big files (up to 1GB).
> However for files bigger than 300mb the operation seems to stuck, heap size
> is extremely big and the file database around some mbs. It seems to me like
> the CSVREAD op isn't buffered, all data of the csv files is first loaded
> and then imported. Is there anyway to debug / solve this issue?
>
> -- Joe
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
