Android Question The correct folder for SQLite table?

[Deleted member 103]

Hi,

I have in an app the same SQL error as here.
As Erel writes, or as I understood, one should use "File.DirInternal".
My question: Why is "File.DirDefaultExternal" wrong?

Sub Service_Create
    'This is the program entry point.
    'This is a good place to load resources that are not specific to a single activity.
   
    SQL1.Initialize(File.DirDefaultExternal, "chat.db", True)
    Dim mp As Map = CreateMap("id": "INTEGER", "SenderId": "TEXT", "Title": "TEXT", "Body": "TEXT", "Name": "TEXT", _
                                "User": "INTEGER", "datum": "INTEGER", "Posted": "TEXT", "Received": "TEXT", "indexSender": "INTEGER")
    DBUtils.CreateTable(SQL1, TableName, mp, "id")

Spoiler: Erroe 1 (Android 4.3)

android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:804)
at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:789)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:669)
at anywheresoftware.b4a.sql.SQL.Initialize(SQL.java:37)
at fg.Solitario_free.starter._service_create(starter.java:351)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:525)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:169)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:153)
at fg.Solitario_free.starter.onCreate(starter.java:55)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:2577)
at android.app.ActivityThread.access$1600(ActivityThread.java:141)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1338)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:137)
at android.app.ActivityThread.main(ActivityThread.java:5103)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:525)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:737)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
at dalvik.system.NativeStart.main(Native Method)

Spoiler: Error 2 (Android 4.4)

android.database.sqlite.SQLiteDiskIOException: unknown error (code 10): Could not open database
at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:829)
at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:814)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:709)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:684)
at anywheresoftware.b4a.sql.SQL.Initialize(SQL.java:37)
at fg.Solitario_free.starter._service_create(starter.java:351)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:169)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:153)
at fg.Solitario_free.starter.onCreate(starter.java:55)
at android.app.ActivityThread.handleCreateService(ActivityThread.java:2731)
at android.app.ActivityThread.access$1800(ActivityThread.java:151)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1403)
at android.os.Handler.dispatchMessage(Handler.java:110)
at android.os.Looper.loop(Looper.java:193)
at android.app.ActivityThread.main(ActivityThread.java:5299)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:825)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
at dalvik.system.NativeStart.main(Native Method)

 

[fifiddu70]

Perchè non sono tutti i device compatibili con la dir default external.

 

[DonManfred]

This is the english part of the forum. Please write ENGLISH here!

 

[fifiddu70]

sorry for my mistake, I rewrite the comment in English:
Filippo, Why are not all devices are compatible with the default external dir.

 

[Eme Fibonacci]

A good reason to use DirInternal:

From developer.android.com

"By default, files saved to the internal storage are private to your application and other applications cannot access them (nor can the user)"

 

[Deleted member 103]

Many thanks to all

 

[Deleted member 103]

This is the english part of the forum. Please write ENGLISH here!

 

[DonManfred]

My answer was not meant to you. It was an answer to the one answered in italian or so...

 

[Deleted member 103]

My answer was not meant to you. It was an answer to the one answered in italian or so...

No worries, it's already clear to me.
My answer is to be understood as a joke.

PS. Although I prefer Italian.

 

[KMatle]

Although I prefer Italian

DirInternal uses the internal (native) language, too

 

[Deleted member 103]

DirInternal uses the internal (native) language, too

But with me is always German, why?

 

[KMatle]

But with me is always German, why?

Please open a new thread for this and take a look at your parent's beginners guide for Italian guys (I assume they used the German edition. See chapter 5: "...la versione originale del testo è in tedesco...)