09-22-2011 10:14 AM
Hi, I'm trying to use sql express 2008 with Nuxeo DM. Here's a part of the config file:
# nuxeo.templates=default
nuxeo.templates=mssql
# nuxeo.db.user=nuxeo
nuxeo.db.user=nuxeo\_db\_user
# nuxeo.db.password=password
nuxeo.db.password=123
# nuxeo.db.host=localhost
nuxeo.db.host=localhost\\sqlexpress
but the database isn't created and in the server logs I have:
2011-09-22 18:05:01,265 ERROR [org.nuxeo.ecm.platform.ui.web.auth.plugins.AnonymousAuthenticator] java.lang.RuntimeException: Unkown user directory userDirectory
...which it seems that at the end of the stack trace comes from
org.nuxeo.ecm.core.api.WrappedException: Exception: java.net.UnknownHostException. message: localhost\sqlexpress
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:305)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:323)
09-23-2011 09:20 AM
Nuxeo uses jtds for the underlying connection and builds the jdbc url this way: jdbc:jtds:sqlserver://${nuxeo.db.host}:${nuxeo.db.port}/${nuxeo.db.name};useCursors=true
According to what I can see about jtds and named instances you have two options:
09-23-2011 04:10 AM
nuxeo.db.host must be a hostname or IP address, in your case it would be localhost if your MS SQL Express instance is running on the same machine as nuxeo.
09-23-2011 09:12 AM
Yes but as you can see the server is set up as a named instance (SQLEXPRESS), so localhost isn't sufficient. Does NUXEO support connecting to named instances of SQL Server? Thank you for your time.
09-23-2011 09:20 AM
Nuxeo uses jtds for the underlying connection and builds the jdbc url this way: jdbc:jtds:sqlserver://${nuxeo.db.host}:${nuxeo.db.port}/${nuxeo.db.name};useCursors=true
According to what I can see about jtds and named instances you have two options:
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.