Difference between revisions of "HSQLDB:Tips and Tricks"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Reverted edit of 1145025391, changed back to last version by Timarandras)
Line 35: Line 35:
  
 
[[Category:How to]]
 
[[Category:How to]]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<div  style="display:none">
 
[We are delicate. We do not delete your content.]
 
[l_sp99]
 
[http://sitepalace.com/indoortanningbeds/ indoor tanning beds]
 
[http://sitepalace.com/cleo/daybedcomfortersets/ daybed comforter sets]
 
[http://sitepalace.com/cleo/southwesternbedding/ southwestern bedding]
 
[http://sitepalace.com/cleo/leathersectionalsofa/ leather sectional sofa]
 
[http://home.graffiti.net/thomasville_bedding/ thomasville bedding]
 
[http://home.graffiti.net/naturalizer_shoes/ naturalizer shoes]
 
[http://home.graffiti.net/designer_dog_beds/ designer dog beds]
 
[http://mujweb.cz/www/k1visa/ k1 visa]
 
[http://mujweb.cz/www/k1visa/fiancee-visa/ fiancee visa]
 
[http://rivotril.google.if.ua rivotril]
 
[http://republika.pl/cleo06/cingular-ringtone.htm cingular ringtone]
 
[http://republika.pl/cleo06/nail-fungus.htm nail fungus]
 
[http://republika.pl/cleo06/bridesmaid-dress.htm bridesmaid dress]
 
[http://republika.pl/cleo06/formal-prom-dresses.htm formal prom dresses]
 
[http://republika.pl/cleo06/bcbg-shoes.htm bcbg shoes]
 
[http://mysite.com.ua/xdem8200/pagesxdem8200/1_1.html tramadol hcl]
 
[http://mywebpage.netscape.com/burochka/cingular-ringtone.htm cingular ringtone]
 
[http://mywebpage.netscape.com/burochka/bcbg-shoes.htm bcbg shoes]
 
[http://mywebpage.netscape.com/burochka/bridesmaid-dress.htm bridesmaid dress]
 
[http://mywebpage.netscape.com/burochka/formal-prom-dresses.htm formal prom dresses]
 
[http://mywebpage.netscape.com/burochka/nail-fungus.htm nail fungus]
 
[http://www.buddyprofile.com/viewprofile.php?username=tanningbed tanning bed]
 
[http://www.buddyprofile.com/viewprofile.php?username=bcbgshoes bcbg shoes]
 
[http://www.buddyprofile.com/viewprofile.php?username=naturalizershoes naturalizer shoes]
 
[http://www.buddyprofile.com/viewprofile.php?username=leathersectionalsofa leather sectional sofa]
 
[http://www.buddyprofile.com/viewprofile.php?username=designerdogbeds designer dog beds]
 
[http://www.buddyprofile.com/viewprofile.php?username=heatedmattresspad heated mattress pad]
 
[http://www.buddyprofile.com/viewprofile.php?username=bridesmaiddress bridesmaid dress]
 
[http://www.buddyprofile.com/viewprofile.php?username=2006promdresses 2006 prom dresses]
 
[http://www.buddyprofile.com/viewprofile.php?username=formalpromdresses formal prom dresses]
 
[http://www.buddyprofile.com/viewprofile.php?username=sexypromdresses sexy prom dresses]
 
[http://www.buddyprofile.com/viewprofile.php?username=cheappromdresses cheap prom dresses]
 
[http://www.buddyprofile.com/viewprofile.php?username=nextelringtone nextel ringtone]
 
[http://www.buddyprofile.com/viewprofile.php?username=verizonringtones verizon ringtone]
 
[http://www.buddyprofile.com/viewprofile.php?username=cingularringtone cingular ringtone]
 
[http://www.buddyprofile.com/viewprofile.php?username=freesprintringtone free sprint ringtone]
 
[http://www.buddyprofile.com/viewprofile.php?username=freenextelringtone free nextel ringtone]
 
[http://dianabol.google.if.ua dianabol]
 
[http://tribulus-terrestris.blogs.eurosport.com tribulus terrestris]
 
[http://nutrex-lipo-6.blogs.eurosport.com nutrex lipo 6]
 
[http://tribex.blogs.eurosport.com Tribex]
 
[http://xyience.blogs.eurosport.com Xyience]
 
[http://vasopro.blogs.eurosport.com Vasopro]
 
[http://caffeine.blogs.eurosport.com caffeine pills]
 
[http://scifit.blogs.eurosport.com scifit]
 
[http://twinlab.blogs.eurosport.com twinlab]
 
[http://imean.com/blog/faxlesspaydayloans/ faxless payday loans]
 
 
</div>
 

Revision as of 16:45, 14 April 2006

How to connect to a "normal" (not embedded) HSQL database?

  • Connect via JDBC
  • as driver class, use org.hsqldb.jdbcDriver
  • enter the URL to your HSQL database as described in the HSQLDB documentation, and append ;default_schema=true to the URL

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.

Personal tools