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

5 REPLIES
Ten 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

Don't forget to tag when it's "solved"!

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
Ten 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

Don't forget to tag when it's "solved"!