JDBC driver runs into "class not found" error in TAC

[mbtalend]

In out development environment (talend di) we created a simple job to execute a simple query. We are using sqlbase jdbc driver with tJdbcConnection. sqlbase is link in as external reference. In development the job is running fine. As we deploy the job to the TAC via SVN/remote connection the job breaks up with errors:

Exception in component tJDBCConnection_1
java.lang.ClassNotFoundException: jdbc.gupta.sqlbase.SqlbaseDriver

It seems that the JDBC driver "SQLBaseJDBC11.7.jar" is not copied to into the job. It's obvious that after transmission to the TAC the library is missing. We have tried to copy the job to different folders at the TAC-Server and the usage of tLoadLibrary without success. Any ideas?

[Anonymous]

Hello,

The external libraries that you have downloaded at Studio start-up will not be shared and thus the other users of Talend Administration Center will not be able to use CommandLine to generate their Jobs.

Could you please take a look at this online document about:TalendHelpCenter:Installing external modules to install modules in CommandLine?

Best regards

Sabrina

[mbtalend]

Hi,



the tJDBC component links in an external driver. It is not really a component. By adding the sqlbase driver as jar file from the modules view it will be not listed/installed. The question remains: if I use jJdbc component and use an external reference as required parameter from this component to the sqlbase driver how can I transfer the driver to the TAC?

[Anonymous]

Hello,

Could you please follow up these steps to sync up these external libraries with commandline?

1: Open a remote project from studio (make sure that your SVN/ Nexus is running well at the same time)

2: Install your required external libraries by using Module view(Window-->Show View-->Talend-->Modules)

In this way, SVN/ Nexus will sync up your required external libraries automatically and then commandline will get them from .m2 repository to deploy your job.

Please take a look at my screenshots and let us know if it works.

Best regards

Sabrina

[mbtalend]

Thank you very much for this hint. It is not possible to include the SQLBaseJDBC11.7.jar in the modules view. The driver is not listed after "import external jar"! Same as "download external jar" - here ist no target available. Nexus on the remote machine is up, running and accessable over network.

[Anonymous]

Hello,

Would you mind creating a case on talend support portal so that we can give a remote assistance to you through support cycle with priority?

Best regards

Sabrina

[mbtalend]

ok, we will do it so

[RSchmidt1653734348]

When running the program I get a ClassNotFoundException referring to the selected driver: JDBC-Class not found. - org.apache.derby.jdbc.You need to set in on your classpath all the libraries for the classes you are going to call and for all the dependencies of those classes. In out development environment (talend di) we created a simple job to execute a simple query.

[Aman_Malviya]

Hi,

When setting up TAC for the first time, or changing the TAC database, you may see the error Driver not found.

You are either missing the needed driver or may have the incorrect driver.

Solution

1. Download jtds-1.3.1-dist.zip from https://sourceforge.net/projects/jtds/files/jtds/1.3.1/ and unzip it.
2. Navigate to the TAC/apache-tomcat/ folder.
3. Create an endorsed folder if it does not already exist.
4. Copy the jtds.1.3.1.jar file into the endorsed folder and restart TAC.

Best Regards

Aman