B4J Question B4JPackager11 JTDS Charset Issue

Philip Chatzigeorgiadis · May 5, 2020

I have a small UI app connected to SQLServer database, which runs fine from the the B4J IDE.
After packing it with B4JPackager 11, I got this error:

B4X:

D:\ALLDOCS\JAVAPROGRAMS\B4JPackager11\Objects\temp\build\bin>java.exe @release_java_modules.txt  -m b4j/b4j.example.main
main._appstart (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._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/b4j.example.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)

Following the suggestion for a similar problem here:

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

I replaced the JTDS (jtds-1.3.1.jar) driver with MSSQL JDBC driver (mssql-jdbc-8.2.2.jre11.jar) and the problem was fixed.

Is there another solution or workaround, so that I can keep using the JTDS driver?

Erel · May 6, 2020

Switch back to the jtds driver and set VMArgs in B4JPackager11 to: -Dfile.encoding=UTF-8

Does it solve it?

Philip Chatzigeorgiadis · May 6, 2020

Erel said:
Switch back to the jtds driver and set VMArgs in B4JPackager11 to: -Dfile.encoding=UTF-8

Does it solve it?

No. Same problem.

Erel · May 6, 2020

Try to set the charset in the connection string.
Add charset=utf8

Philip Chatzigeorgiadis · May 6, 2020

Erel said:
Try to set the charset in the connection string.
Add charset=utf8

Tried these combinations in the connection string:
charset=utf8, got error: java.sql.SQLException: Could not find a Java charset equivalent to DB charset utf8.
charset=UTF8, got error: java.sql.SQLException: Could not find a Java charset equivalent to DB charset UTF8.
charset=utf-8, got error: java.sql.SQLException: Could not find a Java charset equivalent to DB charset utf-8.
charset=UTF-8, got error: java.sql.SQLException: Could not find a Java charset equivalent to DB charset UTF-8.

In all caseS the App ran fine in the IDE.

Erel · May 6, 2020

This is a guess but it is worth testing.

Unzip the attached zip file in the generated bin folder. Don't remove the inner folders.

Philip Chatzigeorgiadis · May 6, 2020

Erel said:
This is a guess but it is worth testing.

Unzip the attached zip file in the generated bin folder. Don't remove the inner folders.

Partial success: Works fine in Windows. Error persists in MAC.

Erel · May 7, 2020

Do you get the exact same error? Try to put the net folder inside the parent folder.

Philip Chatzigeorgiadis · May 7, 2020

Erel said:
Do you get the exact same error? Try to put the net folder inside the parent folder.

The error on the MAC was the same: java.sql.SQLException: Could not find a Java charset equivalent to DB charset UTF8
UTF8 was set in the connection string.
The error remained the same even when I copied the net folder inside the parent folder (so net was present both in the parent and in the bin folder).

However, I had a setback today.
When I tried to go back to windows and do further testing, the error (java.sql.SQLException: Could not find a Java charset equivalent to DB charset UTF8 ) appeared again, although yesterday afternoon it tested OK.
I made sure that I used the exact same configuration as yesterday afternoon (used a backup copy I took immediately after the succesful run) but the error persists.
(Starting to doubt my sanity ...)

Erel · May 7, 2020

If you like you can zip the windows build and send me a link to it. I will try it here.

Philip Chatzigeorgiadis · May 7, 2020

Erel said:
If you like you can zip the windows build and send me a link to it. I will try it here.

Erel, thank you for your interest and help.
Here is the link to the zipped build folder:

Link to zipped build folder

Erel · May 8, 2020

I guess that it tries to connect to a db that is not accessible for me so I guess a different error.

I recommend you to switch to Microsoft driver for now.

netsistemas · Sep 28, 2020

All perfect, thanks. I complete the message with this words
Remember, THIS IS FOR B4J (no b4a)

Change this in main.

' #AdditionalJar: jtds-1.3.1.jar

#AdditionalJar: mssql-jdbc-8.4.1.jre11

Download last library from:

Maven Repository: com.microsoft.sqlserver » mssql-jdbc » 8.4.1.jre11

mvnrepository.com

And use this connection:

B4X:

        CC = $"jdbc:sqlserver:${ServerConfig.Server};user=${ServerConfig.Usu};integratedSecurity=false;password=${ServerConfig.clave};databaseName=${ServerConfig.DB};"$

        SqlServer.Initialize("com.microsoft.sqlserver.jdbc.SQLServerDriver", CC)

Johan Schoeman · Aug 22, 2021

Is there any solution for.....

B4X:

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:

B4X:

    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 · Aug 22, 2021

Please start a new thread.

B4J Question B4JPackager11 JTDS Charset Issue

Philip Chatzigeorgiadis

Active Member

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

Erel

B4X founder

Philip Chatzigeorgiadis

Active Member

Erel

B4X founder

Philip Chatzigeorgiadis

Active Member

Erel

B4X founder

Attachments

Philip Chatzigeorgiadis

Active Member

Erel

B4X founder

Philip Chatzigeorgiadis

Active Member

Erel

B4X founder

Philip Chatzigeorgiadis

Active Member

Erel

B4X founder

netsistemas

Active Member

Maven Repository: com.microsoft.sqlserver » mssql-jdbc » 8.4.1.jre11

Johan Schoeman

Expert

Erel

B4X founder

Similar Threads

B4J Question B4JPackager11 JTDS Charset Issue

Active Member

B4X founder

Active Member

B4X founder

Active Member

B4X founder

Attachments

Active Member

B4X founder

Active Member

B4X founder

Active Member

B4X founder

Active Member

Expert

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency