[SQLiteJDBC] out of heap space?

[AJ Weber]

  ----- Original Message ----- 
  From: AJ Weber 
  To: sqlitejdbc at lists.hcoop.net 
  Sent: Tuesday, February 23, 2010 12:45 PM
  Subject: out of heap space?


  I'm using java to select a few hundred rows from a very large table (roughly 1.5MM rows), but I'm getting a heap-space problem.  Does anyone know how to debug this, or if this is a "known issue"?

  I run with -Xms128m -Xmx1024m, which should be plenty.

  Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
   at org.sqlite.NativeDB.column_text(Native Method)
   at org.sqlite.RS.getString(RS.java:245)
   at org.sqlite.RS.getObject(RS.java:295)
   at quick.dbtable.t.j(DBTableModel.java:993)
   at quick.dbtable.t.a(DBTableModel.java:658)
   at quick.dbtable.DBTable.a(DBTable.java:2685)
   at quick.dbtable.DBTable.refresh(DBTable.java:2888)

  Thanks in advance.
  -AJ