android.database.sqlite.SQLiteException: table TB_READ_PERIOD already exists-优快云博客

本文记录了一次在Android应用中使用SQLite创建已存在的表时引发的异常情况。该异常发生在尝试启动DBTestActivity组件时，由于试图创建已存在的TB_READ_PERIOD表而导致。此错误提示开发者检查SQL语句并确保不会重复创建同一名称的表。

11-13 16:04:04.209: ERROR/AndroidRuntime(19827): FATAL EXCEPTION: main
11-13 16:04:04.209: ERROR/AndroidRuntime(19827): java.lang.RuntimeException: Unable to start activity ComponentInfo{cn.peter.gasread/cn.peter.gasread.DBTestActivity}: android.database.sqlite.SQLiteException: table TB_READ_PERIOD already exists: , while compiling: CREATE TABLE TB_READ_PERIOD(_id INTEGER PRIMARY KEY,READ_BOOK_ID TEXT,READ_BOOK_NAME TEXT,READER_ID TEXT,READER_NAME TEXT,STATION_ID TEXT,STATION_NAME TEXT,HOUSE_ADDRESS TEXT,READ_SEQ INTEGER,LAST_NUMBER INTEGER,LAST_GAS_QTY INTEGER,LAST_DATE INTEGER,READ_PERIOD TEXT,GAS_METER_ID TEXT,REGISTRY_ID TEXT,FULL_SCALE REAL,PRICE REAL,READ_DATA_TYPE TEXT,PLATE_NUMBER TEXT,OWN_AMOUNT REAL,AVG_GAS_QTY REAL,HIGH_FACTOR REAL,LOW_FACTOR REAL)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1970)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1995)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.ActivityThread.access$600(ActivityThread.java:128)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1161)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.os.Handler.dispatchMessage(Handler.java:99)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.os.Looper.loop(Looper.java:137)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.ActivityThread.main(ActivityThread.java:4517)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at java.lang.reflect.Method.invokeNative(Native Method)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at java.lang.reflect.Method.invoke(Method.java:511)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:993)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:760)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at dalvik.system.NativeStart.main(Native Method)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827): Caused by: android.database.sqlite.SQLiteException: table TB_READ_PERIOD already exists: , while compiling: CREATE TABLE TB_READ_PERIOD(_id INTEGER PRIMARY KEY,READ_BOOK_ID TEXT,READ_BOOK_NAME TEXT,READER_ID TEXT,READER_NAME TEXT,STATION_ID TEXT,STATION_NAME TEXT,HOUSE_ADDRESS TEXT,READ_SEQ INTEGER,LAST_NUMBER INTEGER,LAST_GAS_QTY INTEGER,LAST_DATE INTEGER,READ_PERIOD TEXT,GAS_METER_ID TEXT,REGISTRY_ID TEXT,FULL_SCALE REAL,PRICE REAL,READ_DATA_TYPE TEXT,PLATE_NUMBER TEXT,OWN_AMOUNT REAL,AVG_GAS_QTY REAL,HIGH_FACTOR REAL,LOW_FACTOR REAL)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:134)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:84)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:2021)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1961)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at cn.peter.gasread.db.DBGasRead$DatabaseHelper.onCreate(DBGasRead.java:170)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:165)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at cn.peter.gasread.db.DBGasRead.<init>(DBGasRead.java:199)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at cn.peter.gasread.DBTestActivity.onCreate(DBTestActivity.java:25)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.Activity.performCreate(Activity.java:4470)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1053)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1934)
11-13 16:04:04.209: ERROR/AndroidRuntime(19827):     ... 11 more