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
