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

[Anonymous]

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

 

[TRF · Accepted solution]

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.

[Anonymous]

thank you @TRF for answering me.

I understand better now.

[TRF]

@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.

[Anonymous]

Hi,

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

[Anonymous]

Hello @araja,

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

Best regards

 Sabrina

[Anonymous]

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,