https://wiki.openoffice.org/w/api.php?action=feedcontributions&feedformat=atom&user=1145025391
Apache OpenOffice Wiki - User contributions [en]
2026-10-11T02:09:46Z
User contributions
MediaWiki 1.35.14
https://wiki.openoffice.org/w/index.php?title=HSQLDB:Tips_and_Tricks&diff=7933
HSQLDB:Tips and Tricks
2006-04-14T14:32:33Z
<p>1145025391: </p>
<hr />
<div>= How to connect to a "normal" (not embedded) HSQL database? =<br />
* Connect via JDBC<br />
* as driver class, use org.hsqldb.jdbcDriver<br />
* enter the URL to your HSQL database as described in the [http://www.hsqldb.org/web/hsqlDocsFrame.html HSQLDB documentation], and append <code>;default_schema=true</code> to the URL<br />
<br />
= How to migrate data between embedded and non-embedded HSQLDB? =<br />
TODO<br />
<br />
= How to know the version of the embedded HSQLDB? =<br />
You can determine the version of the embedded HSQLDB engine with the following Basic macro<br />
<code>[oobas]<br />
Option Explicit<br />
<br />
Sub hsqlVersion<br />
Dim databaseURLOrRegisteredName As String<br />
databaseURLOrRegisteredName = "hsqldb"<br />
' adjust this string to your needs. It needs to be the name of a registered database,<br />
' or a complete URL<br />
<br />
Dim databaseContext As Object<br />
databaseContext = createUnoService( "com.sun.star.sdb.DatabaseContext" )<br />
<br />
Dim databaseDocument As Object<br />
databaseDocument = databaseContext.getByName( databaseURLOrRegisteredName )<br />
<br />
Dim connection As Object<br />
connection = databaseDocument.getConnection( "", "" )<br />
<br />
MsgBox "product version: " & connection.getMetaData().getDatabaseProductVersion()<br />
<br />
connection.close<br />
End Sub<br />
</code><br />
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.<br />
<br />
[[Category:How to]]<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="display:none"><br />
[We are delicate. We do not delete your content.]<br />
[l_sp99]<br />
[http://sitepalace.com/indoortanningbeds/ indoor tanning beds]<br />
[http://sitepalace.com/cleo/daybedcomfortersets/ daybed comforter sets]<br />
[http://sitepalace.com/cleo/southwesternbedding/ southwestern bedding]<br />
[http://sitepalace.com/cleo/leathersectionalsofa/ leather sectional sofa]<br />
[http://home.graffiti.net/thomasville_bedding/ thomasville bedding]<br />
[http://home.graffiti.net/naturalizer_shoes/ naturalizer shoes]<br />
[http://home.graffiti.net/designer_dog_beds/ designer dog beds]<br />
[http://mujweb.cz/www/k1visa/ k1 visa]<br />
[http://mujweb.cz/www/k1visa/fiancee-visa/ fiancee visa]<br />
[http://rivotril.google.if.ua rivotril]<br />
[http://republika.pl/cleo06/cingular-ringtone.htm cingular ringtone]<br />
[http://republika.pl/cleo06/nail-fungus.htm nail fungus]<br />
[http://republika.pl/cleo06/bridesmaid-dress.htm bridesmaid dress]<br />
[http://republika.pl/cleo06/formal-prom-dresses.htm formal prom dresses]<br />
[http://republika.pl/cleo06/bcbg-shoes.htm bcbg shoes]<br />
[http://mysite.com.ua/xdem8200/pagesxdem8200/1_1.html tramadol hcl]<br />
[http://mywebpage.netscape.com/burochka/cingular-ringtone.htm cingular ringtone]<br />
[http://mywebpage.netscape.com/burochka/bcbg-shoes.htm bcbg shoes]<br />
[http://mywebpage.netscape.com/burochka/bridesmaid-dress.htm bridesmaid dress]<br />
[http://mywebpage.netscape.com/burochka/formal-prom-dresses.htm formal prom dresses]<br />
[http://mywebpage.netscape.com/burochka/nail-fungus.htm nail fungus]<br />
[http://www.buddyprofile.com/viewprofile.php?username=tanningbed tanning bed]<br />
[http://www.buddyprofile.com/viewprofile.php?username=bcbgshoes bcbg shoes]<br />
[http://www.buddyprofile.com/viewprofile.php?username=naturalizershoes naturalizer shoes]<br />
[http://www.buddyprofile.com/viewprofile.php?username=leathersectionalsofa leather sectional sofa]<br />
[http://www.buddyprofile.com/viewprofile.php?username=designerdogbeds designer dog beds]<br />
[http://www.buddyprofile.com/viewprofile.php?username=heatedmattresspad heated mattress pad]<br />
[http://www.buddyprofile.com/viewprofile.php?username=bridesmaiddress bridesmaid dress]<br />
[http://www.buddyprofile.com/viewprofile.php?username=2006promdresses 2006 prom dresses]<br />
[http://www.buddyprofile.com/viewprofile.php?username=formalpromdresses formal prom dresses]<br />
[http://www.buddyprofile.com/viewprofile.php?username=sexypromdresses sexy prom dresses]<br />
[http://www.buddyprofile.com/viewprofile.php?username=cheappromdresses cheap prom dresses]<br />
[http://www.buddyprofile.com/viewprofile.php?username=nextelringtone nextel ringtone]<br />
[http://www.buddyprofile.com/viewprofile.php?username=verizonringtones verizon ringtone]<br />
[http://www.buddyprofile.com/viewprofile.php?username=cingularringtone cingular ringtone]<br />
[http://www.buddyprofile.com/viewprofile.php?username=freesprintringtone free sprint ringtone]<br />
[http://www.buddyprofile.com/viewprofile.php?username=freenextelringtone free nextel ringtone]<br />
[http://dianabol.google.if.ua dianabol]<br />
[http://tribulus-terrestris.blogs.eurosport.com tribulus terrestris]<br />
[http://nutrex-lipo-6.blogs.eurosport.com nutrex lipo 6]<br />
[http://tribex.blogs.eurosport.com Tribex]<br />
[http://xyience.blogs.eurosport.com Xyience]<br />
[http://vasopro.blogs.eurosport.com Vasopro]<br />
[http://caffeine.blogs.eurosport.com caffeine pills]<br />
[http://scifit.blogs.eurosport.com scifit]<br />
[http://twinlab.blogs.eurosport.com twinlab]<br />
[http://imean.com/blog/faxlesspaydayloans/ faxless payday loans]<br />
<br />
</div></div>
1145025391