It works great now, thanks a lot !!!
Florent Guillaume wrote:
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
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
