I'm using the sqlitejdbc drivers on a table with millions of rows. It should be fine. It doesn't allocate space for every row in the table when you select from it. I'd think that it would be something else using up the memory and the driver is just attempting to use the very last of it, which is why you're getting an error there. Are you saving every row in memory somewhere as you're getting them?
If all else fails, maybe you should run a java memory profiler such as yourkit. On Tue, Feb 23, 2010 at 11:57 AM, AJ Weber <[email protected]> wrote: > > ----- Original Message ----- > From: AJ Weber > To: [email protected] > 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 > _______________________________________________ > SQLiteJDBC mailing list > [email protected] > https://lists.hcoop.net/listinfo/sqlitejdbc > _______________________________________________ SQLiteJDBC mailing list [email protected] https://lists.hcoop.net/listinfo/sqlitejdbc
