On Jun 5, 2007, at 9:53 AM, 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).
Hi there:
About the Compass Search Service backend, I've so far tested it
successfully with PostgreSQL(besides HSQL). I'll have to make it work
with MySQL for 5.1, but it's not on top of my todo list right now,
although I'd appreciate if you created the corresponding ticket in
the jira tracker ;-)
Greetings,
GR
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
---------
Georges Racinet, Nuxeo SAS
Open Source Enterprise Content Management (ECM)
Web: http://www.nuxeo.com/ and http://www.nuxeo.org/ - Tel: +33 1 40
33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
