logo标签列表

java.lang.IllegalStateException: 因为当前没有事务，无法执行此操作。

androidexceptionandroid-asynctasktransactionsconnection
3

我创建了一个AsyncTask类，在其中编写了以下部分（onPreExecute和doInBackground方法）：

@Override
protected void onPreExecute() {
    // Instantiate ProgressDialog and Set style to STYLE_HORIZONTAL
    dialog = new ProgressDialog(context);
    dialog.setIndeterminate(false);
    dialog.setMax(100);
    dialog.setProgressStyle(ProgressDialog.STYLE_HORIZONTAL);
    dialog.setCancelable(false);
    dialog.setTitle("Update");
    dialog.setMessage("Download data. Please wait...");
    dialog.show();

    super.onPreExecute();
}

@Override
protected String doInBackground(String... urls) {
    int count = 0;
    int numUsers = 0;
    db = new Database(context);
    SQLiteDatabase localDB = db.getWritableDatabase();

    try {   
        JSONArray UserJsonArray = connectAndCreateJsonArray(urls[0]);

        numUsers = UserJsonArray.length();

        localDB.beginTransaction();

        for (int i = 0; i < numUsers; i++) {
            JSONObject jObj = (JSONObject) UserJsonArray.getJSONObject(i);

            localDB.insert("Users", null, getParsedUserEntry(jObj));

            count++;
            publishProgress(count * 100 / numUsers);
        }

        localDB.setTransactionSuccessful();

    } catch (IllegalStateException e) {
        e.printStackTrace();                
    } catch (JSONException e) {
        e.printStackTrace();
        Log.e("Msg", "catch");
    } finally {
        localDB.endTransaction();
    }

    return numUsers+"";
}

private JSONArray connectAndCreateJsonArray(String url) {
    JSONArray jsonArray = new JSONArray();

    HttpClient client = new DefaultHttpClient();
    HttpGet request = new HttpGet("http://www.example.com/file.json");
    request.addHeader("Cache-Control", "no-cache");

    try {
        HttpResponse response = client.execute(request);
        HttpEntity entity = response.getEntity();
        InputStreamReader in = new InputStreamReader(entity.getContent());
        BufferedReader reader = new BufferedReader(in);
        StringBuilder stringBuilder = new StringBuilder();
        String line = "";

        while ((line=reader.readLine()) != null) {
            stringBuilder.append(line);
        }

        jsonArray = new JSONArray(stringBuilder.toString());

    } catch (SocketTimeoutException e) {
        e.printStackTrace();
    } catch (SocketException e) {
        e.printStackTrace();
    } catch (IllegalStateException e) {
        e.printStackTrace();                
    } catch (ClientProtocolException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    } catch (JSONException e) {
        e.printStackTrace();
    }

    return jsonArray;
}

我之前一直工作正常，但今天在修改其他类并安装了Android SDK Manager中的两个包后，它停止工作了。 （我安装了Android SDK Build-Tools v20和Android SDK Tools到版本23.0.5）。

现在我收到以下错误： java.lang.IllegalStateException: Cannot perform this operation because there is no current transaction

这是我的LogCat：

