Connect to the Jasper Reports samples database on localhost


I am trying to connect to the hsqldb database that is running on localhost.  I can connect through the runManager fine, but when I try to connect through a jasper reports adapter and hit "Test" I get an error below.

When using the runmanager for hsqldb:

HSQL Database Engine Server
user: sa
password: empty

But when connecting through the database jdbc connector, this does not work:

Password: empty

In the jasper client:

net.sf.jasperreports.engine.JRException: java.sql.SQLTransientConnectionException: connection exception: connection failure:
Caused by: java.sql.SQLTransientConnectionException: connection exception: connection failure:
    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
    at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
    at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
    at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
    ... 4 more
Caused by: org.hsqldb.HsqlException: connection exception: connection failure:
    at org.hsqldb.error.Error.error(Unknown Source)
    at org.hsqldb.error.Error.error(Unknown Source)
    at org.hsqldb.ClientConnection.execute(Unknown Source)
    at org.hsqldb.ClientConnection.<init>(Unknown Source)
    ... 9 more


And even on the server side, I see this error on the hsql

     [java] Exception in thread "HSQLDB Connection @56f3bb82" java.lang.NullPointerException
     [java]     at org.hsqldb.ServerConnection.close(Unknown Source)
     [java]     at Source)
     [java]     at


berlin.brown's picture
Joined: Feb 12 2019 - 10:18am
Last seen: 1 day 14 hours ago

I am using the "demo" samples from jasper reports.  It is clear that the hsqldb is running  as  standalone server.  For example:

//Change these settings according to your local configuration
            String driver = "org.hsqldb.jdbcDriver";
            String connectString = "jdbc:hsqldb:hsql://localhost";
            String user = "sa";
            String password = "";

berlin.brown - 1 year 3 months ago

1 Answer:


I was able to create a jdbc data adapter with the following settings and connect and print values from address table in a report. I've tested using Jaspersoft Studio 6.6.0 and hsqldb in JasperReports 6.8.0.

Note that hsqldb in JasperReports 6.8.0 is version 2.4.0. Jaspersoft Studio 6.6.0 is also using 2.4.0. They should match. If the server and client version do not match, you may get error.

JDBC Driver: org.hsqldb.jdbcDriver

JDBC Url: jdbc:hsqldb:hsql://localhost

Username: sa


1. I open a console in demo/hsqldb directory

2. Execute "ant"

3. Open Jaspersoft Studio 6.6.0 and create a Data Adapter with the above information and clicked on the "Test" button. Returned "Success".

4. Created JasperReports report and used the created data adapter with "SELECT * FROM address".

5. Put all fields in the details band.

6. Did a preview and all data were displayed in my report.


hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 1 month ago