Apache OpenOffice (AOO) Bugzilla – Issue 81731
OoBase : Db file stored on USB device does not open the tables
Last modified: 2008-05-07 10:48:12 UTC
If you create an HSQLDB database (Database wizard/Setup JDBC connection), you indicate the URL where the HSQLDB files (.data; .script; .lck ...) will be stored. Ex : jdbc:hsqldb:F:/HSQLDB/demo_db OoBase will store the files there, together with the demo_db.odb If F: is located on an USB device, when you connect your device on an other computer where it gets a different driver letter (say H:), you can open demo_db.odb file with OoBase. But it will not find the tables, unless you manually modify the properties via the menu "Edit/Databse/Properties".
Created attachment 48320 [details] Databse Properties
clu->regina: may you try this out (i do not have a pc anymore) thx
No, I cannot test it. I haven't got a HSQLDB server. There is no problem with the embedded database. I would not expect that using different drive letters works, if JDBC is organized similar to ODBC. In ODBC on WinXP the connection string contains the drive letter and you must change it, if you move the tables to another drive. But unfortunately I have never used a JDBC Connection, so cannot say anything about it.
back into pool - if anybody can confirm, please do so clu->regina: do not assign issues to me, that you could not confirm ;)
I can confirm that this is how it works - not sure there is a problem from OOoBase point of view. You can use relative addressing. However, this will be based from where OpenOffice.org starts from. So, if OpenOffice.org is also on the usb device you could simply use jdbc:hsqldb:/hsdldb/demo_db If OpenOffice.org is not running from the same usb device, I don't know how exactly you would do this.
=> close