Where do we get the sample DB used?

[2002 JI Open Discussion]

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)

[kkumlien]

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.

[joeylovett1]

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

[kkumlien]

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]

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