use of an Access DB or flat files as sources

0
Hi all,

Firstly, Happy New Year & Best wishes !!! :)

I'm trying to use JasperETL (V.2.1.2.r5184) for a demo I have to do.

I have to use an Access Database or Flat files (csv).

The Db link works well for each sources. The ETL shows correctly "Table schemas".

The main issue I have concerns the running of the ETL (which is a main one, ) , as followed:


"Starting job TRIAL at 10:07 03/01/2008.
Exception in component tDBInput_1
java.sql.SQLException: [Microsoft][Pilote ODBC Texte] Trop peu de paramètres. 4 attendu.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
at maquette.trial.TRIAL.tDBInput_1Process(TRIAL.java:493)
at maquette.trial.TRIAL.main(TRIAL.java:3159)
Job TRIAL ended at 10:07 03/01/2008. [exit code=0]"


I'm looking for an easy way to solve it, because I'm not a big Java developper.

Does somebody meet this issue? What is the right way to solve it?
What are your recommandations?
Do I have to change the DB fo a Mysql DB?

Thanks.

Post edited by: haroon, at: 2008/01/03 09:50[img size=150]
Post edited by: haroon, at: 2008/01/03 09:54
haroon's picture
3
Joined: Dec 19 2007 - 11:07pm
Last seen: 12 years 1 month ago

0 Answers:

No answers yet
Feedback
randomness