无法从CursorWindow读取第1行,第-1列的数据。确保在访问其中的数据之前正确初始化游标。

8
我正在实现一个ExpandableListView,每个组都会显示其子元素,每个子元素都有自己的持续时间,并且组会显示所有子元素持续时间的总和。
然而,当我点击一个子元素时,它会显示以下错误:
“Couldn't read row 1, col -1 from CursorWindow. Make sure the Cursor is initialized correctly before accessing data from it.”
我没有调用setOnChildClickListener方法。即使我调用了该方法,当我单击子元素时,它也不会停在该元素上,因为断点没有被触发。
这就是问题所在,我找不到错误出在哪里,因为堆栈跟踪没有指向我的项目类,而是指向Android本地类。我已经尝试在代码的每个部分中设置断点,但是当我单击子元素时,没有任何断点被触发。
顺便说一下,我正在使用ViewHolder模式来处理视图,适配器是CursorTreeAdapter。
以下是我的代码 - 完整的堆栈跟踪在末尾:
public class MyClass extends ExpandableListActivity
{
    private Cursor mContactsCursor;
    private ExpandableListView mExpandableListView;

    private Integer mContactId;

    public void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);

        requestWindowFeature(Window.FEATURE_NO_TITLE);

        setContentView(R.layout.contacts_layout);   

        mExpandableListView.setOnGroupClickListener(new OnGroupClickListener() 
        {
            @Override
            public boolean onGroupClick(ExpandableListView parent, View v, int groupPosition, long id) 
            {
                mContactId = Integer.parseInt(v.getTag(R.id.contact_name).toString());
                return false;
            }
        });
    }

    @Override
    public void onResume()
    {
        super.onResume();
        mContactsCursor = mController.getContacts();
        mExpandableListView.setAdapter(new ContactsExpandableListAdapter(mContactsCursor, this));
    }

    @Override
    public void onPause()
    {
        super.onPause();
        if(!mContactsCursor.isClosed())
            mContactsCursor.close();
    }

    @Override
    public void onDestroy()
    {
        super.onDestroy();
        if(!mContactsCursor.isClosed())
            mContactsCursor.close();
    }

    public class ContactsExpandableListAdapter extends CursorTreeAdapter
    {
        private TextView mContactNameTextView, mContactNumberTextView, mDurationTextView;

        public ContactsExpandableListAdapter(Cursor cursor, Context context) 
        {
            super(cursor, context);
        }

        @Override
        protected Cursor getChildrenCursor(Cursor groupCursor) 
        {
            return mController.getContactById(mContactId);
        }

        @Override
        protected View newGroupView(Context context, Cursor cursor, boolean isExpanded, ViewGroup viewGroup) 
        {
            View view = LayoutInflater.from(context).inflate(R.layout.listitem_contacts, viewGroup, false);

                ViewHolder viewHolder = new ViewHolder();

                viewHolder.contactName = (TextView) view.findViewById(R.id.contact_name);
                viewHolder.duration = (TextView) view.findViewById(R.id.duration);
                viewHolder.groupIndicator = (ImageView) view.findViewById(R.id.indicator_icon);

viewHolder.contactName.setText(cursor.getString(cursor.getColumnIndex("contact_name")));

                // Set the duration to the view
                viewHolder.duration.setText(cursor.getString(cursor.getColumnIndex("duration_sum")));

                // Set the tags to the view to be used later when the user click the group view.
                // These tags are the contact number, contact id and the the view holder object
                // to be retrieved when binding the group view
                view.setTag(R.id.contact_number, cursor.getString(cursor.getColumnIndex("contact_number")));
                view.setTag(R.id.rlt_main, viewHolder);
                view.setTag(R.id.contact_name, cursor.getString(cursor.getColumnIndex("contact_id")));
            }

            return view;
        }

        @Override
        protected View newChildView(Context context, Cursor cursor, boolean isLastChild, ViewGroup viewGroup) 
        {
            View view = LayoutInflater.from(context).inflate(R.layout.listitem_contacts, viewGroup, false);

                    mContactNumberTextView = (TextView) view.findViewById(R.id.phone_number);
                    mContactNumberTextView.setText(cursor.getString(cursor.getColumnIndex("contact_name")));

                mDurationTextView = (TextView) view.findViewById(R.id.duration);
                mDurationTextView.setText(cursor.getString(cursor.getColumnIndex("duration")));

                view.setTag(cursor.getString(cursor.getColumnIndex("contact_number")));

            return view;
        }

        @Override
        protected void bindGroupView(View view, Context context, Cursor cursor, boolean isExpanded) 
        {
                ViewHolder viewHolder = (ViewHolder) view.getTag(R.id.rlt_main);

                // For each view created, make a query to the database based on the contact id.
                // This is not very wise to do, but will probably be changed in the future.
                Integer contactId = cursor.getInt(cursor.getColumnIndex("contact_id"));

                // Check if the current contact id is equal to -1. If yes it means the contact

                Cursor currentContactCursor = mFilterByContactController.getContactById(contactId); 

                // Check if the cursor being retrieved from the database based on the current view cursor
                // is major than zero. If yes, it means it has children, so set the indicator icon to this
                // view as visible. If not, set the indicator for this view as gone.
                if(currentContactCursor != null && currentContactCursor.getCount() > 0)
                {
                    viewHolder.groupIndicator.setVisibility(View.VISIBLE);
                    viewHolder.groupIndicator.setImageResource(isExpanded ? R.drawable.expander_ic_maximized : R.drawable.expander_ic_minimized);
                }
                else
                {
                    viewHolder.groupIndicator.setVisibility(View.GONE);
                }

                if(cursor.getString(cursor.getColumnIndex("contact_name")) == null)
                    viewHolder.contactName.setText(cursor.getString(cursor.getColumnIndex("contact_number")));
                else
                    viewHolder.contactName.setText(cursor.getString(cursor.getColumnIndex("contact_name")));

                // Set the duration to the view
                viewHolder.duration.setText(Utils.convertTime(Integer.parseInt(cursor.getString(cursor.getColumnIndex("duration_sum")))));

                // Set the tags to the view to be used later when the user click the group view
                view.setTag(R.id.contact_number, cursor.getString(cursor.getColumnIndex("contact_number")));
                view.setTag(R.id.contact_name, cursor.getString(cursor.getColumnIndex("contact_id")));

                if(!currentContactCursor.isClosed())
                    currentContactCursor.close();
            }
        }

        @Override
        protected void bindChildView(View view, Context context, Cursor cursor, boolean expanded) 
        {
            try
            {
                    if(cursor.getString(cursor.getColumnIndex("contact_name")) == null)
                    {
                        mContactNameTextView = (TextView) view.findViewById(R.id.contact_name);
                        mContactNameTextView.setText(cursor.getString(cursor.getColumnIndex("phone_number")));
                    }
                    else
                    {
                        mContactNumberTextView = (TextView) view.findViewById(R.id.phone_number);
                        mContactNumberTextView.setText(cursor.getString(cursor.getColumnIndex("contact_number")));
                    }

                    mDurationTextView = (TextView) view.findViewById(R.id.duration);
                    mDurationTextView.setText(cursor.getString(cursor.getColumnIndex("duration")));

            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
            finally
            {
                if(cursor.isClosed())
                    cursor.close();
            }
        }
    }

