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

[Tech One]

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 solution]

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 

[Tech One]

hi - thanks I did find that article and have been able to remove the offending row. Here's some easy commands

java -cp "C:\Program Files\Atlassian\Confluence\confluence\WEB-INF\lib\hsqldb-2.3.0.jar" org.hsqldb.util.DatabaseManager -user sa -url "jdbc:hsqldb:C:/Program Files/Atlassian/Application Data/confluence/database/confluencedb;shutdown=true"

select PLUGINDATAID, PLUGINKEY, FILENAME, LASTMODDATE from PLUGINDATA where pluginkey like '%adaptavist%';

delete from PLUGINDATA where PLUGINDATAID='8978433';

now confluence starts up - presto!

Cheers