B4J Question B4j Sqlite missing write permission?

DonManfred

Expert

Licensed User

Longtime User

• Mar 2, 2021

• #2

run the debug.bat and look for any error

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 2, 2021

• #3

If I run the bat file this in itself says "file not found":

C:\WINDOWS\system32>cd bin
Das System kann den angegebenen Pfad nicht finden.

C:\WINDOWS\system32>java.exe @release_java_modules.txt -m b4j/b4j.andromedar.main
Fehler: Hauptklasse @release_java_modules.txt konnte nicht gefunden oder geladen werden

C:\WINDOWS\system32>pause
Drücken Sie eine beliebige Taste . . .

Click to expand...

I think the problem is related to the rather complicated permissions of Windows 10. I may move the dbase to some other location but since I would like to produce a package, it is difficult to find a hard coded path that fits all users.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Mar 2, 2021

• #4

Why are you running it from Windows\system32? This is not the correct place to put apps.

gezueb said:

I may move the dbase to some other location but since I would like to produce a package, it is difficult to find a hard coded path that fits all users.

Click to expand...

Not at all.

Use XUI.DefaultFolder.

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 2, 2021

• #5

Erel, I am not running the app from windows\system32. I guess the cmd.exe runs from there that executes the bat file.
I did what you recommended and planted my database into the default uix folder.
But the symptoms are still the same: The app works perfectly when run from the b4j IDE, it fails to add to the SQL database when run as a package, regardless of administrator rights.
One of the statements that does not work is the one here:

B4X:

                SQL1.ExecNonQuery2("INSERT INTO Kurse VALUES (?,?,?)",Array As Object(Nr,price,Heute))

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Mar 2, 2021

• #6

if you run something from cmd; make sure you are on the right drive and folder when executing something.
D:+ENTER to change to drive D in this example
CD \my\path\on\drive_D\

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 2, 2021

• #7

I think we are barking up the wrong tree. I just followed your advice to run the run_debug.bat and that seems to finally call the cmd console. But that is not my main problem, I just dont know why there's a difference in executing a b4j app either from the IDE or as a packed .exe.

 

Upvote 0

KMatle

Expert

Licensed User

Longtime User

• Mar 2, 2021

• #8

Ok, let's start from the beginning:

1. You've created a standalone UI package via "project -> Build standalone package"? (yes/no)
2. You click on the generated *.exe file inside the generated build folder (yes/no)
3. What is the exact path of the generated build folder?
4. Is the development root folder (where your source code is) different from the build folder? Did you move the build folder? (I assume yes)
5. What is the exact path & filename of the database? "SQLite.InitializeSQLite(...)"
6. Could an antivir-sw prevent the start?

PS: I have some B4J apps in production on WIN10 and WIN2016 Server machines without any problems...

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 2, 2021

• #9

1. yes
2. yes (also as a link, but no difference in behaviour)
3. the path to the .exe is a subfolder of the development root folder. /object/temp/build
4. No. And the build folder is not moved. The root folder is in my documents, so I have full read/write/delete access on it.
5 the path is as recommended by erel the uix default folder (for me: C:\Users\Georg\AppData\Roaming\Boerse
6. No. The funny thing is that it starts alright, reads tables but simple does not insert anything - no exception, no error message. Obviously, I cannot log anything when run as a package- It behaves like (silent) write protect.

 

Upvote 0

KMatle

Expert

Licensed User

Longtime User

• Mar 3, 2021

• #10

Strange. Can you try a SQLite example from the forum? (like my "millions of rows" example). Does it work? Before: Can you write simple files to that folder? Should be the same as SQlite is a simple file. Maybe your Insert statements are faulty.

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 3, 2021

• #11

Yes, I can write a simple file into the said path. There's a backup function in my app that makes a copy of the database and this works okay.
What I will try is convert the SQL statements into the async form and WAIT FOR the results before proceding. Maybe there's the snag that the
packaged version is faster than the compiled one.
However, today I am out so I will let you know about the results tomorrow.
Thanks to you all for your advice,
Georg

 

Upvote 0

KMatle

Expert

Licensed User

Longtime User

• Mar 3, 2021

• #12

I assume it's just an issue with your insert statements. I had this once or twice resulting in no error but no rows inserted either.

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 3, 2021

• #13

It was me that was barking up the wrong tree, sorry my friends! My suspicion is now that the preceding Httpjob fails only when executed as package, returning no results. Thus, its not the insert into the SGQlite thats wrong. I will keep you informed when I found out the problem with the Htttpjob. Anyway, thanks to you all and so long, Georg

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 4, 2021

• #14

The culprit is indeed the Httpjob and not the following sql insert:

B4X:

        Dim job As HttpJob
        job.Initialize("",Me)
        Dim price,price As Double
        job.Download(RS.GetString("SearchFor"))
        Wait For (job) JobDone(job As HttpJob)
        If Not(job.Success) Then
            Dim message As String
            message = job.ErrorMessage
            MsgBox.Show("httpjob failed"&message,"")
        End If

Fails with the following message:
javax.net.ssl.protokollexception connection reset

but only as package, not when compiled in the IDE. So SQLite is working as advertised! I will come back to you all when I found out what cause this.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Mar 4, 2021

• #15

This line might help:

B4X:

#PackagerProperty: IncludedModules = jdk.crypto.ec

 

Upvote 0

gezueb

Active Member

Licensed User

Longtime User

• Mar 4, 2021

• #16

Indeed, Erel, this helps!
???
Now it works like a charm. Thanks to you and KMatle and DonManfred!

 

Upvote 0