Difference between revisions of "HSQLDB:Tips and Tricks"
From Apache OpenOffice Wiki
m (→How to know the version of the embedded HSQLDB?) |
|||
Line 7: | Line 7: | ||
= How to know the version of the embedded HSQLDB? = | = How to know the version of the embedded HSQLDB? = | ||
You can determine the version of the embedded HSQLDB engine with the following Basic macro | You can determine the version of the embedded HSQLDB engine with the following Basic macro | ||
− | <code>[ | + | <code>[oobas] |
Option Explicit | Option Explicit | ||
Revision as of 21:29, 16 November 2005
How to connect to a "normal" (not embedded) HSQL database?
TODO
How to migrate data between embedded and non-embedded HSQLDB?
TODO
How to know the version of the embedded HSQLDB?
You can determine the version of the embedded HSQLDB engine with the following Basic macro
[oobas]
Option Explicit
Sub hsqlVersion
Dim databaseURLOrRegisteredName As String databaseURLOrRegisteredName = "hsqldb" ' adjust this string to your needs. It needs to be the name of a registered database, ' or a complete URL
Dim databaseContext As Object databaseContext = createUnoService( "com.sun.star.sdb.DatabaseContext" )
Dim databaseDocument As Object databaseDocument = databaseContext.getByName( databaseURLOrRegisteredName )
Dim connection As Object connection = databaseDocument.getConnection( "", "" )
MsgBox "product version: " & connection.getMetaData().getDatabaseProductVersion()
connection.close
End Sub Note that this will give you a version number such as "1.8.0", but not "1.8.0.1". To my best knowledge, this last digit in the HSQLDB version cannot be obtained by any means at runtime.