您的位置: 首页  >  技术问答  >  SQLite openOrCreateDatabase未知错误（代码14）：无法打开数据库

SQLite openOrCreateDatabase未知错误（代码14）：无法打开数据库

分类: 技术问答 • 2022-04-02 14:49:27

SQLite openOrCreateDatabase未知错误（代码14）：无法打开数据库

问题描述：

我正在尝试学习android的sqlite。 我创建了一个Helper类，它应该打开我的数据库并执行任何帮助类。SQLite openOrCreateDatabase未知错误（代码14）：无法打开数据库

我的问题是，我甚至无法打开此错误的数据库淡然：

android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database

这是我的DatabaseHelper类的相关代码，错误是在openOrCreateDatabase行：

public class DatabaseHelper<T> implements IDatabaseHelper{ 
private static final String DATABASE_NAME = "myDatabase.db"; 
private static String DATABASE_PATH = ""; 
private static final int DATABASE_VERSION = 1; 
private static SQLiteDatabase database; 
private static Context ctx; 

//constructor 
public DatabaseHelper(Context context){ 
    ctx = context; 
    DATABASE_PATH = ctx.getFilesDir().getPath(); 
} 

//apertura database 
public boolean OpenDB() { 
    //try{ 
    database = SQLiteDatabase.openOrCreateDatabase(DATABASE_NAME, null, null); 
    return true; 
    }

这是所有试图捕获sorrounded，但问题仍然是，它无法打开我的数据库。这里是堆栈跟踪。

11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase: Failed to open database 'myDatabase.db'. 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:806) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:791) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at 
android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:717) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at personal.pier.weightwatcher.Utils.DatabaseHelper.OpenDB(DatabaseHelper.java:85) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at personal.pier.weightwatcher.Activities.SplashScreenActivity.onCreate(SplashScreenActivity.java:22) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.app.Activity.performCreate(Activity.java:5990) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1106) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2311) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2420) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.app.ActivityThread.access$900(ActivityThread.java:154) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1321) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.os.Handler.dispatchMessage(Handler.java:102) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.os.Looper.loop(Looper.java:135) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at android.app.ActivityThread.main(ActivityThread.java:5292) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at java.lang.reflect.Method.invoke(Native Method) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at java.lang.reflect.Method.invoke(Method.java:372) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:904) 
11-05 17:27:35.410 16641-16641/? E/SQLiteDatabase:  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:699) 
11-05 17:27:35.410 16641-16641/? D/AndroidRuntime: Shutting down VM 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime: FATAL EXCEPTION: main 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime: Process: personal.pier.weightwatcher, PID: 16641 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime: java.lang.RuntimeException: Unable to start activity ComponentInfo{personal.pier.weightwatcher/personal.pier.weightwatcher.Activities.SplashScreenActivity}: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2358) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2420) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.access$900(ActivityThread.java:154) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1321) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.os.Handler.dispatchMessage(Handler.java:102) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.os.Looper.loop(Looper.java:135) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.main(ActivityThread.java:5292) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at java.lang.reflect.Method.invoke(Native Method) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at java.lang.reflect.Method.invoke(Method.java:372) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:904) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:699) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime: Caused by: android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:806) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:791) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:717) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at personal.pier.weightwatcher.Utils.DatabaseHelper.OpenDB(DatabaseHelper.java:85) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at personal.pier.weightwatcher.Activities.SplashScreenActivity.onCreate(SplashScreenActivity.java:22) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.Activity.performCreate(Activity.java:5990) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1106) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2311) 
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2420)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.access$900(ActivityThread.java:154)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1321)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.os.Handler.dispatchMessage(Handler.java:102)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.os.Looper.loop(Looper.java:135)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at android.app.ActivityThread.main(ActivityThread.java:5292)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at java.lang.reflect.Method.invoke(Native Method)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at java.lang.reflect.Method.invoke(Method.java:372)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:904)  
11-05 17:27:35.411 16641-16641/? E/AndroidRuntime:  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:699) 

我真的找不到解决方案。任何帮助将不胜感激。谢谢你的建议

PS：我没有在porpouse上扩展SQLiteOpenHelper，因为我想对操作进行更多的控制，因为我试图对所有的类只使用一个帮助器。

+1

给它一个完整的路径在文件系统中的 – pskink

+0

@pskink感谢回复，我应该怎么做？ getfilesdir（）。getpath（）是不够的？ –

+0

你用'DATABASE_NAME'调用'openOrCreateDatabase'，它只是“myDatabase.db”，而不是像“/full/path/to/my/database.db”这样的东西 – pskink

答

调用SQLiteDatabase.openOrCreateDatabase当第一个参数（String path）应该是文件系统的完整路径，从getFilesDir()或类似的呼吁使

答

你应该在DatabaseHelper的构造函数上调用super。

//constructor 
public DatabaseHelper(Context context){ 
    super(context, DATABASE_NAME, null, DATABASE_VERSION); 
    ctx = context; 
    DATABASE_PATH = ctx.getFilesDir().getPath(); 
}
+0

感谢您快速回复，我收到错误，我应该添加一些东西给我的班级使用超级？我得到“Object（）在对象中不能应用” –

+0

我想你应该扩展SQLiteOpenHelper，看到这个例子：[link]（http://alvinalexander.com/java/jwarehouse/android/packages/SettingsProvider/src/com /android/providers/settings/DatabaseHelper.java.shtml） – Alisson

+0

nope，我在最后写到“PS”中，我不想扩展SQLiteOpenHelper，因为我想为我的所有实体使用一个帮助类，所以我需要更多的控制。来自@pskink的评论解决了这个问题，当我编写代码时，我只是在睡觉。无论如何感谢您的答案！ :) –

相关推荐