I would like to use a component capable to read all kind of databases (thus user can use context variables to enter his database connection).

I to have something similar in mind, but not different databases. I would like it if I could change the IP address of my database connections with a variable field you can change on setup if you wan to.

Cheers
qunu

Hello,

i have in a string field a date in this format String ( 02/01/1900 00:00:00)
I would like to have it like yyyy-mm-dd in an output field (in string)
I use a Tmap1 and i want to include in it.
I've try TalendDate.formatDate("yyyy/MM/dd 00:00:00",TalendDate.parseDate("yyyy-MM-dd",row1.dateemission)),  but i can't get a good result

Exception in component tMap_1
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "02/01/1900 00:00:00"
    at routines.TalendDate.parseDate(TalendDate.java:87)
    at blueprint.ekb_p112_expertbo_ais_date.EKB_P112_ExpertBO_AIS_date.tFileInputDelimited_1Process(EKB_P112_ExpertBO_AIS_date.java:947)
    at blueprint.ekb_p112_expertbo_ais_date.EKB_P112_ExpertBO_AIS_date.runJobInTOS(EKB_P112_ExpertBO_AIS_date.java:3245)
    at blueprint.ekb_p112_expertbo_ais_date.EKB_P112_ExpertBO_AIS_date.main(EKB_P112_ExpertBO_AIS_date.java:3161)
Caused by: java.text.ParseException: Unparseable date: "02/01/1900 00:00:00"
    at java.text.DateFormat.parse(Unknown Source)
    at routines.TalendDate.parseDate(TalendDate.java:85)


Thanks

Hate to dig up an old thread, but this is really bothering me.

If I have already created a context in the repository and imported it into my job, how do I then create an additional context and use the same steps to configure two different contexts?

When I try to do this using the button on the lower left of the Variables tab under Contexts, it shows me the context in the popup but shows nothing when I try to expand it and select the variables.

If you don't create all your contexts before importing the vars in your job you can't use this feature?