Subject | import problem |
---|---|
Author | mkcmg |
Post date | 2010-05-15T17:56:23Z |
Greegings,
I am new to firebird but was told it was a good database for handling larger data tables. I am trying to use RazorSQL's import wizard to import a fixed length file of 112 fields and 390,000 records. The import gets about 30,000 records into it and dies with the error GDS Exception. 335544363. no transaction for request Reason: no transaction for request.
I also get this error in the log file: 4/2010 22:31:21:883 Stack Trace: java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space
05/14/2010 22:31:21:883 /j >SU0ln0kmg0Hxvu/T/WXl0XQX>ijXJXXnpgVhX(BTfTSPT HSil>X)
05/14/2010 22:31:21:883 /j >SU0ln0WiV0:/j/</kX0JXXnpgVhX0XQX>ijXJXXnpgVhX(BTfTSPT HSil>X)
05/14/2010 22:31:21:883 /j >SU0ln0WiV0:/j/</kX0JXXnpgVhX0liT(BTfTSPT HSil>X)
Am I running out of memory for this action?
Thank you for any assistance you can give me on this issue. I am doing this project for a potential employer and a future job hangs in the balance.
I am new to firebird but was told it was a good database for handling larger data tables. I am trying to use RazorSQL's import wizard to import a fixed length file of 112 fields and 390,000 records. The import gets about 30,000 records into it and dies with the error GDS Exception. 335544363. no transaction for request Reason: no transaction for request.
I also get this error in the log file: 4/2010 22:31:21:883 Stack Trace: java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space
05/14/2010 22:31:21:883 /j >SU0ln0kmg0Hxvu/T/WXl0XQX>ijXJXXnpgVhX(BTfTSPT HSil>X)
05/14/2010 22:31:21:883 /j >SU0ln0WiV0:/j/</kX0JXXnpgVhX0XQX>ijXJXXnpgVhX(BTfTSPT HSil>X)
05/14/2010 22:31:21:883 /j >SU0ln0WiV0:/j/</kX0JXXnpgVhX0liT(BTfTSPT HSil>X)
Am I running out of memory for this action?
Thank you for any assistance you can give me on this issue. I am doing this project for a potential employer and a future job hangs in the balance.