We have setup Nuxeo 5.3 with MS SQL Server, everything works but fulltext
searches (normal searches do). When we try a fulltext search we get no results
and the following trace:
2010-01-12 09:34:22,281 DEBUG
[org.nuxeo.ecm.core.search.api.client.querymodel.QueryModel] execute query:
SELECT * FROM Document WHERE ecm:fulltext LIKE 'test' AND ecm:mixinType !=
'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
ecm:currentLifeCycleState != 'deleted'
2010-01-12 09:34:22,281 DEBUG [org.nuxeo.ecm.core.api.ejb.DocumentManagerBean]
Initializing session for repository: default
2010-01-12 09:34:22,297 DEBUG
[org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionImpl] getConnection:
org.nuxeo.ecm.core.storage.sql.ra.managedconnectioni...@653b8e
2010-01-12 09:34:22,297 DEBUG
[org.nuxeo.ecm.core.storage.sql.ra.ManagedConnectionImpl] addConnection:
org.nuxeo.ecm.core.storage.sql.ra.connectioni...@1ac5fd7
2010-01-12 09:34:22,312 ERROR
[org.nuxeo.ecm.webapp.pagination.ResultsProvidersCacheBean] failed to obtain
sorted resultProvider
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: The column
prefix 'fulltext' does not match with a table name or alias name used in the
query.
at
org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1404)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
at
org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
at
org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
at
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
...
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.query.QueryException. message: Invalid query: SELECT * FROM
Document WHERE ecm:fulltext LIKE 'test' AND ecm:mixinType !=
'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
ecm:currentLifeCycleState != 'deleted'
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:473)
at
org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1351)
... 168 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.nuxeo.ecm.core.storage.StorageException. message: Invalid query: SELECT *
FROM Document WHERE ecm:fulltext LIKE 'test' AND ecm:mixinType !=
'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
ecm:currentLifeCycleState != 'deleted'
at org.nuxeo.ecm.core.storage.sql.Mapper.query(Mapper.java:1930)
at
org.nuxeo.ecm.core.storage.sql.SessionImpl.query(SessionImpl.java:634)
at
org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.query(ConnectionImpl.java:267)
at
org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession$SQLSessionQuery.execute(SQLSession.java:468)
... 169 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
java.sql.SQLException. message: The column prefix 'fulltext' does not match
with a table name or alias name used in the query.
at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
We've tried with JDTS 1.2.2, 1.2.4 and 1.2.5, any ideas of what's wrong here?
--
Posted by "aldago" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread:
<http://www.nuxeo.org/discussions/thread.jspa?threadID=3195#9497>
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
