Four Stars

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

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?

6 REPLIES
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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?




Moderator

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

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.
RemoteProject.pngTACexternallibraries.png

 

Best regards

 

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

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.


Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

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

ok, we will do it so