The solution is to use in your datasource a connection url like:
<connection-url>
jdbc:mysql://localhost/yourdatabase?emulateLocators=true
</connection-url>
The emulateLocators=true parameter is important. This has been tested
with MySQL driver mysql-connector-java-3.1.13.jar.
For reference, see
http://static.compassframework.org/docs/latest/jdbcdirectory.html
and
http://jira.compassframework.org/browse/CMP-335
We'll add this to the docs (or as commented values in the
configuration for starters).
Florent
On 5 Jun 2007, at 09:53, Vincent Dutat wrote:
Hi,
I am in the exact same situation, with the same exceptions, I even
changed/removed the dialectClass attribute in nuxeo.ear/platform/
nuxeo-platform-search-compass-plugin-5.1-SNAPSHOT.jar/
compass.cfg.xml but it did not solve the problem. (FYI I posted a
message yesterday).
Regards.
Sean Radford wrote:
Hi,
Has anyone got Nuxeo to fully use MySQL?
I have got the head to successfully use MySQL for the main
repository, but have problems with the other services. For these I
have:
1. configured my MySQL server for default engine of InnoDB
2. created the database with correct user access.
3. amended the datasources/***.xml files
4. amended config/comment-relations-bundle.xml to databaseType
MySQL (also tried MYSQL
5. amended config/nxrelations-default-jena-bundle.xml to
databaseType MySQL (also tried MYSQL
All seems to go ok on boot-up but when I try to create a document
I get set of stacktrace in the log. Afraid I haven't fully had
time yet to investigate yet, but:
1. I have no tables in: NXRELATIONS_DEFAULT_JENA or NXSEARCH_COMPASS
2. On going to the 'New Workspace' form I get:
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No
operations allowed after connection closed.
3. On saving my 'new workspace' I get:
Failed to create dir [index_nxdocs]; nested exception is
org.apache.lucene.store.jdbc.JdbcStoreException:
Failed to execute [create table index_nxdocs (name_ varchar(50) ,
value_ longvarbinary , size_ integer , lf_ timestamp , deleted_
bit, primary key (name_) ) ];
The workspace saves, but I'm guessing is not being indexed.
Any ideas? (sorry if there is an obvious problem, and I'm a little
premature in my posting)
Thanks and regards,
Sean
---
Dr. Sean Radford, MBBS, MSc
http://www.tacola.com
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
--
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
