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
