use of an Access DB or flat files as sources

[haroon]

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:50size=150

Post edited by: haroon, at: 2008/01/03 09:54