Can't import Microsoft Access date field using tAccessInput

[Anonymous]

I am very new to TOS.
I have a very simple table in Access 2003 with several fields. One of the fields is a Date field. This field has no special format. However, when I tried to use tAccessInput to import the data from the table, I received an exception caused by that date field:
xception in component tAccessInput_1
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataStringTimestamp(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataStringTimestamp(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getTimestamp(Unknown Source)
at talenddemosjava.testing_0_1.testing.tAccessInput_1Process(testing.java:645)
at talenddemosjava.testing_0_1.testing.runJobInTOS(testing.java:966)
at talenddemosjava.testing_0_1.testing.main(testing.java:860)
I have no idea why this is happening. I tried to change the data type of the date field in the schema and I got something like: 1984-12-05 00:00:00
I tried many date pattern possible such as "yyyy-MM-dd'T'HH:mm:ss". I constantly received the same exception.
Would you please help me to solve this problem?
Thank you very much.
Toan.

[Anonymous]

Hello
What's your data looks like in access table? Can you show me the schema of tAccessInput_1?
Best regards
shong

[Anonymous]

Thank you very much for replying. The table structure and schema are posted.

[Anonymous]

Hello
If the date looks like :1984-12-05 00:00:00, the date pattern should be set as: "yyyy-MM-dd HH:mm:ss"
Best regards

shong

[Anonymous]

I tried that already and same thing happned.

[Anonymous]

Hello
First, make sure you set the correct data source and table name.
Please show me a screenshot of your data.
Best rega

[Anonymous]

The data source and table name should be correct because when I got rid of that date field, everything runs just fine.

[Anonymous]

Hello
From your image, I see the date pattern looks like
"dd/MM/yyyy"
or
"dd/MM/yyyy HH:mm:ss"
Best regards

shong

[Anonymous]

I've tried everything
"dd/MM/yyyy HH:mm:ss" Length = 19
"MM/dd/yyyy HH:mm:ss" Length = 19
"dd/MM/yyyy" Length = 10
"MM/dd/yyyy" Length = 10
Nothing works. I don't know why a simple task is so hard.

[Anonymous]

Hello
Which version of TOS do you use?
Don't worry! As your said, it is just a simple job. Please send your data source to me via email. I will try..
Best regards
shong