Jump to content
Changes to the Jaspersoft community edition download ×

Access Db or Flat files issues with Jasper ETL


haroon

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?

 

Thanks.

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...