Android Question SQLite SQLiteBlobTooBigException

makis_best

Well-Known Member
Licensed User
Longtime User
Hi

I try to read a BLOB record from SQLite database but I get the error

B4X: 
android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1

How to solve that problem?
 
Sort by date Sort by votes

makis_best

Well-Known Member
Licensed User
Longtime User
We talking about 45000 pictures to transfer from MS SQL server (BLOB) to any android device and stored.
Also that problem happening only with 10 to 15 pictures.
 
Upvote 0

KMatle

Expert
Licensed User
Longtime User
Usually you store media data to a file and reference it via db entry (=index). Otherwise it's hard to backup your data. So here you would "download" the image and build a reference in the SQlite db.
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
I would write a small B4J App to do the conversion (save blob to disc and generate the data to store in a SQLite DB). But you also have to download the 45000 Images. I would zip them just to download only one file. Maybe splitted.

Android (B4A) is the wrong solution here i guess.
 
Upvote 0

DonManfred

Expert
Licensed User
Longtime User
makis_best said:
And what if a picture update.. Need to run again?
Click to expand...
It depends on how you handle it. I would crate a flag in the db. Set it to 1 if the image is changed.
Set it to 0 if you already handled it once. So the next run only need to handle 50 (for ex) new Images and not all.

All depends on Design.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Displaying a Image from SQLite Blob
Replies
3
Views
2K
Terradrones
J
  • Question
Android Question Row too big to fit into CursorWindow
Replies
14
Views
18K
Mahares
M
M
  • Question
Android Question Cursor size too big
Replies
14
Views
6K
Mahares
M
  • Question
Android Question SQLite - BLOB field
2
Replies
24
Views
9K
emexes
E
  • Question
Android Question SQLite SQLiteBlobTooBigException on SDK 28
Replies
5
Views
7K
priusfan
P
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…