B4J Question B4J standalone with sqlite

Phil Thompson · Saturday at 2:38 AM

I get this error when trying to compile a stand alone app in B4J
java.lang.RuntimeException: java.io.FileNotFoundException: D:\B4J_Projects\GrimsbyCurling\B4J\Objects\temp\build\bin\TimeClock.db (The system cannot find the file specified)

TimeClock.db is located in the Objects Folder

Both of the options below work fine in debug and release modes.

Option 1
File.Copy(File.DirApp, "TimeClock.db", xui.DefaultFolder, "TimeClock.db")
sql1.InitializeSQLite(xui.DefaultFolder, "TimeClock.db", True)

Option 2
File.Copy(File.DirApp, "TimeClock.db", File.DirData("EventClock"), "TimeClock.db")
sql1.InitializeSQLite(File.DirData("EventClock"), "TimeClock.db", True)

LucaMs · Saturday at 4:25 AM

I don't know why the file is not found, since the project works, but most likely you can solve the problem by moving the file from Object to Files and then copying it with:

B4X:

File.Copy(File.DirAssets, "TimeClock.db", xui.DefaultFolder, "TimeClock.db")

aeric · Saturday at 4:41 AM

How do you run the app?
Have you installed it using the exe?

Phil Thompson · Saturday at 7:02 AM

just compiled an ran the exe

aeric · Saturday at 7:30 AM

Do you set the Data Folder?

B4X:

xui.SetDataFolder("xxx")

Phil Thompson · Saturday at 8:39 AM

LucaMs said:
I don't know why the file is not found, since the project works, but most likely you can solve the problem by moving the file from Object to Files and then copying it with:

B4X:

File.Copy(File.DirAssets, "TimeClock.db", xui.DefaultFolder, "TimeClock.db")

This works as far as the run time is concerned but creates another problem. TimeClock.db is an interactive db and I cannot update it in DirAssets.

On Exit
File.Copy(xui.DefaultFolder, "TimeClock.db", File.DirApp, "TimeClock.db")
Works fine But the Stand Alone Compile fails.

It appears that the compiler is not copying the file from FileDirApp

aeric · Saturday at 8:44 AM

Phil Thompson said:
File.Copy(xui.DefaultFolder, "TimeClock.db", File.DirApp, "TimeClock.db")

You need to understand what the folders mean.

LucaMs · Saturday at 8:59 AM

Why do you need to copy the db on exit? From where to where?

Phil Thompson · Saturday at 10:31 AM

aeric said:
Do you set the Data Folder?

B4X:

xui.SetDataFolder("xxx")

Yes. The app works just fine in debug and release modes
The standalone compiler appears to not copy the db from DirApp

LucaMs said:
Why do you need to copy the db on exit? From where to where?

Just want a hot backup of the DB File

Now Working with

xui.SetDataFolder("EventClock")
If File.Exists(xui.DefaultFolder,"TimeClock.db")=False Then
File.Copy(File.DirApp, "TimeClock.db", xui.DefaultFolder, "TimeClock.db")
End If
sql1.InitializeSQLite(xui.DefaultFolder, "TimeClock.db", True)

and on exit
File.Copy(xui.DefaultFolder, "TimeClock.db", File.DirApp, "TimeClock.db")

JohnJ · Saturday at 12:53 PM

I had the same issue after creating the exe. I solved this by creating a Files folder and coping my sqlite file into it.

B4J Question B4J standalone with sqlite

Phil Thompson

Member

LucaMs

Expert

aeric

Expert

Phil Thompson

Member

aeric

Expert

Phil Thompson

Member

aeric

Expert

LucaMs

Expert

Phil Thompson

Member

JohnJ

Member

Attachments

Similar Threads

B4J Question B4J standalone with sqlite

Member

Expert

Expert

Member

Expert

Member

Expert

Expert

Member

Member

Attachments

Similar Threads

Privacy & Transparency

Privacy & Transparency