B4J Question B4J standalone with sqlite

[Phil Thompson]

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]

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:

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

 

[aeric]

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

 

[Phil Thompson]

just compiled an ran the exe

 

[aeric]

Do you set the Data Folder?

xui.SetDataFolder("xxx")

 

[Phil Thompson]

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:

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]

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

You need to understand what the folders mean.

 

[LucaMs]

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

 

[Phil Thompson]

Do you set the Data Folder?

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

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]

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