Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 0683p000009MADq.png (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 :
Labels (4)
9 Replies
Anonymous
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

Hi,
ok J'll try with 2.4.1.
Regards
msomso
Anonymous
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

Hi Sheng
It works !
Thank you
msomso
Anonymous
Not applicable
Author

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
Not applicable
Author

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