use of an Access DB or flat files as sources

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(
at sun.jdbc.odbc.JdbcOdbc.standardError(
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(
at sun.jdbc.odbc.JdbcOdbcStatement.execute(
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(
at maquette.trial.TRIAL.tDBInput_1Process(
at maquette.trial.TRIAL.main(
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?


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
Joined: Dec 19 2007 - 11:07pm
Last seen: 12 years 1 month ago

0 Answers:

No answers yet