how can i access the Sqlite database on real android device using DDMS in eclipse juno

Question

I have a project that can store data to sqlite database. I want to know how can i access the sqlite database inside on real device using eclipse juno on DDMS?

Answer 1

You don't have permission to open database from real device. You need rooted device to do it. But If you want to check database on real device, you can copy it to external drive and then you can access it.

public static void copyDatabaseToSdCard(Context myContext) {

    try {
        File f1 = new File("/data/data/" + myContext.getPackageName() + "/databases/" + myContext.getResources().getString(R.string.db_name));
        if (f1.exists()) {
            File f2 = new File(Environment.getExternalStorageDirectory().getAbsoluteFile() + "/xyz.db");
            f2.createNewFile();
            InputStream in = new FileInputStream(f1);
            OutputStream out = new FileOutputStream(f2);
            byte[] buf = new byte[1024];
            int len;
            while ((len = in.read(buf)) > 0) {
                out.write(buf, 0, len);
            }
            in.close();
            out.close();
        }
    } catch (FileNotFoundException ex) {
        System.out.println(ex.getMessage() + "in the specified directory.");
        System.exit(0);
    } catch (IOException e) {
        e.printStackTrace();
        System.out.println(e.getMessage());
    }

}