How to Reverse Engineer HSQL DB With Spring Roo

  • 10/4/2012
  • One-minute read

Running database introspect --schema no-schema-required against an HSQL database may fail with No driver class available if the JDBC driver is not packaged as a Roo addon.

Resolution

Install the official HSQL driver wrapping addon inside the Roo shell:

osgi install --url http://spring-roo-repository.springsource.org/release/org/springframework/roo/wrapping/org.springframework.roo.wrapping.hsqldb/1.8.0.10.0001/org.springframework.roo.wrapping.hsqldb-1.8.0.10.0001.jar

After installation, rerun the introspection command. Roo loads the driver from the addon bundle and generates the entity scaffolding correctly.

Additional Tips

  • Confirm the database properties are set to the correct JDBC URL, username, and password before introspection.
  • For modern projects, prefer Spring Data JPA with Spring Boot, which manages JDBC drivers via Maven/Gradle dependencies.
  • Decommission or upgrade legacy Roo applications; the project entered maintenance mode and no longer receives regular updates.
javaspringdatabasedevelopmenttutorial