Six Stars

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

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 fileProperty file

 

Error message driver jar nameError message driver jar name

 

 

Error message driver jar pathError message driver jar path

 

 

ConnectionConnection

 

 

result.PNG 

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Twelve Stars TRF
Twelve Stars

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

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.

TRF
Twelve Stars TRF
Twelve Stars

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

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


TRF
3 REPLIES
Twelve Stars TRF
Twelve Stars

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

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.

TRF
Six Stars

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

thank you @TRF for answering me.

I understand better now.

 

Twelve Stars TRF
Twelve Stars

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

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


TRF