Android Question B4J Standalone Package .exe not working for sqlite projects

[Col]

I can package any B4j project and the resulting .exe runs perfectly.
However, when I have a project that uses sqlite, the resulting packaged .exe simply does nothing. Stepping through the code reveals that the problem is related to the ExecQuery statement.

Here is the Project Attributes section:

#Region  Project Attributes
    #MainFormWidth: 600
    #MainFormHeight: 400
    #AdditionalJar: sqlite-jdbc-3.7.2
#End Region

and this is the code that causes a problem:

    Dim mySQL As String
    Dim MyR As ResultSet
    sql1.InitializeSQLite(File.DirApp, "AddiniumDB.db", True)
    mySQL = "SELECT * FROM tblPage"
    MyR = sql1.ExecQuery(mySQL)

I'm using Java 11. My path configuration is:

If I build the project without the ExecQuery statement, it runs perfectly. Once I include the statement, the standalone project does nothing. However, both cases work fine if I simply compile and run from within the IDE.

I've read through the "Integrated B4JPackager11 - The simple way to distribute standalone UI apps" and the tutorial, but can't find what I need.

Hopefully this is something easy that I've simply overlooked. I have gone through any similar threads, but cannot find the fix I need, although I wouldn't rule out stupidity on my part .

Anyone have any ideas?
Thanks.

 

[Erel]

First step is to run the "run_debug.bat" file and post the logs.

 

[Col]

My db is located in the Temp/Build folder (same folder as the .exe). Is this the wrong location for it?

 

[Erel]

Is this the wrong location for it?

Add Log(File.DirApp) and you will see.

File.DirApp = bin folder.

 

[Col]

Perfect - Thanks Erel.