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
Highlighted
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
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:

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.