文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >在活动中单击“后退”按钮时，从来没有显式地在数据库上调用close()。

问在活动中单击“后退”按钮时，从来没有显式地在数据库上调用close()。
EN

Stack Overflow用户
提问于 2012-09-05 20:02:55
回答 2查看 188关注 0票数 1

我在产品搜索应用程序中得到了这个错误，它没有崩溃，但是当我在模拟器中单击“后退”按钮(从项目的详细信息-- "DetaljiProizvoda.java“活动返回)(也就是当这个错误出现在Logcat中时)时，显然出现了与数据库有关的问题，我在values.put中添加的一些新条目在搜索时似乎没有出现，其他的则出现在searh结果中。

代码语言：javascript
复制
09-05 21:01:23.082: W/IInputConnectionWrapper(758): showStatusIcon on inactive InputConnection
09-05 21:01:48.901: I/dalvikvm(813): threadid=3: reacting to signal 3
09-05 21:01:48.951: I/dalvikvm(813): Wrote stack traces to '/data/anr/traces.txt'
09-05 21:01:49.401: I/dalvikvm(813): threadid=3: reacting to signal 3
09-05 21:01:49.451: I/dalvikvm(813): Wrote stack traces to '/data/anr/traces.txt'
09-05 21:01:49.741: D/gralloc_goldfish(813): Emulator without GPU emulation detected.
09-05 21:01:49.901: I/dalvikvm(813): threadid=3: reacting to signal 3
09-05 21:01:49.951: I/dalvikvm(813): Wrote stack traces to '/data/anr/traces.txt'
09-05 21:02:06.762: I/dalvikvm(813): threadid=3: reacting to signal 3
09-05 21:02:06.781: I/dalvikvm(813): Wrote stack traces to '/data/anr/traces.txt'
09-05 21:02:28.111: D/dalvikvm(813): GC_CONCURRENT freed 143K, 3% free 9386K/9671K, paused 8ms+31ms
09-05 21:02:28.122: E/SQLiteDatabase(813): close() was never explicitly called on database '/data/data/hr.punctum.LociranjePonudaProizvoda/databases/proizvodidb' 
09-05 21:02:28.122: E/SQLiteDatabase(813): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1007)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:770)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at hr.punctum.LociranjePonudaProizvoda.DetaljiProizvoda.onCreate(DetaljiProizvoda.java:24)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.Activity.performCreate(Activity.java:4465)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.ActivityThread.access$600(ActivityThread.java:123)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.os.Handler.dispatchMessage(Handler.java:99)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.os.Looper.loop(Looper.java:137)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at android.app.ActivityThread.main(ActivityThread.java:4424)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at java.lang.reflect.Method.invokeNative(Native Method)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at java.lang.reflect.Method.invoke(Method.java:511)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
09-05 21:02:28.122: E/SQLiteDatabase(813):  at dalvik.system.NativeStart.main(Native Method)
09-05 21:02:28.202: E/System(813): Uncaught exception thrown by finalizer
09-05 21:02:28.332: E/System(813): java.lang.IllegalStateException: Don't have database lock!
09-05 21:02:28.332: E/System(813):  at android.database.sqlite.SQLiteDatabase.verifyLockOwner(SQLiteDatabase.java:2090)
09-05 21:02:28.332: E/System(813):  at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2182)
09-05 21:02:28.332: E/System(813):  at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2178)
09-05 21:02:28.332: E/System(813):  at android.util.LruCache.trimToSize(LruCache.java:197)
09-05 21:02:28.332: E/System(813):  at android.util.LruCache.evictAll(LruCache.java:285)
09-05 21:02:28.332: E/System(813):  at android.database.sqlite.SQLiteDatabase.deallocCachedSqlStatements(SQLiteDatabase.java:2143)
09-05 21:02:28.332: E/System(813):  at android.database.sqlite.SQLiteDatabase.closeClosable(SQLiteDatabase.java:1126)
09-05 21:02:28.332: E/System(813):  at android.database.sqlite.SQLiteDatabase.finalize(SQLiteDatabase.java:1914)
09-05 21:02:28.332: E/System(813):  at java.lang.Daemons$FinalizerDaemon.doFinalize(Daemons.java:182)
09-05 21:02:28.332: E/System(813):  at java.lang.Daemons$FinalizerDaemon.run(Daemons.java:168)
09-05 21:02:28.332: E/System(813):  at java.lang.Thread.run(Thread.java:856)
09-05 21:02:28.511: E/SQLiteDatabase(813): close() was never explicitly called on database '/data/data/hr.punctum.LociranjePonudaProizvoda/databases/proizvodidb' 
09-05 21:02:28.511: E/SQLiteDatabase(813): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1007)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:770)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at hr.punctum.LociranjePonudaProizvoda.DetaljiProizvoda.onCreate(DetaljiProizvoda.java:24)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.Activity.performCreate(Activity.java:4465)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.ActivityThread.access$600(ActivityThread.java:123)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.os.Handler.dispatchMessage(Handler.java:99)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.os.Looper.loop(Looper.java:137)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at android.app.ActivityThread.main(ActivityThread.java:4424)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at java.lang.reflect.Method.invokeNative(Native Method)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at java.lang.reflect.Method.invoke(Method.java:511)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
09-05 21:02:28.511: E/SQLiteDatabase(813):  at dalvik.system.NativeStart.main(Native Method)
09-05 21:02:28.552: E/System(813): Uncaught exception thrown by finalizer
09-05 21:02:28.601: E/System(813): java.lang.IllegalStateException: Don't have database lock!
09-05 21:02:28.601: E/System(813):  at android.database.sqlite.SQLiteDatabase.verifyLockOwner(SQLiteDatabase.java:2090)
09-05 21:02:28.601: E/System(813):  at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2182)
09-05 21:02:28.601: E/System(813):  at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2178)
09-05 21:02:28.601: E/System(813):  at android.util.LruCache.trimToSize(LruCache.java:197)
09-05 21:02:28.601: E/System(813):  at android.util.LruCache.evictAll(LruCache.java:285)
09-05 21:02:28.601: E/System(813):  at android.database.sqlite.SQLiteDatabase.deallocCachedSqlStatements(SQLiteDatabase.java:2143)
09-05 21:02:28.601: E/System(813):  at android.database.sqlite.SQLiteDatabase.closeClosable(SQLiteDatabase.java:1126)
09-05 21:02:28.601: E/System(813):  at android.database.sqlite.SQLiteDatabase.finalize(SQLiteDatabase.java:1914)
09-05 21:02:28.601: E/System(813):  at java.lang.Daemons$FinalizerDaemon.doFinalize(Daemons.java:182)
09-05 21:02:28.601: E/System(813):  at java.lang.Daemons$FinalizerDaemon.run(Daemons.java:168)
09-05 21:02:28.601: E/System(813):  at java.lang.Thread.run(Thread.java:856)