完整堆栈跟踪

07-22 16:47:46.388: E/AndroidRuntime(7718): java.lang.IllegalStateException: Couldn t read row 1, col -1 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it. 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.database.CursorWindow.nativeGetLong(Native Method) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.database.CursorWindow.getLong(CursorWindow.java:515) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.database.AbstractWindowedCursor.getLong(AbstractWindowedCursor.java:75)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.widget.CursorTreeAdapter$MyCursorHelper.getId(CursorTreeAdapter.java:436)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.widget.CursorTreeAdapter.getChildId(CursorTreeAdapter.java:173)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.widget.ExpandableListConnector.getItemId(ExpandableListConnector.java:427)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.widget.AdapterView.getItemIdAtPosition(AdapterView.java:756)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.widget.AdapterView.setSelectedPositionInt(AdapterView.java:1128)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.widget.AbsListView.onTouchEvent(AbsListView.java:3147) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.View.dispatchTouchEvent(View.java:5541)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:1951)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:1712) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:1957)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:1726) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:1957)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:1726) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:1957)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:1726) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTransformedTouchEvent(ViewGroup.java:1957)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewGroup.dispatchTouchEvent(ViewGroup.java:1726)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at com.android.internal.policy.impl.PhoneWindow$DecorView.superDispatchTouchEvent(PhoneWindow.java:1912)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at com.android.internal.policy.impl.PhoneWindow.superDispatchTouchEvent(PhoneWindow.java:1371)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.app.Activity.dispatchTouchEvent(Activity.java:2364) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at com.android.internal.policy.impl.PhoneWindow$DecorView.dispatchTouchEvent(PhoneWindow.java:1860)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.View.dispatchPointerEvent(View.java:5721)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewRootImpl.deliverPointerEvent(ViewRootImpl.java:2890)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewRootImpl.handleMessage(ViewRootImpl.java:2466)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewRootImpl.processInputEvents(ViewRootImpl.java:845)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.view.ViewRootImpl.handleMessage(ViewRootImpl.java:2475) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.os.Handler.dispatchMessage(Handler.java:99) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at android.os.Looper.loop(Looper.java:137) 07-22 16:47:46.388: E/AndroidRuntime(7718):  at android.app.ActivityThread.main(ActivityThread.java:4424)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at java.lang.reflect.Method.invokeNative(Native Method)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at java.lang.reflect.Method.invoke(Method.java:511) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
07-22 16:47:46.388: E/AndroidRuntime(7718):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) 
07-22 16:47:46.388: E/AndroidRuntime(7718):     at dalvik.system.NativeStart.main(Native Method)

1
只是出于好奇,你能否发布完整的logcat? - Sam
从格式上看,newGroupView()、newChildView()和bindGroupView()中缺少了一些内容,我猜测可能是某个if(..) {没有被复制... - Sam
3
你是否在寻找行标识符(例如BaseColumns#_ID),但在游标中未找到?你在mContactsCursor中使用了哪些列 - 你没有忘记行id吧? - Jens
3个回答

8

正如@Jens在评论中提到的:

它是否正在查找行标识符(即BaseColumns#_ID),并且在光标中找不到它?您在mContactsCursor中使用哪些列 - 您是否忘记了该行的ID?

在所有查询中,必须指定列_id。这就是导致错误的原因,在我将列_id添加到查询中之后,它就运行成功了。


2

即使我们有 _ID,也可能会出现此错误。如果在查询中给出了错误的 field_name 或在意图或任何其他地方使用了 field_name,则会发生这种情况。


0

如果您使用ContentProvider进行查询,需要将_id至少添加到PROJECTION中。


网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接