Talend community forum / Talend Date in 'SQL' issue - Token error.

peri · 2012-06-29 19:36:34

Tags: [database, date, development, oracle]

Here is the 'string constructed in Talend' and it gives token error but I don't see anything obvious.

"select (Audithis."Audit"),("Date") from Audithis, Patient where "TableName"='PATIENT' and Audithis."Audit"=Patient."Audit" and Audithis."Date">'"+ TalendDate.formatDate("yyyy-MM-dd HH:mm:ss", context.last_change)+"'";

Date & last_change are Date and formatted using TatlendDate.

Appreciate any feedback on this.

thanks,
Peri

peri · 2012-06-29 23:22:01

Surprised No feedback !!

pedro · 2012-07-02 08:14:12

Hi Peri

Welcome to Talend Community!

Which DB do you use? Some dbs have their own function about formatting date.
Besides, please show us the error info.

Regards,
Pedro

peri · 2012-07-02 18:29:28

Hi Pedro,

The query is constructed against Oracle database.

/*
Exception in thread "main" java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: Unresolved compilation problem:
Syntax error on tokens, delete these tokens

at
*/

I error code here in the talend as highlighted by the red dot. as follows ;

/*
String dbquery_tOracleInput_2 = "select (Audithis."Audit"),("Date") from Audithis, Patient where "TableName"='PATIENT' and Audithis."Audit"=Patient."Audit" and Audithis."Date">'"+ TalendDate.formatDate("yyyy-MM-dd HH:mm:ss", context.last_change)+"'";

*/

thanks,
Peri

pedro · 2012-07-03 05:47:32

Hi Peri

Because the info is limited.
Please send an email to me and attach this export job.
I will test it for you.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-06-29 19:36:34

Talend Date in 'SQL' issue - Token error.

#2 2012-06-29 23:22:01

Re: Talend Date in 'SQL' issue - Token error.

#3 2012-07-02 08:14:12

Re: Talend Date in 'SQL' issue - Token error.

#4 2012-07-02 18:29:28

Re: Talend Date in 'SQL' issue - Token error.

#5 2012-07-03 05:47:32

Re: Talend Date in 'SQL' issue - Token error.

Board footer