[SQLiteJDBC] out of heap space?

[Brain N]

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 <aweber at comcast.net> wrote:

>
>  ----- 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
> _______________________________________________
> SQLiteJDBC mailing list
> SQLiteJDBC at lists.hcoop.net
> https://lists.hcoop.net/listinfo/sqlitejdbc
>