StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POsqlite3_open error in android
text
Body
copied!<pre><code> public class DataBaseHelper extends SQLiteOpenHelper { private static String DB_NAME; private static String DB_PATH = "/data/data/com.muthu.tamil/databases/"; private final Context myContext; private SQLiteDatabase myDataBase; static { DB_NAME = "aathichudi.db"; } public DataBaseHelper(Context paramContext) { super(paramContext, DB_NAME, null, 1); DB_PATH = "/data/data/" + paramContext.getPackageName() + "/databases/"; this.myContext = paramContext; } private boolean checkDataBase() { return new File(DB_PATH + DB_NAME).exists(); } private void copyDataBase() throws IOException { InputStream localInputStream = this.myContext.getAssets().open(DB_NAME); FileOutputStream localFileOutputStream = new FileOutputStream(DB_PATH + DB_NAME); byte[] arrayOfByte = new byte[1024]; while (true) { int i = localInputStream.read(arrayOfByte); if (i <= 0) { localFileOutputStream.flush(); localFileOutputStream.close(); localInputStream.close(); return; } localFileOutputStream.write(arrayOfByte, 0, i); } } public void createDataBase() throws IOException { if (checkDataBase()) new File(DB_PATH + DB_NAME).delete(); getReadableDatabase(); close(); try { copyDataBase(); return; } catch (IOException localIOException) { } throw new Error("Error copying database"); } public Cursor getData(String paramString) { return this.myDataBase.rawQuery(paramString, null); } public void onCreate(SQLiteDatabase paramSQLiteDatabase) { } public void onUpgrade(SQLiteDatabase paramSQLiteDatabase, int paramInt1, int paramInt2) { } public void openDataBase() throws SQLException { this.myDataBase = SQLiteDatabase.openDatabase(DB_PATH + DB_NAME, null, 1); } </code></pre> <p>i write code for db connection in android but i get ERROE like this:</p> <blockquote> <p>sqlite3_open_v2("/data/data/com.muthu,tamil/databases/aathichudi.db", &handle, 1, NULL) failed sqlite3_open_v2("/data/data/com.muthu,tamil/databases/aathichudi.db", &handle, 1, NULL) failed sqlite returned: error code = 14, msg = cannot open file at source line 25467 sqlite3_open_v2("/data/data//data/data/com.muthu.tamil/files/databases/aathichudi.db", &handle, 1, NULL) failed Shutting down VM threadid=1: thread exiting with uncaught exception (group=0x4001d800) FATAL EXCEPTION: main java.lang.RuntimeException: Unable to start activity ComponentInfo{com.muthu.tamil/com.muthu.tamil.HomeActivity}: android.database.sqlite.SQLiteException: unable to open database file at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679) at android.app.ActivityThread.access$2300(ActivityThread.java:125) at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033) at android.os.Handler.dispatchMessage(Handler.java:99) at android.os.Looper.loop(Looper.java:123) at android.app.ActivityThread.main(ActivityThread.java:4627) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:521) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626) at dalvik.system.NativeStart.main(Native Method) Caused by: android.database.sqlite.SQLiteException: unable to open database file at android.database.sqlite.SQLiteDatabase.dbopen(Native Method) at android.database.sqlite.SQLiteDatabase.(SQLiteDatabase.java:1812) at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:817) at com.muthu.tamil.sql.DataBaseHelper.openDataBase(DataBaseHelper.java:112) at com.muthu.tamil.HomeActivity.onCreate(HomeActivity.java:41) at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047) at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627) ... 11 more</p> </blockquote>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload