how do we remove plug-in's from a HSQLDB

Question

Confluence web interface is not accessible due to an incompatible plug-in. I want to remove the plug-in but i'm using a HSQLDB database.

startup error:

java.lang.RuntimeException: javax.servlet.ServletException: org.apache.velocity.exception.MethodInvocationException: Invocation of method 'preRender' in class com.adaptavist.confluence.theme.engine.core.BuilderVelocityHelper threw exception java.lang.NoClassDefFoundError: com/atlassian/plugin/osgi/spring/SpringContainerAccessor at engine/theme/login.vmd[line 28, column 16]

I've cleared the plugin cache folders as per article

https://confluence.atlassian.com/confkb/how-to-manually-remove-malfunctioning-add-ons-113705118.html

but cannot delete from PLUGINDATA where PLUGINDATAID='XXXXXX'; as it's a HSQLDB not a MySQL database. unless I can run SQL against a "HSQLDB" DB??

I want to remove the "adaptavist" as per

https://jira.atlassian.com/browse/CONF-31868

Steve Gerstner [bridgingIT] · Accepted Answer

Shutddown Confluence, take a backup of your homefolder und read this link:

http://stackoverflow.com/questions/4990864/best-sql-browser-for-hsqldb

Use the manager from HSQLDB, Squirrel, or any Java-IDE to connect to your HSQLDB.

As long confluence is stopped, you can do any delete operations on the db, you want