sqlite 数据插入失败

前端之家收集整理的这篇文章主要介绍了sqlite 数据插入失败前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
07-24 17:02:04.866: E/sqliteDatabase(19334): Error inserting usn=d9703267-c905-483b-ac0a-fce6ac9679af ip=192.168.100.10 07-24 17:02:04.866: E/sqliteDatabase(19334): android.database.sqlite.sqliteException: table pairing has no column named usn:,while compiling: INSERT INTO pairing(usn,ip) VALUES (?,?) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteCompiledsql.native_compile(Native Method) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteCompiledsql.<init>(sqliteCompiledsql.java:68) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteProgram.compilesql(sqliteProgram.java:150) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteProgram.compileAndbindAllArgs(sqliteProgram.java:368) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteStatement.acquireAndLock(sqliteStatement.java:272) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteStatement.executeInsert(sqliteStatement.java:115) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteDatabase.insertWithOnConflict(sqliteDatabase.java:1832) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.database.sqlite.sqliteDatabase.insert(sqliteDatabase.java:1705) 07-24 17:02:04.866: E/sqliteDatabase(19334): at cn.com.ammfe.application.MysqLLiteHelper.insertdata(MysqLLiteHelper.java:47) 07-24 17:02:04.866: E/sqliteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.cusorinsertorupdate(MyService.java:157) 07-24 17:02:04.866: E/sqliteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.handleMessage(MyService.java:146) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.os.Handler.dispatchMessage(Handler.java:99) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.os.Looper.loop(Looper.java:156) 07-24 17:02:04.866: E/sqliteDatabase(19334): at android.app.ActivityThread.main(ActivityThread.java:4977) 07-24 17:02:04.866: E/sqliteDatabase(19334): at java.lang.reflect.Method.invokeNative(Native Method) 07-24 17:02:04.866: E/sqliteDatabase(19334): at java.lang.reflect.Method.invoke(Method.java:511) 07-24 17:02:04.866: E/sqliteDatabase(19334): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784) 07-24 17:02:04.866: E/sqliteDatabase(19334): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) 07-24 17:02:04.866: E/sqliteDatabase(19334): at dalvik.system.NativeStart.main(Native Method) 07-24 17:02:04.876: E/MyService(19334): handlemessage 07-24 17:02:04.926: E/sqliteDatabase(19334): Error inserting usn=d9703267-c905-483b-ac0a-fce6ac9679af ip=192.168.100.10 07-24 17:02:04.926: E/sqliteDatabase(19334): android.database.sqlite.sqliteException: table pairing has no column named usn:,?) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteCompiledsql.native_compile(Native Method) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteCompiledsql.<init>(sqliteCompiledsql.java:68) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteProgram.compilesql(sqliteProgram.java:150) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteProgram.compileAndbindAllArgs(sqliteProgram.java:368) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteStatement.acquireAndLock(sqliteStatement.java:272) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteStatement.executeInsert(sqliteStatement.java:115) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteDatabase.insertWithOnConflict(sqliteDatabase.java:1832) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.database.sqlite.sqliteDatabase.insert(sqliteDatabase.java:1705) 07-24 17:02:04.926: E/sqliteDatabase(19334): at cn.com.ammfe.application.MysqLLiteHelper.insertdata(MysqLLiteHelper.java:47) 07-24 17:02:04.926: E/sqliteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.cusorinsertorupdate(MyService.java:157) 07-24 17:02:04.926: E/sqliteDatabase(19334): at cn.com.ammfe.MyService$MyHandler.handleMessage(MyService.java:146) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.os.Handler.dispatchMessage(Handler.java:99) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.os.Looper.loop(Looper.java:156) 07-24 17:02:04.926: E/sqliteDatabase(19334): at android.app.ActivityThread.main(ActivityThread.java:4977) 07-24 17:02:04.926: E/sqliteDatabase(19334): at java.lang.reflect.Method.invokeNative(Native Method) 07-24 17:02:04.926: E/sqliteDatabase(19334): at java.lang.reflect.Method.invoke(Method.java:511) 07-24 17:02:04.926: E/sqliteDatabase(19334): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784) 07-24 17:02:04.926: E/sqliteDatabase(19334): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) 07-24 17:02:04.926: E/sqliteDatabase(19334): at dalvik.system.NativeStart.main(Native Method)

猜你在找的Sqlite相关文章