10-13 02:11:36.700: E/AndroidRuntime(31210): FATAL EXCEPTION: AsyncTask #1
10-13 02:11:36.700: E/AndroidRuntime(31210): Process: com.example.myapp, PID: 31210
10-13 02:11:36.700: E/AndroidRuntime(31210): java.lang.RuntimeException: An error occured while executing doInBackground()
10-13 02:11:36.700: E/AndroidRuntime(31210):    at android.os.AsyncTask$3.done(AsyncTask.java:300)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:355)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at java.util.concurrent.FutureTask.setException(FutureTask.java:222)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at java.util.concurrent.FutureTask.run(FutureTask.java:242)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:231)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at java.lang.Thread.run(Thread.java:841)
10-13 02:11:36.700: E/AndroidRuntime(31210): Caused by: java.lang.IllegalStateException: Cannot perform this operation because there is no current transaction.
10-13 02:11:36.700: E/AndroidRuntime(31210):    at android.database.sqlite.SQLiteSession.throwIfNoTransaction(SQLiteSession.java:915)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at android.database.sqlite.SQLiteSession.endTransaction(SQLiteSession.java:398)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at android.database.sqlite.SQLiteDatabase.endTransaction(SQLiteDatabase.java:522)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at com.example.myapp.DownloadDataFromServer.doInBackground(DownloadDataFromServer.java:114)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at com.example.myapp.DownloadDataFromServer.doInBackground(DownloadDataFromServer.java:1)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at android.os.AsyncTask$2.call(AsyncTask.java:288)
10-13 02:11:36.700: E/AndroidRuntime(31210):    at java.util.concurrent.FutureTask.run(FutureTask.java:237)
10-13 02:11:36.700: E/AndroidRuntime(31210):    ... 4 more
10-13 02:11:37.765: E/WindowManager(31210): android.view.WindowLeaked: Activity com.example.myapp.Main has leaked window com.android.internal.policy.impl.PhoneWindow$DecorView{420f12e8 V.E..... R....... 0,0-480,322} that was originally added here
10-13 02:11:37.765: E/WindowManager(31210):     at android.view.ViewRootImpl.<init>(ViewRootImpl.java:346)
10-13 02:11:37.765: E/WindowManager(31210):     at android.view.WindowManagerGlobal.addView(WindowManagerGlobal.java:248)
10-13 02:11:37.765: E/WindowManager(31210):     at android.view.WindowManagerImpl.addView(WindowManagerImpl.java:69)
10-13 02:11:37.765: E/WindowManager(31210):     at android.app.Dialog.show(Dialog.java:286)
10-13 02:11:37.765: E/WindowManager(31210):     at com.example.myapp.DownloadDataFromServer.onPreExecute(DownloadDataFromServer.java:49)
10-13 02:11:37.765: E/WindowManager(31210):     at android.os.AsyncTask.executeOnExecutor(AsyncTask.java:587)
10-13 02:11:37.765: E/WindowManager(31210):     at android.os.AsyncTask.execute(AsyncTask.java:535)
10-13 02:11:37.765: E/WindowManager(31210):     at com.example.myapp.Main.onOptionsItemSelected(Main.java:151)
10-13 02:11:37.765: E/WindowManager(31210):     at android.app.Activity.onMenuItemSelected(Activity.java:2600)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.policy.impl.PhoneWindow.onMenuItemSelected(PhoneWindow.java:1065)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.view.menu.MenuBuilder.dispatchMenuItemSelected(MenuBuilder.java:741)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.view.menu.MenuItemImpl.invoke(MenuItemImpl.java:152)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:884)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:874)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.view.menu.MenuPopupHelper.onItemClick(MenuPopupHelper.java:177)
10-13 02:11:37.765: E/WindowManager(31210):     at android.widget.AdapterView.performItemClick(AdapterView.java:298)
10-13 02:11:37.765: E/WindowManager(31210):     at android.widget.AbsListView.performItemClick(AbsListView.java:1113)
10-13 02:11:37.765: E/WindowManager(31210):     at android.widget.AbsListView$PerformClick.run(AbsListView.java:2911)
10-13 02:11:37.765: E/WindowManager(31210):     at android.widget.AbsListView$3.run(AbsListView.java:3645)
10-13 02:11:37.765: E/WindowManager(31210):     at android.os.Handler.handleCallback(Handler.java:733)
10-13 02:11:37.765: E/WindowManager(31210):     at android.os.Handler.dispatchMessage(Handler.java:95)
10-13 02:11:37.765: E/WindowManager(31210):     at android.os.Looper.loop(Looper.java:136)
10-13 02:11:37.765: E/WindowManager(31210):     at android.app.ActivityThread.main(ActivityThread.java:5146)
10-13 02:11:37.765: E/WindowManager(31210):     at java.lang.reflect.Method.invokeNative(Native Method)
10-13 02:11:37.765: E/WindowManager(31210):     at java.lang.reflect.Method.invoke(Method.java:515)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:732)
10-13 02:11:37.765: E/WindowManager(31210):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:566)
10-13 02:11:37.765: E/WindowManager(31210):     at dalvik.system.NativeStart.main(Native Method)

在第 49 行有这样一段代码：

dialog.show();

在线114上有这样一段内容：

localDB.endTransaction();

这很奇怪...可能是什么问题呢？谢谢。

4个回答
5

关于什么？

try{
  ...
} catch (Exception e) { // everything else
    e.printStackTrace();
} finally {
    if(localDB != null && localDB.inTransation()){
         localDB.endTransaction();
    }
}

你是否考虑过将 "finally" 语句块移到另一个 try 块内部？
3

在执行beginTransaction之前，可能会遇到异常。将finally移到另一个try块内。

try {   
    JSONArray UserJsonArray = connectAndCreateJsonArray(urls[0]);
    numUsers = UserJsonArray.length();
    if (numUsers < 1) return numUsers + "";
    try {  
        localDB.beginTransaction();          
        for (int i = 0; i < numUsers; i++) {
            JSONObject jObj = (JSONObject) UserJsonArray.getJSONObject(i);
            localDB.insert("Users", null, getParsedUserEntry(jObj));
           count++;
           publishProgress(count * 100 / numUsers);
        }
        localDB.setTransactionSuccessful();
    } catch (IllegalStateException e) {
        e.printStackTrace();                
    } catch (JSONException e) {
        e.printStackTrace();
        Log.e("Msg", "catch");
    } catch (Exception e) { // everything else
        e.printStackTrace();
    } finally {
        localDB.endTransaction();
    }
} catch (Exception e) { // everything else
    e.printStackTrace();
}
这个修复了异常，但现在没有任何内容被写入本地数据库。numUsers始终为0。 - smartmouse
1
@smartmouse 你看到任何堆栈跟踪吗...请仔细检查你的 connectAndCreateJsonArray。 - ashoke
@smartmouse，这个问题是在connectAndCreateJsonArray函数中还是与DB/illegalStateException有关？如果是与illegal state exception有关，请更新此问题，如果是其他问题，请创建一个新问题并提供详细信息，我可以进行检查。 - ashoke
我更新了我的问题，希望你能找到解决方案。 - smartmouse
这里是带有 Log.e 行的 connectAndCreateJsonArray http://pastebin.com/htztN8mq，这里是 LogCat http://pastebin.com/iHVffnJr（println 错误不像其他时候那样显示为红色） - smartmouse
显示剩余5条评论
1
我遇到了和你一样的错误，这是我的代码：

