Subject import problem
Author mkcmg
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.