현재 에뮬레이터와 모토로이에서 각각 동일한 소스코드를 돌려보았는데요.

 문제는 에뮬레이터에서는 디비에 데이터가 들어가지만 같은 소스로 바로 모토로이로 실행하면 다음과 같은 에러가 뜹니다.

03-31 14:42:10.960: ERROR/Database(9366): Error inserting userID=queza2 roomID=2
03-31 14:42:10.960: ERROR/Database(9366): android.database.sqlite.SQLiteException: no such table: JoinMember: , while compiling: INSERT INTO JoinMember(userID, roomID) VALUES(?, ?);
03-31 14:42:10.960: ERROR/Database(9366):     at android.database.sqlite.SQLiteProgram.native_compile(Native Method)
03-31 14:42:10.960: ERROR/Database(9366):     at android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110)
03-31 14:42:10.960: ERROR/Database(9366):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
03-31 14:42:10.960: ERROR/Database(9366):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
03-31 14:42:10.960: ERROR/Database(9366):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1026)
03-31 14:42:10.960: ERROR/Database(9366):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1412)
03-31 14:42:10.960: ERROR/Database(9366):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1285)
03-31 14:42:10.960: ERROR/Database(9366):     at com.ithcity.android.prototype.controlls.DbAdapter.createJoinMember(DbAdapter.java:151)
03-31 14:42:10.960: ERROR/Database(9366):     at com.ithcity.android.prototype.views.dbTest.onCreate(dbTest.java:21)
03-31 14:42:10.960: ERROR/Database(9366):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
03-31 14:42:10.960: ERROR/Database(9366):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459)
03-31 14:42:10.960: ERROR/Database(9366):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512)
03-31 14:42:10.960: ERROR/Database(9366):     at android.app.ActivityThread.access$2200(ActivityThread.java:119)
03-31 14:42:10.960: ERROR/Database(9366):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
03-31 14:42:10.960: ERROR/Database(9366):     at android.os.Handler.dispatchMessage(Handler.java:99)
03-31 14:42:10.960: ERROR/Database(9366):     at android.os.Looper.loop(Looper.java:123)
03-31 14:42:10.960: ERROR/Database(9366):     at android.app.ActivityThread.main(ActivityThread.java:4353)
03-31 14:42:10.960: ERROR/Database(9366):     at java.lang.reflect.Method.invokeNative(Native Method)
03-31 14:42:10.960: ERROR/Database(9366):     at java.lang.reflect.Method.invoke(Method.java:521)
03-31 14:42:10.960: ERROR/Database(9366):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
03-31 14:42:10.960: ERROR/Database(9366):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
03-31 14:42:10.960: ERROR/Database(9366):     at dalvik.system.NativeStart.main(Native Method)


소스는 똑같습니다. 에뮬레이터에서 먼저 실행하여 테이터가 잘 들어가는 것이 확인되며 모토로이에서 실행시는 insert시에 -1값이 나오는 것으로 보아 들어가지 않는 것 같구요. 테이블을 먼가 못찾는것 같은데 cmd에서도 디비로 접근이 안되니까 테이블이 만들어졌는지 확인도 안되구요.

질문을 요약하자면,
1. 같은 소스인데 에뮬과 모토로이에서 디비 사용시 차이가 보이는 이유
2. 모토로이는 권한이 일반유저라 ddms에서 데이터폴더로를 못보는걸로 아는데 이것을 보거나 데이터베이스 파일을 지울 수 있는 방법은?

혹시 몰라 데이터베이스 생성과 테이블 삽입 소스도 첨부해봅니다.(노트패드의 아답터를 그냥 사용했습니다)

private static final String roomTable = "create table RoomInfo (" +
  "roomID integer not null, roomTitle text not null, roomDate text not null," +
  "joinLongitude integer not null, joinLatitude integer not null, joinDate text not null, " +
  "roomPassword text null, description text null, maxNumber integer null, joinNumber integer null);";

private static class DatabaseHelper extends SQLiteOpenHelper{
  DatabaseHelper(Context context){
   super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }
  public void onCreate(SQLiteDatabase db){
   db.execSQL(userTable);  // 여러 테이블을 생성하기 위해;
   db.execSQL(roomTable);
   db.execSQL(friendsTable);
   db.execSQL(chatTable);
   db.execSQL(joinTable);
  }
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
   Log.w(TAG,"Upgrading database from version " + oldVersion + " to " + newVersion + ", which destroy all old data");
   db.execSQL("DROP TABLE IF EXISTS UserInfo");
   db.execSQL("DROP TABLE IF EXISTS RoomInfo2");
   db.execSQL("DROP TABLE IF EXISTS FriendsInfo");
   db.execSQL("DROP TABLE IF EXISTS ChatInfo");
   db.execSQL("DROP TABLE IF EXISTS JoinMember");
  }
 }
 public DbAdapter(Context ctx){
  this.mCtx = ctx;
 }
 public DbAdapter open() throws SQLException{
  mDbHelper = new DatabaseHelper(mCtx);
  mDb = mDbHelper.getWritableDatabase();
  return this;
 }
 public void close(){
  mDbHelper.close();
 }
public long createRoomInfo(int rid,String rtitle,String rdate, int loc, int lac, String jdate, String rpw, String desc, int mn, int jn){
  ContentValues initialValues = new ContentValues();
  initialValues.put(ROOM_ID, rid);
  initialValues.put(ROOM_TITLE, rtitle);
  initialValues.put(ROOM_DATE, rdate);
  initialValues.put(ROOM_JOINLOC, loc); 
  initialValues.put(ROOM_JOINLAC, lac);
  initialValues.put(ROOM_JOINDATE, jdate); 
  initialValues.put(ROOM_PASS, rpw);
  initialValues.put(ROOM_DESC, desc); 
  initialValues.put(ROOM_MNUM, mn);
  initialValues.put(ROOM_JNUM, jn);  
  return mDb.insert(ROOM_TABLE, null, initialValues);
 } 



음. 원인을 모르니 어떻게 해야할지를 모르겟습니다. 조언 좀 부탁드리겠습니다.!