CODEWITHSUNDEEP
jbossversionhsqldb
kostja
kostja

Reputation: 61568

how to figure out the HSQLDB version of a given JBoss instance

Any way is fine - console, web interface, programmatically...

I was unable to find the DB version in the web interface yet and even the jars in the {$JBOSS_HOME}/common/lib don't have the version in the filename.
The JBoss version is 5.1 EAP
Thank you

Upvotes: 2

Views: 2167

Answers (3)

Lukas Eder
Lukas Eder

Reputation: 221195

You can also detect the HSQLDB version using SQL

select character_value
from information_schema.sql_implementation_info
where implementation_info_name = 'DBMS VERSION'

Upvotes: 0

guest
guest

Reputation: 1

If there is no database properties file handy, try unzipping hsqldb.jar, and looking in the META-INF/MANIFEST.MF file for something like this:

Specification-Version: 1.8.0.10

Upvotes: 0

William
William

Reputation: 13632

If you go to where the HSQLDB database is stored:

{$JBOSS_HOME}/Server/XXX/data/hypersonic

and open the localDB.properties file, at the top it will have the version, like this:

#HSQL Database Engine 1.8.0.8

Upvotes: 3

Related Questions