DatabaseHelper.java

代码语言：javascript
复制
package hr.punctum.LociranjePonudaProizvoda;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {

    public static final String DATABASE_NAME = "proizvodidb";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        /*
         * Kreiranje tabele proizvodi i punjenje tabele sa podacima.
         * Kasnije cu prebaciti ove hardcore kodirane statment-e u XML datoteku.
         */
        String sql = "CREATE TABLE IF NOT EXISTS proizvodi (" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT, " + 
                        "naziv TEXT, " +
                        "tvrtka TEXT, " +
                        "cijena TEXT, " +
                        "kategorija TEXT, " +
                        "telefonTvrtke TEXT, " +
                        "adresaTvrtke TEXT)";
        db.execSQL(sql);

        ContentValues values = new ContentValues();

        values.put("naziv", "Canon 60D");
        values.put("tvrtka", "Protis");
        values.put("cijena", "4600");
        values.put("kategorija", "fotoaparati");
        values.put("telefonTvrtke", "016587176");
        values.put("adresaTvrtke", "Laducka 36A");
        db.insert("proizvodi", "tvrtka", values);

        values.put("naziv", "Nikon D800");
        values.put("tvrtka", "MagazinRS");
        values.put("cijena", "21600");
        values.put("kategorija", "fotoaparati");
        values.put("telefonTvrtke", "454562542");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);   

        values.put("naziv", "Olympus OM-D");
        values.put("tvrtka", "Telebit");
        values.put("cijena", "5200");
        values.put("kategorija", "fotoaparati");
        values.put("telefonTvrtke", "5657676");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);

        values.put("naziv", "Pentax K-7");
        values.put("tvrtka", "Svijet medija");
        values.put("cijena", "7400");
        values.put("kategorija", "fotoaparati");
        values.put("telefonTvrtke", "11236676");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);

        values.put("naziv", "Samsung S3");
        values.put("tvrtka", "Svijet medija");
        values.put("cijena", "4200");
        values.put("kategorija", "mobiteli");
        values.put("telefonTvrtke", "7814442222");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);

        values.put("naziv", "Samsung S2");
        values.put("tvrtka", "Svijet medija");
        values.put("cijena", "3200");
        values.put("kategorija", "mobiteli");
        values.put("telefonTvrtke", "7814442222");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);

        values.put("naziv", "Huawei U8650");
        values.put("tvrtka", "MagazinRS");
        values.put("cijena", "3200");
        values.put("kategorija", "mobiteli");
        values.put("telefonTvrtke", "7814442222");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);

        values.put("naziv", "Huawei U8660");
        values.put("tvrtka", "MagazinRS");
        values.put("cijena", "3200");
        values.put("kategorija", "mobiteli");
        values.put("telefonTvrtke", "7814442222");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);

        values.put("naziv", "Huawei U8660");
        values.put("tvrtka", "MagazinRS");
        values.put("cijena", "3400");
        values.put("kategorija", "mobiteli");
        values.put("telefonTvrtke", "7814442222");
        values.put("adresaTvrtke", "Laniste 1B");       
        db.insert("proizvodi", "tvrtka", values);

        //db.close();   
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS proizvodi");
        onCreate(db);
    }

}

