topic Re: Context date parsing in Talend Studio

Context date parsing

SAdlam — Fri, 15 Jan 2021 19:45:13 GMT

Hi,

I'm fairly new to TOS, and have hit an issue with using a date context variable in a trestclient parameter.

I've got the context set to date

and have chosen a date from the date picker.

then within the trestclient parameter i've got the following to get the unix timestamp time.

I'm getting this error though when I run the job.

its almost as if the context variables are not being passed to the trestclient properly.

any pointers please? i've spent quite alot of time trying to get this working.

it works fine when i put in the figure directly!

Thanks 🙂

Steve

Re: Context date parsing

Prakhar1 — Sun, 17 Jan 2021 13:20:06 GMT

It might be the format of the date value you are passing in the context.

It should be like this yyyy-mm-dd hh:mm:ss (for ex - 2021-01-17 18:46:14 )

If you check the value filed of the context you can see "..." to select the value.

Use that option to provide the specific value.

And if you want only the date in dd-mm-yyyy format, then you need to change it using "TalendDate.formatDate(pattern, date)".

Or better try to pass date value as string in your rest api call.

Re: Context date parsing

SAdlam — Mon, 18 Jan 2021 00:36:38 GMT

Thanks. i've been using the date picker, so the format is predefined and looks a what you say.

I think i must be doing something wrong across the board as my dbconneciton doens't work either. (get the same null value being parsed for a db connection.

uugh. fairly new to all this!

Re: Context date parsing

SAdlam — Mon, 18 Jan 2021 00:56:32 GMT

Hi so a quick update.

I've set the db conneciotn up in the meta and this works fine. from the meta I setup a context, which is now passing null values. even thought the meta based on the context tests ok...

what am I doing wrong? It's just not making sense to me!

Screen shots below.

Error

Meta setup.

Component setup.

Re: Context date parsing

Prakhar1 — Mon, 18 Jan 2021 06:23:14 GMT

The screeshot is not attached .

Could you add it again?

and in which format you are passing value in metadata and how you are passing in the dbConnection.

Re: Context date parsing

SAdlam — Mon, 18 Jan 2021 09:37:46 GMT

sure sorry not sure how they got missed.

Please see attached

ContextMeta

Component

Error

Re: Context date parsing

SAdlam — Mon, 18 Jan 2021 09:38:06 GMT

sorry forgot to hit reply. I've uploaded the additional screenshots...

Re: Context date parsing

Prakhar1 — Mon, 18 Jan 2021 16:44:09 GMT

Might be some jar issues.. can you select the jdbc provider option in tDBOutput and make it as microsoft and then try

Re: Context date parsing

SAdlam — Wed, 27 Jan 2021 14:46:34 GMT

Hi So I'm missing the JDBC Microsoft jar which I'm in the process of installing, but when I enter the values in as text the component works! odd

Re: Context date parsing

SAdlam — Wed, 27 Jan 2021 14:56:32 GMT

nope didn't work still the same issue. the contexts are passing as "null" rather than the data entered.

Re: Context date parsing

SAdlam — Wed, 27 Jan 2021 15:16:47 GMT

Hi So I've also encounted ther error on onther variables too like the dbname its passing a null value into the component, but in a msgbox i get the right value... any pointers from anyone?

Re: Context date parsing

SAdlam — Wed, 27 Jan 2021 15:32:48 GMT

Hi, so i think i've found more out.

when i use the code System.out.println(context.StagingBiMetaDatabase); in a java component it prints the words null so i'm just not sure how to overwrite this! as in the ui theres a value in the context.

Re: Context date parsing

SAdlam — Tue, 02 Feb 2021 16:58:51 GMT

Just for future reference. I managed to resolve the issue, by changing the data type to char and then back to a string.

not sure what's going on there, but I managed to fix it!