Hibernate Community • View topic - HQL QuerySyntaxError for MySQL's MATCH-AGAINST

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users (Deutsch)

All times are UTC - 5 hours [ DST ]

HQL QuerySyntaxError for MySQL's MATCH-AGAINST

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

skausl

Post subject: HQL QuerySyntaxError for MySQL's MATCH-AGAINST

Posted: Fri Jun 24, 2005 4:45 am

Newbie

Joined: Fri Jun 24, 2005 4:36 am
Posts: 14
Location: Germany

Mit Hibernate 2 war alles OK. Seit der Umstellung auf Hibernate 3 funktioniert Fulltext-Search nicht mehr. Wie lässt sich das Problem beheben?

Hibernate version: 3.0.5

Name and version of the database you are using: MySQL 4.1.11

Full stack trace of any exception that occurs:

Code:

org.hibernate.hql.ast.QuerySyntaxError: 
unexpected token: AGAINST near line 1, column 78 
[from db.Product p where MATCH (name) AGAINST ('test' IN BOOLEAN MODE)]
   at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:63)
   at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:215)
   at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
   at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
   at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
   at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:834)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)

Top

skausl

Post subject:

Posted: Fri Jun 24, 2005 5:53 am