InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Hi,

  I have been trying without success to import a database from a CSV files
with approximately 14,000 rows.  When I execute the import command with
DBBrowser, I get an OutOfMemoryError before the import completes (it only
gets to record 3000/14000). [See below.]

  I get the same error when I run the import via ScriptTool with Buffer
1024.  When I shrink Buffer down to 200 with ScriptTool, I get some
records imported then I get an IO File Error (EOFExceptionnull).  [See
below for the errors.]


Running java version "1.2.2"
Classic VM (build 1.2.2-L, green threads, nojit)

     Any suggestions on how to successfully import this data would be
greatly appreciated.

    Thank you,
	Patryk Laurent

please cc: matthew.davidson@scholarone.com



EOFExceptionnull received while running ScriptTool.
---------------------------------------------------

sql1.txt IMPORT presentations FROM "ps1.txt" BUFFER 200
Error importing line 1

     [...Line of data is displayed...]

java.sql.SQLException: java.sql.SQLException: IO problem: java.io.EOFExceptionnull
        at org.enhydra.instantdb.db.Table.addRowAtRow(Table.java:1313)
        at
org.enhydra.instantdb.db.SQLProg.compile_import(SQLProg.java:875)
        at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:238)
        at
org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235)
        at
org.enhydra.instantdb.jdbc.idbStatement.executeUpdate(idbStatement.java:103)
        at org.enhydra.instantdb.SampleThread.run(ScriptTool.java:410)
        at java.lang.Thread.run(Thread.java:475)
Error importing line 2



OutOfMemory Error received while running DBBrowser.
---------------------------------------------------

AWT-EventQueue-0 import presentations from "ps.txt" using 
"import_schema2.txt" buffer 200

AWT-EventQueue-0 java.lang.OutOfMemoryError: 
java.sql.SQLException: 
        at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
        at
org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java:235)
        at org.enhydra.instantdb.JDBCAppl.action(JDBCAppl.java:214)
        at java.awt.Component.handleEvent(Component.java:3284)
        at org.enhydra.instantdb.JDBCAppl.handleEvent(JDBCAppl.java:270)
        at java.awt.Component.postEvent(Component.java:2547)
        at java.awt.Component.postEvent(Component.java:2557)
        at java.awt.Component.postEvent(Component.java:2557)
        at java.awt.Component.postEvent(Component.java:2557)
        at java.awt.Component.dispatchEventImpl(Component.java:2408)
        at java.awt.Component.dispatchEvent(Component.java:2309)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:283)
        at
java.awt.EventDispatchThread.pumpOneEvent(EventDispatchThread.java:97)
        at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:88)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:79)






-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.