SQL Server connection fails because jdk.charsets is missing in Docker image

Technical queries
#1

Hello Helical Insight Team,

I am using Helical Insight 6.2.1 GA with the Docker image:hiee/helicalinsight:carbon-j25t11.

When testing a Microsoft SQL Server datasource connection, I receive the following error: Windows collation zh_CN is not supported by this driver. Caused by: java.io.UnsupportedEncodingException: Codepage MS936 is not supported by the Java environment.

I checked the Java runtime inside the container: docker compose exec -T hiee java --describe-module jdk.charsets.

The result is: jdk.charsets not found.

It appears that the Java runtime in this Docker image does not include the jdk.charsets module required for the SQL Server MS936/Chinese collation.

Could you please advise how to resolve this issue? Is there an updated Docker image that includes jdk.charsets, or another officially supported solution?

Thank you. The attachment is the error message I encountered.

SQLServerException.txt (33.1 KB)

#2

Hello,

When we connect to SQLServer, there could be two methods of connecting. One is Windows authentication based. Second is using the JDBC connection method. Can you verify or share snapshot of the datasources page how you are connecting. You can mask the sensitive information.