sqlite how to

Running JasperReports from command line

Brought to you by: vosskaem

sqlite how to

Forum: General Discussion

Created: 2014-12-16

Updated: 2014-12-17

Sam - 2014-12-16

Dear all,

I need step by step instruction on how to use JasperStarter with sqlite,
where i can download sqlite jdbc connector, etc.

Kind regard's
SS

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Volker Voßkämper - 2014-12-16

Hi Sam,

download the driver https://bitbucket.org/xerial/sqlite-jdbc/downloads
and put it in the jdbc directory of your JasperStarter installation.
You must use dbtype -t generic and provide the driver classname with --db-driver
and connect string with --db-url.
See
http://jasperstarter.sourceforge.net/usage.html
and
https://bitbucket.org/xerial/sqlite-jdbc

It should be something like:

jasperstarter pr myreport.jrxml -f view -t generic --db-driver org.sqlite.JDBC --db-url jdbc:sqlite:C:/work/mydatabase.db

Regards
Volker
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Sam - 2014-12-17
  
  Thank you for your guidance Volker,
  
  my report is running now.
  Just for your information, i have to add -u argument as is required by JasperStarter.
  
  Kind Regard's
  SS
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Volker Voßkämper - 2014-12-17

I consider this a bug.
https://cenote-issues.atlassian.net/browse/JAS-58

Thank you for the hint.

Regards
Volker

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.