On 17 Jun 2007, at 11:42, Sean Radford wrote:
So, presumably, if one has setup their install of MySQL to use
InnoDB by default (a transactional engine) the relaxAutoCommit is
not needed?
Yes I guess. What steps did you use to set up MySQL to use InnoDB by
default?
Anyway if your setup was bad you'd see errors in the logs about
attempted XA commits while "autocommit is true" or something to that
effect. relaxAutoCommit=true cures those.
Florent
Thanks,
Sean
Hi,
I've updated the Administration part of the Nuxeo Book to detail
the steps to configure a full-MySQL setup.
The highlights:
- change the repository config in config/default-repository-
config.xml
- change config/sql.properties
- change platform/nuxeo-platform-search-compass-plugin-5.*.jar/
compass.cfg.xml to use the proper dialect
- change the datasources in datasources/
Note that, as I mention in the book, MySQL needs some specific
datasources configuration:
- nxrelations-default-jena-ds.xml and nxcomment-jena-ds.xml need:
jdbc:mysql://localhost/nuxeo?relaxAutoCommit=true
- nxsearch-compass-ds.xml needs:
jdbc:mysql://localhost/nuxeo?
emulateLocators=true&relaxAutoCommit=true
The relaxAutoCommit part is needed because the default
configuration of MySQL is non-transactional.
The Compass file in the jar will be refactored soon to avoid
having to modify things in an uncompressed jar.
Florent
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
