Re: [libreoffice-users] Re: Urgent Base problem

THANKS for that, I must admit I've gotten "spoilt" by lots of years on Windows now, expect one 
install file to set up a program, and never having to use a command line -- even for Windows the 
program HSQLDB still encourages people to use command lines for some things

Mind you, I don't mind learning again, if one is learning to do things more reliably and or 
powerfully

Rusty
in more ways than one I'm rusty ;-)



----- Original Message -----
> From: Andreas Säger <villeroy@t-online.de>
> To: users@global.libreoffice.org
> Cc: 
> Sent: Sunday, 18 March 2012 10:25 PM
> Subject: [libreoffice-users] Re: Urgent Base problem
>
> Am 18.03.2012 08:56, Mark Stanton wrote:
> > >  I think the point Mark was making was to switch away from using the
> > >  embedded back-end to pretty much any external one.  Which is what
> > >  you often suggest too.
> >
> >  Yes indeed.
> >  Can HSQLDB be used as an external engine?  I thought not, which is why I 
> didn't
> >  include it.
> >
> >  Mark Stanton
> >  One small step for mankind...
>
> http://hsqldb.org
> Download the latest version.
> Put it somewhere in your libraries (no installation required).
> Point your office Java to the extracted hsqldb.jar.
> Extract ./database/ from your embedded database somewhere to your files.
> Rename your database files with a common "dbname." prefix.
> Connect a new Base document using JDBC with an URL like this one (refer to the 
> downloaded documentation in your libs):
> >  jdbc: 
> hsqldb:file:/home/andreas/hsqldb-2.2.5/databases/Praxis/hsqldbdata/db0/chargen;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
> Copy over the queries, forms and reports from your embedded thing.
>
> You get the latest version of a full featured HSQLDB without restrictions, many 
> more functions, the access control and safety you would expect from a database 
> application.
> You can write a configuration file to run a server for concurrent access.
>
> Drawbacks:
> - Embedded HSQL requires another Java config. I use OOo for embedded and LibO 
> 3.3.4 for "normal" access.
> - Base can not handle user defined row filters with HSQLDB2. I use my own 
> "power filters" anyway.
>
>
> -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted