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.param.PNGProperty file

 

erropathname.PNGError message driver jar name

 

 

erropath.PNGError message driver jar path

 

 

erro.PNGConnection

 

 

result.PNG 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Forteen Stars TRF
Forteen 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
6 REPLIES
Highlighted
Forteen Stars TRF
Forteen 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.

 

Forteen Stars TRF
Forteen 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
Six Stars

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

Hi,

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

 

 

 

Moderator

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

Hello jamirsayyad,

 Could you please give us more  information about your issue? Screenshots will be preferred.
 
 
 
 
 
 
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.
Six Stars

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

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,