Where do we get the sample DB used?

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

Hi,

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

or

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





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)
2002 JI Open Discussion's picture
Joined: Aug 10 2006 - 3:28am
Last seen: 15 years 9 months ago

Excuse me but your link is failing. Did you check it before posting it ;-) 

joeylovett1 - 3 years 7 months ago

Hi Joey, I posted my answer nearly 4 years ago :D Things tend to move fast in software. The repo moved to GitHub since, I've updated the answer.

kkumlien - 3 years 3 months ago

2 Answers:

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

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

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

kkumlien's picture
7226
Joined: Jan 22 2015 - 4:36am
Last seen: 2 hours 12 min ago

Alternatively:

  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
kkumlien's picture
7226
Joined: Jan 22 2015 - 4:36am
Last seen: 2 hours 12 min ago
Feedback
randomness