Java – How to clear Mediastore before setting a ringtone

When I set the ringtone from my app, it works fine once, but when I run the code again, it tries to create duplicate entries in the media storage, which creates problems. Without creating a separate unique filename for each sound file, I want to solve this problem.

I found this solution in the answer here: setting audio file as Ringtone
I’m trying to use it to fix my problem.

When I try it in the code below, I get two errors. One is SQLiteException, and the other is a RuntimeException caused by a squlite error after the Java code.

String TAG = "CFFS";

File dir = new File(Environment.getExternalStorageDirectory()+ "/ringtones");  Set base DIR where new ringtone will live
    dir.mkdirs();  create if directors don't exist

File outputFile = new File(dir, "College Fight Song.mp3");  Define out new output file

Uri inURI = null;
    try {
        inURI = Uri.parse(getIntent().getStringExtra("com.carboni.fightsongs.FILE_RES_ID"));
    } catch (Exception e) {
        e.printStackTrace();
        Log.e(TAG, "Could not get URI " + e);
    }

 If we didn't parse a good URI then don't execute the code below
    if (inURI != null) {
        InputStream in = null;
         Get the input stream
        try { in = new BufferedInputStream(this.getContentResolver().openInputStream(inURI));           }
        catch (Exception e) { Log.e(TAG, "Exception getting input stream " + e); }

 Get the output stream
        OutputStream out = null;
        try { out = new FileOutputStream(outputFile); } 
        catch (Exception e) { Log.e(TAG, "Exception getting output stream " + e); }

 Again, if we don't have 2 good handles then don't try to read/write them
        if ((in != null) && (out != null)) {

byte[] buf = new byte[1024];  Define our buffer size
            int bytesRead = 0;
            while (bytesRead >= 0) {
                try {
                    bytesRead = in.read(buf, 0, buf.length);  Read max of 1024 bytes
                    if (bytesRead > 0)
                        out.write(buf);  Write buffer to new file if we got a good read
                } catch (Exception e) {
                    Log.e(TAG,"Exception reading " + e);
                    e.printStackTrace();
                }                   
            }
        }
         Close out handles and proceed
        try {
            in.close();
            out.close();
        }
        catch (Exception e) { Log.e(TAG, "Exception closing streams " + e); }

ContentValues v = new ContentValues();
        v.put(MediaStore.MediaColumns.DATA, outputFile.getAbsolutePath());
        v.put(MediaStore.MediaColumns.TITLE, "College Football Fight Song");
        v.put(MediaStore.MediaColumns.SIZE, outputFile.length());
        v.put(MediaStore.MediaColumns.MIME_TYPE, "audio/mp3");
        v.put(MediaStore.Audio.Media.IS_RINGTONE, true);

Uri pURI = MediaStore.Audio.Media.getContentUriForPath(outputFile.getAbsolutePath());

 remove entry every time so we don't get duplicate entries and have a problem setting a 2nd time
        getContentResolver().delete(pURI, MediaStore.MediaColumns.DATA + "\"" + outputFile.getAbsolutePath() + "\"", null);

Uri nURI = this.getContentResolver().insert(pURI, v);

Log.i(TAG, "Setting ringtone URI to " + nURI);

 Set ringtone
        RingtoneManager.setActualDefaultRingtoneUri(this, RingtoneManager.TYPE_RINGTONE, nURI);
        Toast.makeText(this, "Ringtone set", Toast.LENGTH_LONG).show();

Error:

09-03 14:16:08.343: ERROR/DatabaseUtils(11968): android.database.sqlite.SQLiteException: near ""/mnt/sdcard/ringtones/College Fight Song.mp3"": syntax error: , while compiling: DELETE FROM audio_meta WHERE _data"/mnt/sdcard/ringtones/College Fight Song.mp3"

It looks like the error is this line:

getContentResolver().delete(pURI, MediaStore.MediaColumns.DATA + "\"" + outputFile.getAbsolutePath() + "=\"", null);