Re: [libreoffice-users] Re: Base Field Defaut Disables Save

That's a huge help, thanks.  I suppose this raises the question, why does Base default to file 
mode?  Simplicity?

merci,
              tod

On May 3, 2011, at 11:03 AM, Alexander Thurgood wrote:

> Le 03/05/11 16:17, Tod Hopkins a écrit :
>
> Hi Tod,
>
> > Thanks for the advice.  By "mixed-mode" you mean the use of HSQLDB front end with MySQL (or 
> > other) backend?
>
> Sorry, I should have made myself clearer. By mixed-mode of HSQLDB, I
> meant that the hsqldb.jar (which is provided with LibO and OOo as the
> built-in database engine) can be used in client (aka file) and server
> mode depending on the parameters given to it on start-up, providing
> certain tweaks are carried out beforehand. In file mode, only one user
> can access the db at any given time. However, in server mode, you can
> have concurrent multiple user access.
>
>
> An explanation of how to set this up is provided in a tutorial available
> on the openoffice.org forum :
>
> http://www.oooforum.org/forum/viewtopic.phtml?p=396523#396523
>
> If you really want to stick with hsqldb as the database engine, then you
> should go and read through this material.
>
>
> > I've been trying to read what documentation there is.  Not much.  I find that as soon as I get 
> > beyond what I already understand, there is a presumption that I that I have a working knowledge 
> > of SQL, which I don't.  
> >
> > So, since my goal is multi-user database, for which I now see that I need MySQL anyway, I figure 
> > I should turn to learning MySQL. 
>
>
> Well, mysql as a backend is but one alternative, and as I mention above,
> not the only one that you can use if you want multiple user, concurrent
> access to the db. Your base file (ODB file) then becomes a front-end
> "container" for the backend server. I suppose the main advantage of
> using mysql as a back end with LibO is that the native mysql connector
> provided as an installable extension enables fairly comprehensive
> management of the different data types supported by mysql and actually
> pretty good performance without having to tweak cache memory settings
> and whatnot. It still has its "gotchas" though, in fact all of the
> available connectors (ODBC/JDBC) for mysql do. Unfortunately, these are
> not widely documented, and often can only be found by trawling through
> bug reports on multiple sites.
>
>
> Alex
>
>
> -- 
> Unsubscribe instructions: E-mail to users+help@libreoffice.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be deleted

Tod Hopkins
Hillmann & Carr Inc.
todhopkins@hillmanncarr.com




-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted