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)
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)
2 Answers:
Posted on August 12, 2015 at 7:17am
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.
Posted on September 22, 2021 at 11:22am
Alternatively:
- Run HSQLDB locally by downloading this folder, then cd into it and run "ant" on the command line
- Set up Data Source in JRS: top-menu Create > Data Source, then select Other in JDBC Driver
- JDBC Driver (class): org.hsqldb.jdbc.JDBCDriver
- URL: jdbc:hsqldb:hsql://localhost
- User Name: sa
- Password: (empty)
- Click Add Driver... > pick the file hsqldb-jdk8.jar (extract from e.g. this zip or latest version)
- Save Data Source and link it to Report when publishing from Studio
Excuse me but your link is failing. Did you check it before posting it ;-)
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.