使用SQLiteDatabase创建库时出现异常，百撕不得骑姐

z18437338 2014-01-02 01:52:33



//得到SD卡路径

private final static String DATABASE_PATH = android.os.Environment.getExternalStorageDirectory().getAbsolutePath()

	 + "/com/cn21/account/public";

//数据库名

private final static String DATABASE_FILENAME = "account.db3";

public class AccountDBHelper{

       private static SQLiteDatabase initDatabase(){

         String databaseFilename = DATABASE_PATH + "/" + DATABASE_FILENAME;

	 File dir = new File(DATABASE_PATH);

	 if(!dir.exists())

	     dir.mkdir();

	 SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(databaseFilename, null);

	 db.execSQL(sql_user);

	 return db;

       }

}

执行到“openOrCreateDatabase”时就会出错：



01-02 13:29:17.601: E/SQLiteDatabase(2258): Failed to open database '/storage/emulated/0/com/cn21/account/public/account.db3'.

01-02 13:29:17.601: E/SQLiteDatabase(2258): android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:339)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:236)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:515)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:207)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:178)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:891)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:859)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:696)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:1249)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:1238)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:236)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at com.cn21.account.lib.db.AccountDBHelper.initDatabase(AccountDBHelper.java:114)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at com.cn21.account.lib.db.AccountDBHelper.getCache(AccountDBHelper.java:73)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at com.cn21.account.lib.ui.LoginActivity.onCreate(LoginActivity.java:71)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.Activity.performCreate(Activity.java:5372)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1104)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2270)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2362)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.ActivityThread.access$700(ActivityThread.java:168)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1329)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.os.Handler.dispatchMessage(Handler.java:99)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.os.Looper.loop(Looper.java:137)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at android.app.ActivityThread.main(ActivityThread.java:5493)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at java.lang.reflect.Method.invokeNative(Native Method)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at java.lang.reflect.Method.invoke(Method.java:525)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1209)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1025)

01-02 13:29:17.601: E/SQLiteDatabase(2258): 	at dalvik.system.NativeStart.main(Native Method)