Hi, This should work. What database URL do you use? Did you try running it against a new (fresh) database? If it's an older database, maybe some config setting is incorrect (for example the cache size).
Regards, Thomas On Thu, Feb 14, 2013 at 3:30 PM, <[email protected]> wrote: > 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. > > > -- 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.
