sqlite get field with more than 2 MB

Question

When I try to get data from SQlite and size of field more than 2 MB it throw exception

"Couldn't read row 0, col 0 from Cursor Window. Make sure the Cursor is initialized correctly before accessing data from it."

How can I store a field that have above 2 Mb get into string ?

i store multiple Base64 Strings as LONG TEXT in sqlite it store successfully but when i fatch from database that goes into exception because of that field contain above 2400000 characters.

this is the code

public ArrayList<HashMap<String, String>> selectRecordFromDbList(String qry, String[] args, boolean status) {
        ArrayList<HashMap<String, String>> arraylist = null;
        try {
            HashMap<String, String> mapRow;
            Cursor cursor = sqLiteDatabase.rawQuery(qry, args);
            if (cursor.moveToFirst()) {
                arraylist = new ArrayList<>();
                do {
                    mapRow = new HashMap<>();
                    for (int i = 0; i < cursor.getColumnCount(); i++) {
                        mapRow.put(cursor.getColumnName(i), cursor.getString(i));
                    }
                    arraylist.add(mapRow);
                } while (cursor.moveToNext());
            }
            if (cursor != null && cursor.isClosed()) {
                cursor.close();
            }
        } catch (Exception e) {
            Log.e("SqliteAssetHelper:", e.getMessage());
            arraylist = null;

        }
        return arraylist;
    }

I don't think that message says anything about 2MB fields. Please add your code — OneCricketeer, Aug 26 '17 at 07:21
check out the Question if you know some thing about it, it will really help full. — Jai Khambhayta, Aug 26 '17 at 07:27
Again, add your code as a [mcve], preferably. First idea, use a BLOB not TEXT — OneCricketeer, Aug 26 '17 at 07:29

score 0 · Accepted Answer · answered Aug 26 '17 at 07:48

0

It is not advisable to store large BLOBS or similar data in the SQLite database. You should use the file system and only store a reference to the data in you database. Refer to this answer

answered Aug 26 '17 at 07:48

Frederick Nyawaya

2,285
1
15
19

This is what I will do, but until save the file, I need to download the chunks. Some idea of how this should be done? – IgniteCoders Apr 05 '18 at 12:15

sqlite get field with more than 2 MB

1 Answers1

Linked

Related