logo       

[android-beginners] blob type size in SQLite database?: msg#01138

AndroidBeginners

Subject: [android-beginners] blob type size in SQLite database?


The question is that I store the large file as Blob type in the SQLite
database, the CursorWindow try to grow window size 1048576, then it
failed to allocating the large file in the database, I just wonder is
there limitation for Blob size, it seems only contain the file that
not exceeds 1048576?


07-29 15:36:15.554: ERROR/CursorWindow(1013): need to grow: mSize =
1048576, size = 3972972, freeSpace() = 1048473, numRows = 1
07-29 15:36:15.554: ERROR/CursorWindow(1013): Attempting to grow
window beyond max size (1048576)
07-29 15:36:15.563: ERROR/Cursor(1013): Failed allocating 3972972
bytes for blob at 0,2
07-29 15:36:15.573: DEBUG/Cursor(1013):
finish_program_and_get_row_count row 0
07-29 15:36:16.563: ERROR/CursorWindow(1013): need to grow: mSize =
1048576, size = 3972972, freeSpace() = 1048473, numRows = 1
07-29 15:36:16.573: ERROR/CursorWindow(1013): Attempting to grow
window beyond max size (1048576)
07-29 15:36:16.573: ERROR/Cursor(1013): Failed allocating 3972972
bytes for blob at 0,2
07-29 15:36:16.583: WARN/ActivityManager(581): Launch timeout has
expired, giving up wake lock!
07-29 15:36:16.594: DEBUG/Cursor(1013):
finish_program_and_get_row_count row 0
07-29 15:36:16.594: ERROR/CursorWindow(1013): Bad request for field
slot 0,0. numRows = 0, numColumns = 3
07-29 15:36:16.604: WARN/System.err(1013):
java.lang.IllegalStateException: get field slot from row 0 col 0
failed

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Beginners" group.
To post to this group, send email to android-beginners@xxxxxxxxxxxxxxxx
To unsubscribe from this group, send email to
android-beginners-unsubscribe@xxxxxxxxxxxxxxxx
For more options, visit this group at
http://groups.google.com/group/android-beginners?hl=en
-~----------~----~----~----~------~----~------~--~---

<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | Mail Home | sitemap | FAQ | advertise