try {
    String sql = "SELECT * FROM "+DB_TABLEDOWNLOAD;
    Cursor cursor = db.rawQuery(sql, null);
    //空双引号为原表没有的字段
    String temp = "";
    int existIconPath = cursor.getColumnIndex("iconPath");
    int existAudioID = cursor.getColumnIndex("audioID");

    if (existIconPath == -1 && existAudioID == -1){
        temp = "url, downed,total,path,name, audioTitle, audioFileID,\"\",\"\"";
    }else if (existIconPath == -1 && existAudioID != -1){//iconPath不存在
        temp = "url, downed,total,path,name, audioTitle, audioFileID,\"\",audioID";
    }else if (existIconPath != -1 && existAudioID == -1){//audioID不存在
        temp = "url, downed,total,path,name, audioTitle, audioFileID,iconPath,\"\"";
    }else {
        return;
    }

    db.beginTransaction();
    String tempTableName = "_temp_"+DB_TABLEDOWNLOAD;
    String sqlCreateTemp = " ALTER TABLE "+DB_TABLEDOWNLOAD+" RENAME TO "+tempTableName+";";
     db.execSQL(sqlCreateTemp);

     final String TB_TESTPAPERINFO_CREATE = "Create  TABLE IF NOT EXISTS " 
                  + DB_TABLEDOWNLOAD
                  + "(url TEXT, downed TEXT,total TEXT,path TEXT,name TEXT, audioTitle TEXT, audioFileID TEXT,iconPath TEXT, audioID TEXT);";
     db.execSQL(TB_TESTPAPERINFO_CREATE);

     String sqlBackupData = "INSERT INTO "+DB_TABLEDOWNLOAD+" SELECT "+temp+" FROM "+tempTableName+";";
     db.execSQL(sqlBackupData);
     String sqlDrop = "DROP TABLE IF EXISTS '"+tempTableName+"';";
     db.execSQL(sqlDrop);
     db.setTransactionSuccessful();
} catch (Exception e) {
    e.printStackTrace();
}finally{
    db.endTransaction();
}

在db.beginTransaction()之前我使用了return，我的代码在beginTransaction之前就返回了，但我在finally中使用了endTransaction。如果你不执行beginTransaction和endTransaction，会出现异常。

所以请检查一下你的代码关于db.beginTransaction和endTransaction的部分。希望这能帮到你。 - doordoor
1
在你的代码中，如果在 localDB.beginTransaction(); 之前发生异常，则事务不会被打开，由于在 finally 块中你尝试关闭它，会抛出一个 IllegalStateException 异常（事务未开始）。请替换以下代码：
try {   
    JSONArray UserJsonArray = connectAndCreateJsonArray(urls[0]);
    numUsers = UserJsonArray.length();

    localDB.beginTransaction();

    for (int i = 0; i < numUsers; i++) {
        JSONObject jObj = (JSONObject) UserJsonArray.getJSONObject(i);
        localDB.insert("Users", null, getParsedUserEntry(jObj));
        count++;
        publishProgress(count * 100 / numUsers);
    }

    localDB.setTransactionSuccessful();
} catch (IllegalStateException e) {
    e.printStackTrace();                
} catch (JSONException e) {
     e.printStackTrace();
    Log.e("Msg", "catch");
} finally {
    localDB.endTransaction();
}

关于这段代码：

JSONArray UserJsonArray = connectAndCreateJsonArray(urls[0]);
numUsers = UserJsonArray.length();

localDB.beginTransaction();

try {   
    for (int i = 0; i < numUsers; i++) {
        JSONObject jObj = (JSONObject) UserJsonArray.getJSONObject(i);
        localDB.insert("Users", null, getParsedUserEntry(jObj));
        count++;
        publishProgress(count * 100 / numUsers);
    }

    localDB.setTransactionSuccessful();
} catch (IllegalStateException e) {
    e.printStackTrace();                
} catch (JSONException e) {
     e.printStackTrace();
    Log.e("Msg", "catch");
} finally {
    localDB.endTransaction();
}

如果必要的话，前两行可以用独立的try-catch包裹起来。
网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接