Difference between revisions of "HSQLDB:Tips and Tricks"
From Apache OpenOffice Wiki
Timarandras (Talk | contribs) m (Category How to) |
1145025391 (Talk | contribs) |
||
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 14:32, 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.