So, presumably, if one has setup their install of MySQL to use InnoDB by
default (a transactional engine) the relaxAutoCommit is not needed?
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
--
Dr. Sean Radford, MBBS, MSc
http://www.tacola.com/
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
