Try to get large file

Hi developers this beautiful issue for large data. I receive problem, your project don't has any docs. I will be very happy if you write docs for usage all functionality with samples. Thanks.

Also I have another problem, when try to get large blob data at android database.

When I try get large blob witch biggest than phone VM heap, I receive out of memory exception.

                db.open(true);
                SQLiteStatement sqLiteStatement = db.prepare("SELECT * FROM ZLISTENEXERCISE");

                List<AudioText> audioTextList = new ArrayList<AudioText>();

                try {
                    while (sqLiteStatement.step()) {
                        System.gc();
                        AudioText audioText = new AudioText();
                        audioText.articleName = Tools.escapeApostrophe(sqLiteStatement.columnString(1));
                        audioText.editionName = sqLiteStatement.columnString(2);
                        audioText.title = Tools.escapeApostrophe(sqLiteStatement.columnString(3));
                        audioText.content = sqLiteStatement.columnString(4);
                        audioText.audio = sqLiteStatement.columnBlob(5);
                        audioTextList.add(audioText);
                    }
                } finally {
                    sqLiteStatement.dispose();
                    db.dispose();
                }

When code execution problem has come at 14 line. So when I can solve this issue ??? Very thanks.

Comments (2)