tDBConnection + context variables - NullPointerException

Five Stars

tDBConnection + context variables - NullPointerException

Hello all,

I've defined a context group dbeasl as :

 

Capture d’écran 2018-07-03 à 16.18.33.png

 

 

 

 

 

 

My tDBConnection is defined as :

Capture d’écran 2018-07-03 à 16.20.36.png

I run thru :

Capture d’écran 2018-07-03 à 16.22.27.png

 

and as you can see above, I obtain a null pointer exception...

Of cource, by replacing the context variables by their value in the component, it works perfectly...

 

Would you have any idea ?

 

I'm using Talend Open Studio for data Integration Version 7.0.1

 

Thanks in advance,

 

Fred

Eleven Stars

Re: tDBConnection + context variables - NullPointerException

did you restart Talend? did you check Context File? did you test your db connection from metadata?

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Twelve Stars

Re: tDBConnection + context variables - NullPointerException

@FRibadeau, why dbeasl_Login is null ?,you should pass values for this.

 

Please check the contexts.

Manohar B
Five Stars

Re: tDBConnection + context variables - NullPointerException

Hi,
- Restart talend : No change
- Context : It's not a file, just context declaration in the tree on the left (am I clear?)
- DB connection from MetaData : Yes, it's working perfectly.

Thanks for your help.
Five Stars

Re: tDBConnection + context variables - NullPointerException

Hi,
It's an Access database, without any user/password set.
And the connection, from the metadata, is working perfectly.

Thanks for your help
Eleven Stars

Re: tDBConnection + context variables - NullPointerException

did you try to add blanc on login?
I think context may stay null if no data are set.

Francois Denis

Tag as "solved" for others! Kudos to thanks!