오류 내용:


03-09 08:19:01.239: I/SqliteDatabaseCpp(2659): sqlite returned: error code = 1, msg = no such table: anniversary, db=/data/data/com.menu.Anniversary/databases/databases.db

03-09 08:19:01.239: D/AndroidRuntime(2659): Shutting down VM

03-09 08:19:01.239: W/dalvikvm(2659): threadid=1: thread exiting with uncaught exception (group=0x409c01f8)

03-09 08:19:01.279: E/AndroidRuntime(2659): FATAL EXCEPTION: main

03-09 08:19:01.279: E/AndroidRuntime(2659): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.menu.Anniversary/com.month.January.Seollal}: android.database.sqlite.SQLiteException: no such table: anniversary: , while compiling: select * from anniversary where _id = 1

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1956)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.ActivityThread.access$600(ActivityThread.java:123)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.os.Handler.dispatchMessage(Handler.java:99)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.os.Looper.loop(Looper.java:137)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.ActivityThread.main(ActivityThread.java:4424)

03-09 08:19:01.279: E/AndroidRuntime(2659): at java.lang.reflect.Method.invokeNative(Native Method)

03-09 08:19:01.279: E/AndroidRuntime(2659): at java.lang.reflect.Method.invoke(Method.java:511)

03-09 08:19:01.279: E/AndroidRuntime(2659): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)

03-09 08:19:01.279: E/AndroidRuntime(2659): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)

03-09 08:19:01.279: E/AndroidRuntime(2659): at dalvik.system.NativeStart.main(Native Method)

03-09 08:19:01.279: E/AndroidRuntime(2659): Caused by: android.database.sqlite.SQLiteException: no such table: anniversary: , while compiling: select * from anniversary where _id = 1

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1538)

03-09 08:19:01.279: E/AndroidRuntime(2659): at com.month.January.Seollal.onCreate(Seollal.java:84)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.Activity.performCreate(Activity.java:4465)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)

03-09 08:19:01.279: E/AndroidRuntime(2659): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)

03-09 08:19:01.279: E/AndroidRuntime(2659): ... 11 more


소스:..ary Manifest.xml


<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.menu.Anniversary"
    android:versionCode="1"
    android:versionName="1.0" >
    <uses-sdk android:minSdkVersion="8" />
    <application
        android:icon="@drawable/ic_launcher"
        android:label="@string/main_name" >
        <activity
            android:name=".Anniversary"
            android:label="@string/main_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
        <activity android:name="com.month.January.Seollal" 
 android:theme="@android:style/Theme.Dialog" 
 android:label =""/>
    </application>
        <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE"/>
</manifest>

java파일
package com.month.January;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;

import com.menu.Anniversary.ProductDBHelper;
import com.menu.Anniversary.R;

import android.app.TabActivity;
import android.content.res.AssetManager;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.widget.SimpleCursorAdapter;
import android.widget.Toast;


public class Seollal extends TabActivity {

public SQLiteDatabase db;
public Cursor cursor;
public SimpleCursorAdapter Adapter=null;
public SimpleCursorAdapter AdapterStomach=null;
public SimpleCursorAdapter AdapterColon=null;
public SimpleCursorAdapter AdapterLiver=null;
public SimpleCursorAdapter AdapterBreast=null;
public SimpleCursorAdapter AdapterCervix=null;
public static final String ROOT_DIR = "/data/data/com.menu.Anniversary/databases/";
ProductDBHelper mHelper;
public void setDB() {
File folder = new File(ROOT_DIR);
Log.d("확인","folder:"+folder);
 
if(folder.exists()) {
}else {
folder.mkdirs();
//Toast.makeText(this, "폴더생성", Toast.LENGTH_LONG).show();
}
Log.d("확인2","folder:"+folder);
AssetManager assetManager = getResources().getAssets();
  File outfile = new File(ROOT_DIR+"databases.db"); //--폰에 위치할 경로
  InputStream is = null; 
    
  FileOutputStream fo = null;
  
  long filesize = 0;
  Log.d("outfile",""+outfile);
  Log.d("outfile",""+outfile.length());
try {
// --asset 폴더 및 복사할 DB 지정
is = assetManager.open("databases.db", AssetManager.ACCESS_BUFFER);  
filesize = is.available(); //--사이즈 검증
if (outfile.length() <= 0) {
byte[] tempdata = new byte[(int) filesize];
is.read(tempdata); 
is.close(); 
outfile.createNewFile();
fo = new FileOutputStream(outfile);
fo.write(tempdata);
fo.close();    
}
    else
    {
    //Toast.makeText(this, "db있음", Toast.LENGTH_LONG).show();
    }
}catch (IOException e) { 
Toast.makeText(this, "db이동실패", Toast.LENGTH_LONG).show();
}
}
public void onCreate(Bundle savedInstanceState) {
setDB();
System.out.println("filesize::------->>>>88888");
ProductDBHelper mHelper;
mHelper=new ProductDBHelper(this);
db=mHelper.getWritableDatabase();
System.out.println("filesize::------->>>>9999");
Log.i("db확인","==>"+db);
cursor=db.rawQuery("select * from anniversary where _id = 1",null);
System.out.println("filesize::------->>>>0000");
    startManagingCursor(cursor);
//cursor.moveToLast();
//String str=cursor.getString(5);
//Toast.makeText(this,str, Toast.LENGTH_LONG).show();
   
    //ListView list=(ListView)findViewById(R.id.stomach_list);
    //AdapterStomach=new SimpleCursorAdapter(list.getContext(), R.layout.mylist, cursor, 
    //new String[]{"DxCodName"},new int[]{R.id.text1});
   
    //list.setAdapter(AdapterStomach);
//super.onCreate(savedInstanceState);
//setContentView(R.layout.apple_brain);
}
}



만들고 있는중이라 엉망인데요 
녹색으로 표기한 부분이 수행되지 않고 위 내용처럼 오류가 발생합니다.
sql에_id는 있고요 따로 쿼리문만 빼서 돌리면 정상적으로 나옵니다
아무리 오류내용을 봐도 테이블이 없다는 이유를 모르겠습니다.
도움이 필요합니다.

이 게시물을