Install JDBC driver 12.4 for SQL server into RedHat Linux 8.9

johnnywong120 — Fri, 02 Feb 2024 20:39:23 GMT

OS: RedHat 8.9

Java version: openjdk version "11.0.22"

Added JDBC driver: mssql-jdbc-12.4.2.jre1

1. I installed remote engine and it is running and Talend Studio can see the RE in the execute option.

But I have issue to connect to the MSSQL in a simple job. tDBInput.

2. I Downloaded the sqljdbc_12.4 from the MS official site. And extract and saved into / bin/sqlhdbc_12.4

3. Added below line into ~/.bashrc

export CLASSPATH=$CLASSPATH:/bin/sqljdbc_12.4/enu/jars/mssql-jdbc-12.4.2.jre11.jar

4. When I try to run this command

root@DEVAPPTALEND02:[/mnt/Teams/Talend Developers/Talend_Install]:

java -cp /home/svc-datafabricdev@AD.TRS.STATE.TX.US/sqljdbc_12.4/enu/jars/mssql-jdbc-12.4.2.jre11.jar com.microsoft.sqlserver.jdbc.SQLServerDriver

Picked up JAVA_TOOL_OPTIONS: -Djdk.util.zip.disableZip64ExtraFieldValidation=true

Error: Main method not found in class com.microsoft.sqlserver.jdbc.SQLServerDriver, please define the main method as:

public static void main(String[] args) or a JavaFX application class must extend javafx.application.Application

4. I run below command and created some classes

jar -xvf /bin/sqljdbc_12.4/enu/jars/mssql-jdbc-12.4.2.jre11.jar

inflated: META-INF/MSFTSIG.RSA

created: META-INF/

created: META-INF/services/

created: META-INF/maven/

created: META-INF/maven/com.microsoft.sqlserver/

created: META-INF/maven/com.microsoft.sqlserver/mssql-jdbc/

inflated: META-INF/maven/com.microsoft.sqlserver/mssql-jdbc/pom.properties

inflated: META-INF/services/java.sql.Driver

inflated: META-INF/maven/com.microsoft.sqlserver/mssql-jdbc/pom.xml

created: com/

created: com/microsoft/

created: com/microsoft/sqlserver/

created: com/microsoft/sqlserver/jdbc/

created: com/microsoft/sqlserver/jdbc/dataclassification/

created: com/microsoft/sqlserver/jdbc/dns/

created: com/microsoft/sqlserver/jdbc/osgi/

created: com/microsoft/sqlserver/jdbc/spatialdatatypes/

created: microsoft/

created: microsoft/sql/

created: mssql/

created: mssql/googlecode/

created: mssql/googlecode/cityhash/

created: mssql/googlecode/concurrentlinkedhashmap/

created: mssql/security/

created: mssql/security/provider/

Anything I am missing to do in configuration

Re: Install JDBC driver 12.4 for SQL server into RedHat Linux 8.9

Xiaodi_Shi — Sun, 04 Feb 2024 05:53:02 GMT

Hello,

What's your sql server version? Does the issue occurs when running job from studio or only from Remote engine?

Could you please have a look at this KB article about:

https://community.qlik.com/t5/Official-Support-Articles/Talend-Resolving-class-and-JAR-related-issues/ta-p/2151442

Feel free to let us know if it is OK with you.

Best regards

Sabrina

Re: Install JDBC driver 12.4 for SQL server into RedHat Linux 8.9

johnnywong120 — Tue, 06 Feb 2024 15:45:44 GMT

Thanks for you reply and information!
SQL server version is 14
It is in Remote Engine.

I will look into the article.

topic Re: Install JDBC driver 12.4 for SQL server into RedHat Linux 8.9 in Installing and Upgrading

Install JDBC driver 12.4 for SQL server into RedHat Linux 8.9

Re: Install JDBC driver 12.4 for SQL server into RedHat Linux 8.9

Re: Install JDBC driver 12.4 for SQL server into RedHat Linux 8.9