当前位置:   article > 正文

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: , while compiling: INSERT INTO pairing(usn,ip) VALUES (?,?)
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)
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/知新_RL/article/detail/316589
推荐阅读
相关标签
  

闽ICP备14008679号