04-12-2012 05:16 AM
From what I understand from this..
Note that using the buffered cursor may throw an OutOfMemoryError if it is used with huge data queries.
Can I know what is the definition of "HUGE".
Else, can nayone tell me the range of number of entries that can be stored in BufferedCursor without any exception.
Solved! Go to Solution.
04-16-2012 09:37 AM
This is a cumulative value based on all your SQLite queries. From this page: https://bdsc.webapps.blackberry.com/java/documenta
The amount of RAM available to an SQLite database for storing internal data structures for schemas and transactions has increased (in 7.0) to 16 MB (from 5 MB in 6.0). A query can now be up to 1 MB. In BlackBerry Java SDK 6.0, the query length limit was 4 KB. The file handle limit has increased to 64, allowing you to open up to 56 databases at the same time in In BlackBerry Java SDK 7.0.