# HSQLDB

| Vendor Name                                                                                                                                                                                                                                                                                                                                                                      | Details                                                                              |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------ |
| Recommended Native Driver                                                                                                                                                                                                                                                                                                                                                        |                                                                                      |
| HyperSQL                                                                                                                                                                                                                                                                                                                                                                         | <p>Company URL:</p><p><a href="http://www.hsqldb.org/">http://www.hsqldb.org</a></p> |
| <p>Driver URL:</p><p><a href="http://sourceforge.net/projects/hsqldb/">http://sourceforge.net/projects/hsqldb/</a></p>                                                                                                                                                                                                                                                           |                                                                                      |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:hsqldb:hsql://&#x3C;server>[:&#x3C;port>]/&#x3C;databaseName></code></p><ul><li><strong>Embedded Memory</strong></li></ul><p><code>jdbc:hsqldb:mem:&#x3C;databaseName></code></p><ul><li><strong>Embedded File</strong></li></ul><p><code>jdbc:hsqldb:file:&#x3C;database-file></code></p> | <p>Default Port:</p><p>9001</p><p>N/A</p><p>N/A</p>                                  |
| <p>JDBC Class:</p><p><code>org.hsqldb.jdbcDriver</code></p>                                                                                                                                                                                                                                                                                                                      | <p>JDBC JAR File Name:</p><p><code>hsqldb.jar</code></p>                             |
| <p>Shipped with Pentaho products:</p><ul><li>Pentaho User Console</li><li>Pentaho Server</li><li>Pentaho Aggregation Designer</li><li>Pentaho Data Integration</li><li>Pentaho Metadata Editor</li><li>Pentaho Report Designer</li></ul>                                                                                                                                         |                                                                                      |
