01-25-2010 04:53 AM
Okay, this is a bug of blackberry API and someone else already create an issue for that. JAVAAPI-694. Rim has confirmed the bug already so hopefully the bug will be fixed in next release
06-25-2010 12:29 PM
I am storing JSON string in blackberry sqlite database and it goes out of memory. Is there any way to increase the memory or any other alternate way.
06-30-2010 07:15 AM
I exactly have the same problem.
I am rying to INSERT a json string in my SQLite database created on SDCard.
the JSON String's length is about 7850.
when executed, it gives RuntimeException: Out of Memory.
I am using Eclipse plug in.
is it a known issue?
how to resolve this?
03-14-2011 05:34 PM
i'm having the same issue trying to insert a big String in a sqlLite database. Has anyone encountered this problem and found a solution ?
07-19-2011 05:09 AM
I've got a database out of memory exception in a table of 14 columns and only one row. I try to make an update and on statement.execute() it throws the exception.
Anyone knows if RIM has already fixed this bug?
08-19-2011 12:26 PM - edited 08-19-2011 01:09 PM
I'm trying to insert quite a lot of data on a SQLite table of 18 columns and when inserting the 26th row it throws the out of memory exception
Just saw that I never closed my statements nor cursors, hope that fixes my problem
Edit1: Indeed, closing the statement and cursor when i didn't need em anymore solved my issue
11-15-2011 07:15 AM
Hi Im having the same problem with an out of memory issue, does anyone know if the reported bug is fixed or where to find out? I have checked that all the statements and cursors i am using are closed. I unfortunately can not use the Sqliteman.
11-21-2012 04:46 AM - edited 11-21-2012 04:46 AM
The memory limit depends on the BB device. So this issue can really cause a lot of trouble. I finally saved all BLOBs bigger than 5KB in a separate file and set sort of a flag in DB that the data is stored in a separate file. When reading the BLOB, i check if the flag is set and if so, it loads the data from the file. That works quite well for me, but of course is a bit slower