SQLException 下载报这个异常

[zhw634631]

SQLException 下载报这个异常

[zhw634631]

我使用demo下载测试,也会报相同的sql异常
(1) no such column: id
java.sql.SQLException: queryForLong from database failed: SELECT COUNT() FROM downloadentry WHERE id = ?
at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22)
at com.j256.ormlite.android.AndroidDatabaseConnection.queryForLong(AndroidDatabaseConnection.java:242)
at com.j256.ormlite.stmt.StatementExecutor.ifExists(StatementExecutor.java:603)
at com.j256.ormlite.dao.BaseDaoImpl.idExists(BaseDaoImpl.java:807)
at com.j256.ormlite.dao.BaseDaoImpl.createOrUpdate(BaseDaoImpl.java:335)
at com.xwdz.download.core.DownloadDBManager.newOrUpdate(DownloadDBManager.java:57)
at com.xwdz.download.core.DataChanger.postNotifyStatus(DataChanger.java:59)
at com.xwdz.download.core.DownloaderHandler$1.handleMessage(DownloaderHandler.java:67)
at android.os.Handler.dispatchMessage(Handler.java:103)
at android.os.Looper.loop(Looper.java:214)
at android.app.ActivityThread.main(ActivityThread.java:7710)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:516)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:950)
Caused by: android.database.sqlite.SQLiteException: no such column: id (code 1 SQLITE_ERROR): , while compiling: SELECT COUNT() FROM
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:986)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:593)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:61)
at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1469)
at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1397)
at com.j256.ormlite.android.AndroidDatabaseConnection.queryForLong(AndroidDatabaseConnection.java:231)

[zhw634631]

已解决:id不能加"/"否则就会出这个问题