六狼论坛

 找回密码
 立即注册

QQ登录

只需一步,快速开始

新浪微博账号登陆

只需一步,快速开始

搜索
查看: 124|回复: 0

操作SQLite数据库报错:“绑定或列的索引超出范围”

[复制链接]

升级  56%

40

主题

40

主题

40

主题

秀才

Rank: 2

积分
134
 楼主| 发表于 2013-1-30 01:00:55 | 显示全部楼层 |阅读模式
Android 2.3.3           Eclipse Version: 3.7.0           LogCat   LogCat 报错信息:
02-13 09:21:35.030: WARN/dalvikvm(17173): threadid=19: thread exiting with uncaught exception (group=0x40015560)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): FATAL EXCEPTION: Thread-2602-13 09:21:35.130: ERROR/AndroidRuntime(17173): android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x309b0802-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteProgram.native_bind_string(Native Method)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:244)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteQuery.bindString(SQLiteQuery.java:185)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:48)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1356)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1235)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1189)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1271)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at com.tmall.nokia.db.RecordDBHelper.query(RecordDBHelper.java:50)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at com.tmall.nokia.manage.RecordDBopt.get(RecordDBopt.java:78)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at com.tmall.nokia.manage.RecordMessage.sendMseeage(RecordMessage.java:111)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at com.tmall.nokia.manage.RecordMessage.sendMseeage(RecordMessage.java:87)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at com.tmall.nokia.Report.run(Report.java:49)02-13 09:21:35.130: ERROR/AndroidRuntime(17173): at java.lang.Thread.run(Thread.java:1019)02-13 09:21:35.200: WARN/ActivityManager(62): Force finishing activity com.tmall.nokia/.Iphone 
发生错误原因分析:
此处at com.tmall.nokia.db.RecordDBHelper.query(RecordDBHelper.java:50)出现问题:
Cursor cur = db.query(TBL_NAME, null, where, args, null, null, order); 按照错误Log提示,继续查找出错位置,发现传入参数where和args数组长度不一致。因此报错“android.database.sqlite.SQLiteException: bind or column index out of range”(绑定或列的索引超出范围)。

解决办法:
找到出错原因后,修改传入参数,保证传入参数where 与args长度一致。
您需要登录后才可以回帖 登录 | 立即注册 新浪微博账号登陆

本版积分规则

快速回复 返回顶部 返回列表