topic Re: Error message when passing context variable from property file into Driver Jar for Azure connection in Talend Studio

Error message when passing context variable from property file into Driver Jar for Azure connection

Anonymous — Mon, 19 Jun 2017 13:37:21 GMT

Hi everyone,
I am finalizing a property file containing all parameters of my jobs.
I use a connection General JDBC to connect into my database SQL Server-Azure.
All parameters pass except the driver Jar.
I tried to put the driver jar path and the name of my driver jar.

I have a error message.

It works if I put the name of driver jar in hard code but I'm not interested...

Someone can help me please.
Thank you.Property file

Error message driver jar name

Error message driver jar path

Connection

Re: Error message when passing context variable from property file into Driver Jar for Azure connection

TRF — Mon, 19 Jun 2017 16:40:39 GMT

Assume jar files are required at compile time but as context variables content is defined at runtime, you cannot use them to define jar path and name.

Re: Error message when passing context variable from property file into Driver Jar for Azure connection

Anonymous — Tue, 20 Jun 2017 12:21:24 GMT

thank you @TRF for answering me.

I understand better now.

Re: Error message when passing context variable from property file into Driver Jar for Azure connection

TRF — Tue, 20 Jun 2017 14:15:26 GMT

@maria94, you're welcome.

Don't forget to mark the case as solved if you consider it is.

This should be usefull for someone searching a solution for the same problem.

Re: Error message when passing context variable from property file into Driver Jar for Azure connection

Anonymous — Fri, 01 Jun 2018 08:34:53 GMT

Hi,

I am facing similar problem so can you please help with your metadata connection and connection values used for each parameter.

Re: Error message when passing context variable from property file into Driver Jar for Azure connection

Anonymous — Thu, 21 Jun 2018 08:31:46 GMT

Hello @araja,

Could you please give us more information about your issue? Screenshots will be preferred.

Best regards

Sabrina

Re: Error message when passing context variable from property file into Driver Jar for Azure connection

Anonymous — Mon, 25 Jun 2018 10:53:49 GMT

Hi,

I am using general JDBC connection with mssql-jdbc.jar and i have my context group defined for using it in connection.

When I pass all the context parameters from command prompt to execute job I am receiving below errors.

Exception in component tJDBCInput_1
java.lang.ClassNotFoundException:
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at etl.test_params_0_1.test_params.tJDBCInput_1Process(test_params.java:1779)
at etl.test_params_0_1.test_params.tLogCatcher_1Process(test_params.java:1333)
at etl.test_params_0_1.test_params.tWarn_1Process(test_params.java:524)
at etl.test_params_0_1.test_params.runJobInTOS(test_params.java:2312)

Thanks,