B4J Question StandAlone packager error

[pipocas]

Hello, i've a problem creating a standalone code.

module-info.java:9: error: package java.sql is not visible
uses java.sql.Driver;
         ^
  (package java.sql is declared in module java.sql, but module b4j does not read it)
1 error

in main, i have this jars

#AdditionalJar: jmetro-11.6.16.jar
#AdditionalJar: mariadb-java-client-3.1.4.jar
#AdditionalJar: itext-2.1.7.js1
#AdditionalJar: mysql-connector-java-5.1.40-bin.jar

any tips ?
TIA

 

[OliverA]

According to @Johan Schoeman's post (https://www.b4x.com/android/forum/threads/error-building-standalone-package.135329/post-856043), looks like you have to add

#PackagerProperty: IncludedModules = javafx.controls

 

[pipocas]

Hello.
Thank you for your help.
I've seen @Johan Schoeman's post, but in my case, it was caused by the

#AdditionalJar: jmetro-11.

Solution was to add :

#PackagerProperty: IncludedModules = java.sql

I am now with this directives to B4jPackager

#AdditionalJar: jmetro-11
#AdditionalJar: mariadb-java-client-3.1.4.jar
#AdditionalJar: itext-2.1.7.js1
#AdditionalJar: mysql-connector-java-5.1.40-bin.jar

#PackagerProperty: IconFile = ..\Files\formicon.ico
#PackagerProperty: ExeName = Questionarios
#PackagerProperty: IncludedModules = javafx.web
#PackagerProperty: IncludedModules = java.sql
#PackagerProperty: IncludedModules = javafx.swing
#PackagerProperty: AdditionalModuleInfoString = exports impl.jfxtras.styles.jmetro;

I can now create the executable file and run it, but now new problem as arised :

dbutils._executemap (java line: -1)
java.sql.SQLException: Type java.lang.String not supported type
        at b4j/org.mariadb.jdbc.BasePreparedStatement.setInternalObject(Unknown Source)
        at b4j/org.mariadb.jdbc.BasePreparedStatement.setObject(Unknown Source)
        at b4j/anywheresoftware.b4j.objects.SQL.ExecQuery2(Unknown Source)
        at b4j/com.inforpires.inqueritos.dbutils._executemap(Unknown Source)
        at b4j/com.inforpires.inqueritos.utils._login(Unknown Source)
        at b4j/com.inforpires.inqueritos.main._appstart(Unknown Source)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.base/java.lang.reflect.Method.invoke(Unknown Source)
        at b4j/anywheresoftware.b4a.BA.raiseEvent2(Unknown Source)
        at b4j/anywheresoftware.b4a.BA.raiseEvent(Unknown Source)
        at b4j/com.inforpires.inqueritos.main.start(Unknown Source)
        at javafx.graphics/com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$9(Unknown Source)
        at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runAndWait$12(Unknown Source)
        at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runLater$10(Unknown Source)
        at java.base/java.security.AccessController.doPrivileged(Native Method)
        at javafx.graphics/com.sun.javafx.application.PlatformImpl.lambda$runLater$11(Unknown Source)
        at javafx.graphics/com.sun.glass.ui.InvokeLaterDispatcher$Future.run(Unknown Source)
        at javafx.graphics/com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
        at javafx.graphics/com.sun.glass.ui.win.WinApplication.lambda$runLoop$3(Unknown Source)
        at java.base/java.lang.Thread.run(Unknown Source)

App runs fine from the IDE. Any tips on this new error ?

 

[Erel]

The error doesn't look related to the packager.

 

[pipocas]

Nope. Packager builds exe fine.
But if i run the app from the IDE, all ok. If i run the executable directly, i get this error.

 

[Erel]

I see it too. It has something with the way it loads the codecs.

Use this version for now: https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client/2.7.10