ListaProizvoda.java

代码语言：javascript
复制
package hr.punctum.LociranjePonudaProizvoda;

import android.app.ListActivity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

public class ListaProizvoda extends ListActivity {

    protected EditText searchText;
    protected SQLiteDatabase db;
    protected Cursor cursor;
    protected ListAdapter adapter;


    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        db = (new DatabaseHelper(this)).getWritableDatabase();
        searchText = (EditText) findViewById (R.id.searchText);

    }    

    @SuppressWarnings("deprecation")
    public void search(View view) {
        // || je operacija spajanja u SQLiteu, slijedeci sql query vraca rezultat iz baze svih zapisa koji pocinju na slovo uneseno u search polje
        cursor = db.rawQuery("SELECT _id, naziv, tvrtka, cijena FROM proizvodi WHERE naziv LIKE ?", 
                        new String[]{searchText.getText().toString() + "%"}); 
        adapter = new SimpleCursorAdapter(this,R.layout.proizvodi_list_artikl,cursor,new String[] {"naziv", "tvrtka", "cijena"},new int[] {R.id.naziv, R.id.tvrtka, R.id.cijena});
        setListAdapter(adapter);    

    }

    public void onListItemClick(ListView parent, View view, int position, long id) {
        //kreiranje Intenta za komunikaciju s drugim activity-om
        Intent intent = new Intent(this, DetaljiProizvoda.class);
        Cursor cursor = (Cursor) adapter.getItem(position);
        //slanje varijable
        intent.putExtra("PROIZVODI_ID", cursor.getInt(cursor.getColumnIndex("_id")));
        startActivity(intent);
    }

}

DetaljiProizvoda.java

代码语言：javascript
复制
package hr.punctum.LociranjePonudaProizvoda;

import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.TextView;

public class DetaljiProizvoda extends Activity {

