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+h...@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
