Android Content Provider

I want to get all music files titles with content provider, but I get SQL error. Here is the code




package player.org;
import java.io.File;

import java.io.FileFilter;
import java.io.FilenameFilter;
import java.util.ArrayList;


import android.R.id;
import android.app.Activity;
import android.app.ActivityGroup;
import android.app.ListActivity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.provider.MediaStore;
import android.util.Log;
import android.view.View;
import android.view.Window;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.TabHost;

public class AllSongs extends Activity{
static ArrayList<String> listItem;
ArrayAdapter<String> adapter;
private final String mediaPath="./sdcard";
ListView list;
static Intent intent;
static int currentPosition;
static String s;


public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
//p=new Player();
Log.d("allsongs","onCreate");
listItem=new ArrayList<String>();
setContentView(R.layout.list);
adapter=new ArrayAdapter<String>(this,R.layout.list_item,listItem);
list=(ListView)findViewById(R.id.list);
Log.d("ata", "list="+ list);
list.setAdapter(adapter);
list.setTextFilterEnabled(true);
updateSongsList();


public void updateSongsList()
{

String [] colums=new String [] {
MediaStore.Audio.Media._ID,
MediaStore.Audio.Media.DATA
};

Cursor mediaCursor=managedQuery(MediaStore.Audio.Artists.EXTERNAL_CONTENT_URI, null, null,
null, null);
if(mediaCursor.moveToFirst())
{
int artistColum=mediaCursor.getColumnIndex(MediaStore.Audio.Media.DATA);
String name;
do{
name=mediaCursor.getString(artistColum);
listItem.add(name);
} while(mediaCursor.moveToNext());
adapter.notifyDataSetChanged();
}
}


and here is the error

09-03 03:18:29.379: ERROR/CursorWindow(378): Bad request for field slot 0,-1. numRows = 2, numColumns = 5
09-03 03:18:29.379: DEBUG/AndroidRuntime(378): Shutting down VM
(...)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): Caused by: java.lang.IllegalStateException: get field slot from row 0 col -1 failed
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at android.database.CursorWindow.getString_native(Native Method)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at android.database.CursorWindow.getString(CursorWindow.java:329)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:49)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at android.database.CursorWrapper.getString(CursorWrapper.java:135)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at player.org.AllSongs.updateSongsList(AllSongs.java:107)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at player.org.AllSongs.onCreate(AllSongs.java:53)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
09-03 03:18:29.409: ERROR/AndroidRuntime(378): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1611)

 

I just can figure, why error accures?

 

Thanks for reply. I found the problem. I just quering wrong provider, the uri must be MediaStore.Audio.Media. EXTERNAL_CONTENT_URI.