tAccess_Input error

One Star

tAccess_Input error

Hi
J've defined a metadata connection to an Access 2000 db.
J've checked this connection and IT WORKED ! : J have retrived the access table's schemas.
But when J run a simple job it gives:
Exception in component tAccessInput_1
java.sql.SQLException: Trop peu de paramètres. 1 attendu.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at cen_232.t_echantillon.T_ECHANTILLON.tAccessInput_1Process(T_ECHANTILLON.java:526)
at cen_232.t_echantillon.T_ECHANTILLON.runJobInTOS(T_ECHANTILLON.java:2386)
at cen_232.t_echantillon.T_ECHANTILLON.main(T_ECHANTILLON.java:2261)
2008-07-11 15:07:43|20tqUm|20tqUm|20tqUm|CEN_232|T_ECHANTILLON|Default|6|Java Exception|tAccessInput_1| Trop peu de paramètres. 1 attendu.|1
And now when J check my connection it fails Smiley Indifferent (cf. screenshot), but it's still possible to retrive new table's schema from ...
Any idea ?
Best regards
msomso




By the way, can you tell me how to close the Table Selector process :
Community Manager

Re: tAccess_Input error

Hello
Which version of TOS are you using? I have tested this issue on TOS2.4.0 and TOS2.4.1, they all works fine.
About your problem, it shows you have connected to Access database successfully, but you don't define a right schema for talbe structure, so please check your table fields.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tAccess_Input error

Hi,
We use TOS version 2.3.2.
Don't you think, we have a driver problem?
What about the message "Trop peu de paramètres. 1 attendu." ?
Regards
msomso
Community Manager

Re: tAccess_Input error

Hello
What about the message "Trop peu de paramètres. 1 attendu." ?

It means not enough parameters. Need one
Don't you think, we have a driver problem?

It works fine on my machine with TOS2.4.1. I aslo get this exception if I don't define a right schema for table structure.
Please download the latest version of TOS with more new feature.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tAccess_Input error

Hi,
ok J'll try with 2.4.1.
Regards
msomso
Highlighted
One Star

Re: tAccess_Input error

Hi Sheng,
j'm still with 2.3.2.
J've resolved somme errors. And now j've the problem with Access timestamp column reading.
In the table's retrived schema it's a String datatype (while ?).
Running the job gives:

Starting job T_ECHANTILLON_KO at 15:06 15/07/2008.
Exception in component tAccessInput_1
java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.String

at cen_232.t_echantillon_ko.T_ECHANTILLON_KO.tAccessInput_1Process(T_ECHANTILLON_KO.java:418)
at cen_232.t_echantillon_ko.T_ECHANTILLON_KO.runJobInTOS(T_ECHANTILLON_KO.java:1430)
at cen_232.t_echantillon_ko.T_ECHANTILLON_KO.main(T_ECHANTILLON_KO.java:1306)
2008-07-15 15:06:15|SgfuHt|SgfuHt|SgfuHt|CEN_232|T_ECHANTILLON_KO|Default|6|Java Exception|tAccessInput_1|java.sql.Timestamp cannot be cast to java.lang.String|1
Job T_ECHANTILLON_KO ended at 15:06 15/07/2008.

In the java code line 418 J've this:
row1.DateMesure = (String) value;
To have a string and non timestamp data, J've tried to modify the query like this:
"SELECT ..., format(MesureBC.DateMesure, "dd/mm/yyyy") ... " instead of
"SELECT ..., MesureBC.DateMesure, ... "
but it doesn't work ....
Any example/idea ?
Regards
msosmo
Community Manager

Re: tAccess_Input error

Hello
Set the data type of DateMesure as Date and its date pattern as 'dd/mm/yyyy' when defining the schema.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tAccess_Input error

Hi Sheng
It works !
Thank you
msomso
One Star

Re: tAccess_Input error

Hello,
It's possible to catch this exception on tAccessInput Talend component ?
This is a microsoft ODBC bug reported here:
http://support.microsoft.com/kb/171850/en-us/
Exception in component tAccessInput_1
java.sql.SQLException: Trop peu de paramètres. 2 attendu.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at mg_export.mg4_0_1.mg4.tAccessInput_1Process(mg4.java:1807)
at mg_export.mg4_0_1.mg4.runJobInTOS(mg4.java:50173)
at mg_export.mg4_0_1.mg4.main(mg4.java:50010)

Thanks a lot
One Star

Re: tAccess_Input error

I found the solution,
My Exception is catched like here:

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog