Here are the steps (my usual style of writing blogs that never goes out of style)
1> Open Netbeans
2> Make sure you have the Services window available (if not select it from the Window menu)
3> Right click on the Drivers folder and select New Driver...
4> Add the hsqldb.jar from the hsqldb/lib folder and let Netbeans autodetect the driver class to be org.hsqldb.jdbcDriver and the name to be HSQLDB
5> Right click on the newly created HSQLDB class folder and select Connect Using ...
6> Specify the following
- Name : HSQLDB (Server)
- User Name : SA
- Password : <blank>
- JDBC URL : jdbc:hsqldb:hsql://localhost/
8> Select Public
9> Netbeans will create this New database connection as jdbc:hsqldb:hsql://localhost/ [SA on Public], Under which it will list the Tables, Views, Procedures.
10> From here on, we can right click on the contents under this connection folder to perform various DDL and DML operations.