B4J Question B4JPackager11 JTDS Charset Problem

[Johan Schoeman]

Is there any solution for.....

java.sql.SQLException: Could not find a Java charset equivalent to DB charset Cp1252

.....when making use of #AdditionalJar: jtds-1.3.1 and compiling the B4J project to a standalone package?

Running the B4J app from the IDE is working perfectly but cannot get the standalone exe to run
Have tried adding various charset's to the Initialize string but it always fails - tried UTF-8, ISO-8859-1, Cp1252

eg:

    SQL1.Initialize("net.sourceforge.jtds.jdbc.Driver","jdbc:jtds:sqlserver://xx.x.xxx.xx:1433/Syspro_Live_xxx_x;integratedSecurity=true;useNTLMv2=true;charset=UTF-8;")

Have searched the forum but cannot find a solution. Really don't want to switch to a Microsoft driver

 

[Erel]

Have you tried to copy the resource file after the package is built (https://www.b4x.com/android/forum/threads/b4jpackager11-jtds-charset-issue.117368/post-734203) ?

If it works then you can automate it.

 

[Johan Schoeman]

Yes Erel - have tried that. Got the folder in two places:
1. in the parent folder of the project

2. In the bin folder of the project:

No joy with it....

 

[Erel]

Add this code at the beginning of the program:

Dim jo As JavaObject
jo.InitializeStatic("net.sourceforge.jtds.util.Logger").RunMethod("setActive", Array(True))

Build a package and run it with run_debug.bat.
A file named log.out will be created in the bin folder. Please upload it. Also post the full logs from the console window.

 

[Johan Schoeman]

Hello Erel

This is what I get:

C:\Users\johans\Documents\B4JApps\connectSyspro\connectSyspro\Objects\temp\build\bin>java.exe @release_java_modules.txt  -m b4j/b4j.example.main
main._button1_click (java line: -1)
java.sql.SQLException: Could not find a Java charset equivalent to DB charset Cp1252.
        at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.loadCharset(Unknown Source)
        at b4j/net.sourceforge.jtds.jdbc.JtdsConnection.<init>(Unknown Source)
        at b4j/net.sourceforge.jtds.jdbc.Driver.connect(Unknown Source)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at b4j/anywheresoftware.b4j.objects.SQL.Initialize2(Unknown Source)
        at b4j/anywheresoftware.b4j.objects.SQL.Initialize(Unknown Source)
        at b4j/b4j.example.main._button1_click(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$1.run(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)


C:\Users\johans\Documents\B4JApps\connectSyspro\connectSyspro\Objects\temp\build\bin>pause
Press any key to continue . . .

Log.out is as follows:

Can't load Charsets.properties
TdsSocket: Max buffer memory used = 0KB

 

[Erel]

Can't load Charsets.properties

This is the cause of the error and it means that the file (Charsets.properties) is not in the correct place.

 

[netsistemas]

I don't think it can be solved, that's why I used the Microsoft driver for B4J and the JTDS for B4A Good luck and tell us if you get it.

 

[EnriqueGonzalez]

I agree with netsistemas. Best way to go is change to the official library

JTDS Driver: Could not find a Java charset equivalent to collation 2C04D01000

Looking a solution for strange JTDS error message: Could not find a Java charset equivalent to collation 2C04D01000. I tried to pass file.encoding and user.encoding parameters without any success.

stackoverflow.com

 

[Erel]

I'm pretty sure that it can be solved. I'm installing SQL Server 2019 and will test it.

 

[Erel]

jtds jdbc driver with standalone package

1. Download the attached zip. Put the jar file in the additional libraries folder and Charsets.properties in your project folder. 2. jtds-1.3.1-a.jar replaces jtds-1.3.1.jar. #AdditionalJar: jtds-1.3.1-a #CustomBuildAction: After Packager, %WINDIR%\System32\robocopy.exe, ..\ temp\build\bin\...

www.b4x.com

 

[Johan Schoeman]

I don't think it can be solved, that's why I used the Microsoft driver for B4J and the JTDS for B4A Good luck and tell us if you get it.

The answer is here and it is working 100%

jtds jdbc driver with standalone package

1. Download the attached zip. Put the jar file in the additional libraries folder and Charsets.properties in your project folder. 2. jtds-1.3.1-a.jar replaces jtds-1.3.1.jar. #AdditionalJar: jtds-1.3.1-a #CustomBuildAction: After Packager, %WINDIR%\System32\robocopy.exe, ..\ temp\build\bin\...

www.b4x.com

 

[netsistemas]

Great erel!!!thanks