    protected TextView naziv;
    protected TextView kategorija;
    protected TextView tvrtka;
    protected TextView telefonTvrtke;
    protected TextView adresaTvrtke;
    protected int proizvodId;

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.detalji_proizvoda);
        //hvatanje parametra (ID iz tablice) Intenta iz ListaProizvoda activity-a
        proizvodId = getIntent().getIntExtra("PROIZVODI_ID", 0);
        SQLiteDatabase db = (new DatabaseHelper(this)).getWritableDatabase();
        Cursor cursor = db.rawQuery("SELECT proizv._id, proizv.naziv, proizv.tvrtka, proizv.cijena, proizv.kategorija, proizv.telefonTvrtke, proizv.adresaTvrtke FROM proizvodi proizv LEFT OUTER JOIN proizvodi mgr ON proizv._id = mgr._id WHERE proizv._id = ?", 
                new String[]{""+proizvodId});

        if (cursor.getCount() == 1)
        {
            cursor.moveToFirst();

            naziv = (TextView) findViewById(R.id.naziv);
            naziv.setText(cursor.getString(cursor.getColumnIndex("naziv"))); /*+ " " + cursor.getString(cursor.getColumnIndex("lastName")));*/

            kategorija = (TextView) findViewById(R.id.kategorija);
            kategorija.setText(cursor.getString(cursor.getColumnIndex("kategorija")));

            tvrtka = (TextView) findViewById(R.id.tvrtka);
            tvrtka.setText(cursor.getString(cursor.getColumnIndex("tvrtka")));

            telefonTvrtke = (TextView) findViewById(R.id.telefonTvrtke);
            telefonTvrtke.setText(cursor.getString(cursor.getColumnIndex("telefonTvrtke")));

            adresaTvrtke = (TextView) findViewById(R.id.adresaTvrtke);
            adresaTvrtke.setText(cursor.getString(cursor.getColumnIndex("adresaTvrtke")));

        }

    }

}
android
database
EN

回答 2

Stack Overflow用户

回答已采纳

发布于 2012-09-05 20:05:34

只需在cursors中关闭您的db和onDestroy()，以停止“数据库从未关闭”消息：

代码语言：javascript
复制
@Override
protected void onDestroy() {
    cursor.close();
    db.close();
    super.onDestroy();
}

此外，此方法中的id已经引用了适当的行：

代码语言：javascript
复制
public void onListItemClick(ListView parent, View view, int position, long id) {
    //kreiranje Intenta za komunikaciju s drugim activity-om
    Intent intent = new Intent(this, DetaljiProizvoda.class);
    //slanje varijable 
    intent.putExtra("PROIZVODI_ID", id);
    startActivity(intent);
}

我希望这能帮上忙！

从注释中添加

我也错过了您在DetaljiProizvoda中打开数据库的情况，基本上，当您完成调用getWritableDatabase()时，您需要调用close()的任何地方。您可以像ListaProizvoda一样设置ListaProizvoda(通过将db和cursor声明为类变量并复制onDestroy()方法)。但是，因为您只读取了一次数据库，所以只需将其添加到onCreate()的底部( DetaljiProizvoda中)

代码语言：javascript
复制
cursor.close();
db.close();

你问：

这些方法(onResume和onDestroy)不是已经在每个活动中实现了吗？

是的，这就是为什么我们在使用@Override和super时使用类的原因。在我们的例子中，@Override告诉编译器使用我们的onCreate()、onDestroy()等版本，如果我们想调用父类的版本，我们使用super关键字。您不需要覆盖大多数父方法。您不需要覆盖Activity的onCreate()，但是如果没有onCreate()代码，这个应用程序就不会有什么效果。

票数 1
EN

Stack Overflow用户

发布于 2012-09-05 20:09:05

代码语言：javascript
复制
@SuppressWarnings("deprecation")
public void search(View view) {
    // || je operacija spajanja u SQLiteu, slijedeci sql query vraca rezultat iz baze svih zapisa koji pocinju na slovo uneseno u search polje
    cursor = db.rawQuery("SELECT _id, naziv, tvrtka, cijena FROM proizvodi WHERE naziv LIKE ?", 
            new String[]{searchText.getText().toString() + "%"}); 
    adapter = new SimpleCursorAdapter(this,R.layout.proizvodi_list_artikl,cursor,new String[] {"naziv", "tvrtka", "cijena"},new int[] {R.id.naziv, R.id.tvrtka, R.id.cijena});
    setListAdapter(adapter);
    cursor.close();  // Add this line
    db.close(); // And this line as well

}
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/12288908

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档