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

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