Jump to content
Changes to the Jaspersoft community edition download ×

Access Db or Flat files issues with Jasper ETL


Recommended Posts

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?



Post edited by: haroon, at: 2008/01/03 10:02

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...