Hibernate Books

All times are UTC - 5 hours [ DST ]



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: HQL QuerySyntaxError for MySQL's MATCH-AGAINST
PostPosted: 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
 Profile  
 
 Post subject:
PostPosted: Fri Jun 24, 2005 5:53 am 
Newbie

Joined: Fri Jun 24, 2005 4:36 am
Posts: 14
Location: Germany
Es sieht so aus, als ob es damit geht:
Code:
Restrictions.sqlRestriction("MATCH (name) AGAINST ('test' IN BOOLEAN MODE)")


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.