Android Question SQLite SQLiteBlobTooBigException

[makis_best]

Hi

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

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

How to solve that problem?

 

[LucaMs]

Tip:

https://www.google.it/search?q=site...AuMS4wLjGYAQCgAQGgAQLIAQjAAQE&sclient=gws-wiz

 

[DonManfred]

How to solve that problem?

Fetch less than 1mb of Data from the DB. What have you stored in the DB and how many data you are fetching?

 

[makis_best]

Fetch less than 1mb of Data from the DB. What have you stored in the DB and how many data you are fetching?

Just one picture... nothing more but the size is like 10MB

 

[DonManfred]

nothing more but the size is like 10MB

Store the image on disc and only store the path to the file (or just the firename).
You can not use such big blobs with SQLite!

 

[makis_best]

I can't do that way... I need to change all the philosophy of the app

 

[DonManfred]

I can't do that way... I need to change all the philosophy of the app

It is a fact that you need to as you are storing too much (to big) data in the SQLite-DB.
You concept is kind of wrong.

 

[makis_best]

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.

 

[DonManfred]

You can use jRDC2 and connect to MS SQL Server from jRDC2.

 

[makis_best]

You can use jRDC2 and connect to MS SQL Server from jRDC2.

I already do that

 

[DonManfred]

I already do that

the error does not come from jRDC2 but form SQLite, right?
Store the image on disc after you received it from jRDC2. Store just the path where you saved the image to disc on your SQLite-Database.

 

[makis_best]

the error does not come from jRDC2 but form SQLite, right?

Yes

 

[KMatle]

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.

 

[makis_best]

So no matter what.. I need to make 45000 MS SQL records to files.

 

[DonManfred]

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.

 

[makis_best]

And what if a picture update.. Need to run again?

 

[DonManfred]

And what if a picture update.. Need to run again?

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.

 

[makis_best]

Perfect idea.

Thanks