android - SQLiteBlobTooBigException:行太大,无法放入 CursorWindow requiredPos=0,totalRows=1
问题描述
我只在android 9中遇到异常,重新安装后一切看起来都很好,
例外:
android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1...
代码:
Cursor cursor = database.query(......);
if(cursor == null || cursor.getCount() < 0) { //Here is the error
Log.d("Error", "count : null");
return "";
}
编辑:
java.lang.RuntimeException: An error occurred while executing doInBackground()
at android.os.AsyncTask$3.done(AsyncTask.java:354)
at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)
at java.util.concurrent.FutureTask.setException(FutureTask.java:252)
at java.util.concurrent.FutureTask.run(FutureTask.java:271)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:764)
Caused by: android.database.sqlite.SQLiteBlobTooBigException: Row too big to fit into CursorWindow requiredPos=0, totalRows=1
at android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
at android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:859)
at android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
at android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
at android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:149)
at android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:137)
提前谢谢各位
解决方案
This worked for me, you have to put it on your Main Activity.
try {
Field field = CursorWindow.class.getDeclaredField("sCursorWindowSize");
field.setAccessible(true);
field.set(null, 100 * 1024 * 1024); //the 100MB is the new size
} catch (Exception e) {
e.printStackTrace();
}
推荐阅读
- c# - 从公钥创建证书
- ios - 如何使用 TLS 和自签名证书在本地服务器中使用 Alamofire 安全上传文件?
- javascript - 如何在页面上显示带有来自 JSON 的对象的数组?
- java - 我如何在java中为棋盘制作棋盘?
- javascript - 反应 - 将子数据传递给父 - 错误的复选框值
- javascript - 这个将数字转换为另一个数字的脚本好吗?
- java - 尝试使用 JButton
- huggingface-transformers - 在 Windows 上使用 transformers-cli?
- angular - ngOnInit 和数据绑定在 ModalView NativeScript Angular 中不起作用
- android - android studio中firebase依赖项的重复类错误