Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
Developer
Posts: 26
Registered: ‎08-26-2009
My Device: Not Specified

Re: out of memory issue with sqlite database on blackberry os 5.0

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

Contributor
Posts: 17
Registered: ‎06-17-2010
My Device: C
My Carrier: SE

Re: out of memory issue with sqlite database on blackberry os 5.0

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.

Developer
Posts: 29
Registered: ‎02-24-2010
My Device: Not Specified
My Carrier: Vodafone

Re: out of memory issue with sqlite database on blackberry os 5.0

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?

Regular Visitor
Posts: 1
Registered: ‎03-14-2011
My Device: curve 8900
My Carrier: t mobile

Re: out of memory issue with sqlite database on blackberry os 5.0

Hello, 

 

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 ?

 

 

 

 

New Contributor
Posts: 3
Registered: ‎07-15-2011
My Device: 8700
My Carrier: Vodafone

Re: out of memory issue with sqlite database on blackberry os 5.0

Hi all,

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?

 

Kind regard

Riccardo

Developer
Posts: 48
Registered: ‎08-01-2008
My Device: Not Specified

Re: out of memory issue with sqlite database on blackberry os 5.0

[ Edited ]

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

Developer
Posts: 43
Registered: ‎08-26-2010
My Device: Not Specified

Re: out of memory issue with sqlite database on blackberry os 5.0

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. 

 

Thanks

Developer
Posts: 18
Registered: ‎02-03-2010
My Device: Blackberry Storm - 9570
My Carrier: Tim

Re: out of memory issue with sqlite database on blackberry os 5.0

I'm having the same problem.

Developer
Posts: 713
Registered: ‎05-31-2010
My Device: 8520
My Carrier: Movistar

Re: out of memory issue with sqlite database on blackberry os 5.0

I had the same problem and i solved changing the field from TEXT to BLOB...

Contributor
Posts: 23
Registered: ‎03-30-2011
My Device: Several Simulators
My Carrier: none - simulator only

Re: out of memory issue with sqlite database on blackberry os 5.0

[ Edited ]

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