topic Re: getCurrentDate() throwing an error in Talend Studio

getCurrentDate() throwing an error

Anonymous — Thu, 07 Jul 2016 19:18:16 GMT

Hi,
using TalendDate.getCurrentDate() and it throws this error:
Exception in thread "main" java.lang.IllegalArgumentException: Illegal pattern character 'T'
              at java.text.SimpleDateFormat.compile(SimpleDateFormat.java:826)
              at java.text.SimpleDateFormat.initialize(SimpleDateFormat.java:634)
              at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:605)
              at java.text.SimpleDateFormat.<init>(SimpleDateFormat.java:580)
              at ingestionpipeline.testflow_0_1.TestFlow.runJobInTOS(TestFlow.java:1912)
              at ingestionpipeline.testflow_0_1.TestFlow.main(TestFlow.java:1759)

Can't even get it to compile, and yes this is in a date field.
thanks,
Bob

Re: getCurrentDate() throwing an error

Anonymous — Thu, 07 Jul 2016 19:28:08 GMT

I would be surprised if this is coming from getCurrentDate(). Are you sure it's not from some other logic in your Job. Have you got the full stack trace?
If your Job won't compile, you should be taking a look at the code window to see where the issue lies.

Re: getCurrentDate() throwing an error

Anonymous — Thu, 07 Jul 2016 19:52:51 GMT

I recreated in a job, that does nothing but sticks the date and a pk into MySQL table using a tfixedFlowinput and tMysqlOutput.
The schema was imported, and the field is datetime on mysql.
If I use this: TalendDate.parseDate("yyyy-MM-dd hh:mm:ss","9999-01-01 12:12:12");
Then it works.