makis_best Well-Known Member Licensed User Longtime User Apr 4, 2022 #1 Hi I try to read a BLOB record from SQLite database but I get the error B4X: Copy android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1 How to solve that problem?
Hi I try to read a BLOB record from SQLite database but I get the error B4X: Copy android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1 How to solve that problem?
LucaMs Expert Licensed User Longtime User Apr 4, 2022 #2 Tip: https://www.google.it/search?q=site...AuMS4wLjGYAQCgAQGgAQLIAQjAAQE&sclient=gws-wiz Upvote 0
DonManfred Expert Licensed User Longtime User Apr 4, 2022 #3 makis_best said: How to solve that problem? Click to expand... Fetch less than 1mb of Data from the DB. What have you stored in the DB and how many data you are fetching? Upvote 0
makis_best said: How to solve that problem? Click to expand... 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 Well-Known Member Licensed User Longtime User Apr 4, 2022 #4 DonManfred said: Fetch less than 1mb of Data from the DB. What have you stored in the DB and how many data you are fetching? Click to expand... Just one picture... nothing more but the size is like 10MB Upvote 0
DonManfred said: Fetch less than 1mb of Data from the DB. What have you stored in the DB and how many data you are fetching? Click to expand... Just one picture... nothing more but the size is like 10MB
DonManfred Expert Licensed User Longtime User Apr 4, 2022 #5 makis_best said: nothing more but the size is like 10MB Click to expand... 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! Upvote 0
makis_best said: nothing more but the size is like 10MB Click to expand... 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 Well-Known Member Licensed User Longtime User Apr 4, 2022 #6 I can't do that way... I need to change all the philosophy of the app Upvote 0
DonManfred Expert Licensed User Longtime User Apr 4, 2022 #7 makis_best said: I can't do that way... I need to change all the philosophy of the app Click to expand... 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. Upvote 0
makis_best said: I can't do that way... I need to change all the philosophy of the app Click to expand... 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 Well-Known Member Licensed User Longtime User Apr 4, 2022 #8 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
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 Expert Licensed User Longtime User Apr 4, 2022 #9 You can use jRDC2 and connect to MS SQL Server from jRDC2. Upvote 0
makis_best Well-Known Member Licensed User Longtime User Apr 4, 2022 #10 DonManfred said: You can use jRDC2 and connect to MS SQL Server from jRDC2. Click to expand... I already do that Upvote 0
DonManfred said: You can use jRDC2 and connect to MS SQL Server from jRDC2. Click to expand... I already do that
DonManfred Expert Licensed User Longtime User Apr 4, 2022 #11 makis_best said: I already do that Click to expand... 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. Upvote 0
makis_best said: I already do that Click to expand... 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 Well-Known Member Licensed User Longtime User Apr 4, 2022 #12 DonManfred said: the error does not come from jRDC2 but form SQLite, right? Click to expand... Yes Upvote 0
KMatle Expert Licensed User Longtime User Apr 4, 2022 #13 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
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 Well-Known Member Licensed User Longtime User Apr 4, 2022 #14 So no matter what.. I need to make 45000 MS SQL records to files. Upvote 0
DonManfred Expert Licensed User Longtime User Apr 4, 2022 #15 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
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 Well-Known Member Licensed User Longtime User Apr 4, 2022 #16 And what if a picture update.. Need to run again? Upvote 0
DonManfred Expert Licensed User Longtime User Apr 4, 2022 #17 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
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.
makis_best Well-Known Member Licensed User Longtime User Apr 4, 2022 #18 Perfect idea. Thanks Upvote 0
