Android Question SQL Error

StarinschiAndrei · Sunday at 6:54 AM

Hi everyone,
I turn back to my previous post https://www.b4x.com/android/forum/threads/sql-error.162490/#post-996940 regarding the sql db error. Now i try to test my app on samsung j5 ( Android 7) the problem is the same. The code below works perfect on Andoris 13 but on Android 7 db is renamed by OS (i think) as a corrupt.

B4X:

Private Sub B4XPage_Created (Root1 As B4XView)
    Root = Root1
    Root.LoadLayout("MainPage")
    MP=B4XPages.MainPage
    Log(File.Exists(xui.DefaultFolder, "pos.db"))
        For Each flist As String In File.ListFiles(xui.DefaultFolder)
            Log("FileName: " & flist &" FileSize : "&File.Size(xui.DefaultFolder,flist))
        Next

Log(xui.DefaultFolder)  
    If File.Exists(xui.DefaultFolder, "pos.db") = False Then
        File.Copy(File.DirAssets, "pos.db", xui.DefaultFolder, "pos.db")
        Log(File.Exists(xui.DefaultFolder, "pos.db"))
    End If
   
    CHECK_TABEL
    SQL1.Initialize(xui.DefaultFolder,"pos.db",True)

here is the log
true
FileName: virtual_assetsFileSize : 4096
FileName: pos.db FileSize : 0
FileName: pos.db.corrupt FileSize : 303104
/data/user/0/POS.app/files
Can anybody tell me how can i solve this issue ?
Thank you

Erel · Sunday at 7:41 AM

StarinschiAndrei said:
but on Android 7 db is renamed by OS (i think) as a corrupt

I never encountered such case.

Tip: if you are always starting with an existing db then better to set the last parameter in SQL.Initialize to False. You don't want to create a new db.

What happens if you overwrite the existing file - comment line 11?

How did you create the db file? With the default journal mode - WAL, the db consists of 3 files.

StarinschiAndrei · Sunday at 7:57 AM

Erel said:
I never encountered such case.

Tip: if you are always starting with an existing db then better to set the last parameter in SQL.Initialize to False. You don't want to create a new db.

What happens if you overwrite the existing file - comment line 11?

How did you create the db file? With the default journal mode - WAL, the db consists of 3 files.

db was created with sqlite studio
I changed the parameter to false
i made a test , first i deleted all pos.* file, than i copied again
here is the code

here is the log
true
FileName: virtual_assets FileSize : 4096
FileName: pos.db FileSize : 303104
/data/user/0/POS.app/files
FileName: virtual_assets FileSize : 4096
FileName: pos.db FileSize : 303104
true
Error occurred on line: 84 (B4XMainPage)
android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 1294): Could not open database
#################################################################
Error Code : 1294 (SQLITE_CANTOPEN_ENOENT)
Caused By : Specified directory or database file does not exist.
(unknown error (code 1294): Could not open database)
#################################################################
at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:242)
at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:203)
at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:518)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:209)
at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:181)
at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:1167)
at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:1115)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:832)
at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:807)
at anywheresoftware.b4a.sql.SQL.Initialize(SQL.java:44)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:777)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:354)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:157)

Erel · Sunday at 8:15 AM

My guess is that the desktop tool uses a newer version of SQLite which isn't supported by Android 7.

StarinschiAndrei · Sunday at 8:19 AM

Erel said:
My guess is that the desktop tool uses a newer version of SQLite which isn't supported by Android 7.

I use an old version 3.2.1., do you think that if i create the db programmatically will solve the problem ?
Thank you

Gianni M · Sunday at 8:25 AM

StarinschiAndrei said:
do you think that if i create the db programmatically will solve the problem ?

I always create from code

StarinschiAndrei · Sunday at 8:38 AM

giannimaione said:
I always create from code

Thank you, i will try

Erel · Sunday at 9:03 AM

You can also use B4J to create the db. The version included with B4J works with all Android versions.

Android Question SQL Error

StarinschiAndrei

Active Member

Erel

B4X founder

StarinschiAndrei

Active Member

Erel

B4X founder

StarinschiAndrei

Active Member

Gianni M

Well-Known Member

StarinschiAndrei

Active Member

Erel

B4X founder

Similar Threads

Android Question SQL Error

Active Member

B4X founder

Active Member

B4X founder

Active Member

Well-Known Member

Active Member

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency