Jump to content
Changes to the Jaspersoft community edition download ×

Where do we get the sample DB used?

Go to solution Solved by kkumlien,

Recommended Posts

By: Ruben Misrahi - rnmisrahi

Where do we get the sample DB used?

2003-02-26 08:58

To understand JasperReports, I'd like to be able to use the DB sample used (Northwind orders, CustomBEanFactory, whatever).


Is there a place where we can get that sample DB?





By: Teodor Danciu - teodord

RE: Where do we get the sample DB used?

2003-02-26 09:08




A HSQL database is supplied in the /demo/hsqldb

directory of the project.

To start the server, you just go to that directory

and launch this from the command prompt:






>ant runServer


You only have to have ANT installed on your system.

Some of the samples connect to this database

when filling the reports.


I hope this helps.







By: Ruben Misrahi - rnmisrahi

RE: Where do we get the sample DB used?

2003-02-26 11:58

Thanks. That did it, but now I get:


java.lang.ClassCastException at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:101) at JasperApp.main(JasperApp.java:159)

Link to comment
Share on other sites

  • 8 years later...
  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

  • Solution

The Sample DB available in Jaspersoft Studio used to be available here: http://anonsvn:anonsvn@code.jaspersoft.com/svn/repos/jasperreports/trunk/jasperreports/demo/hsqldb/

The repo was then moved to GitHub: https://github.com/TIBCOSoftware/jasperreports/tree/master/jasperreports/demo/hsqldb

The file test.script can be run on any SQL database with minimal modification.

Link to comment
Share on other sites

  • 3 years later...
  • 3 months later...
  • 2 years later...


  1. Run HSQLDB locally by downloading this folder, then cd into it and run "ant" on the command line
  2. Set up Data Source in JRS: top-menu Create > Data Source, then select Other in JDBC Driver
    1. JDBC Driver (class): org.hsqldb.jdbc.JDBCDriver
    2. URL: jdbc:hsqldb:hsql://localhost
    3. User Name: sa
    4. Password: (empty)
    5. Click Add Driver... > pick the file hsqldb-jdk8.jar (extract from e.g. this zip or latest version)
  3. Save Data Source and link it to Report when publishing from Studio
Link to comment
Share on other sites

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