tAccess_Input error

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

shong

[Anonymous]

Hi Sheng
It works !
Thank you
msomso

[Anonymous]

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

[Anonymous]

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