public void setAccntData(){
		Cursor mCursor = mDbHelper.fetchAccountsInfo();
		Log.i("fetchAccountsInfo.getCount()",Integer.toString(mCursor.getCount()));
		int len = mCursor.getCount();
                arrAccntItem = new ArrayList<AccntItem>();
               AccntItem ai;
               try{
                     for(int i=0;i<len;i++){
                          Log.i(TAG, "_id : " + mCursor.getString(mCursor.getColumnIndex("_id")));
                          Log.i(TAG, "ACCNT_NAME : " + mCursor.getString(mCursor.getColumnIndex("ACCNT_NAME")));
                          Log.i(TAG, "DIFF_ACCNT : " + mCursor.getString(mCursor.getColumnIndex("DIFF_ACCNT")));
                          Log.i(TAG, "END_MONTH : " + mCursor.getString(mCursor.getColumnIndex("END_MONTH")));
                          Log.i(TAG, "END_DAY : " + mCursor.getString(mCursor.getColumnIndex("END_DAY"))); 
                          Log.i(TAG, "CHARGE_DATE : " + mCursor.getString(mCursor.getColumnIndex("CHARGE_DATE"))); 
                          
Log.i(TAG, "SETTING_YN : " + mCursor.getString(mCursor.getColumnIndex("SETTING_YN"))); 

                         int accnt_id 		= mCursor.getInt(mCursor.getColumnIndex("_id")); 
                         String accnt_name 	= mCursor.getString(mCursor.getColumnIndex("ACCNT_NAME")); 
                         int diff_accnt 		= mCursor.getInt(mCursor.getColumnIndex("DIFF_ACCNT")); 
                        int end_month		= mCursor.getInt(mCursor.getColumnIndex("END_MONTH")); 
                        int end_day		    = mCursor.getInt(mCursor.getColumnIndex("END_DAY"));
                        String charge_date  = mCursor.getString(mCursor.getColumnIndex("CHARGE_DATE"));
                        ai = new AccntItem(accnt_id,   accnt_name, diff_accnt,end_month, end_day,charge_date);
                       arrAccntItem.add(ai);
                        mCursor.moveToNext();
         	}
          }catch(Exception e){
               Log.e(TAG, "AccntItem Error(setAccntData) "+e.toString());
        }
        mCursor.close();
}

빨간색으로 나와있는부분부터 로그에 찍히지 않습니다....


03-07 10:42:03.190: I/fetchAccountsInfo.getCount()(1004): 4

03-07 10:42:03.190: I/AccountBookWrite(1004): _id : 4

03-07 10:42:03.190: I/AccountBookWrite(1004): ACCNT_NAME : woori check

03-07 10:42:03.203: I/AccountBookWrite(1004): DIFF_ACCNT : 1

03-07 10:42:03.211: E/CursorWindow(1004): Bad request for field slot 0,-1. numRows = 4, numColumns = 10

03-07 10:42:03.211: E/AccountBookWrite(1004): AccntItem Error(setAccntData) java.lang.IllegalStateException: get field slot from row 0 col -1 failed


db에서 sql을 테스트했을때는 아무 문제가 없는데... 이런에러가 뜹니다....
왜 그런지 아시는분 조언부탁드립니다...

이 게시물을