Hibernate version:
3.0
Full stack trace of any exception that occurs:
[SELECT new Ad (ad.id, ad.date, ad.showImage, ad.headline, ad.region,
ad.category, ad.price) FROM com.buysell.server.model.Ad ad
WHERE MATCH (maintext,headline) AGAINST ('(searchwords )' IN
BOOLEAN MODE) AND ad.status = '1' AND ad.buysell = '2' order by
ad.date desc];
nested exception is
org.hibernate.hql.ast.QuerySyntaxError: unexpected token: AGAINST near line 1,
column 161 [SELECT new Ad (ad.id, ad.date, ad.showImage, ad.headline, ad.region,
ad.category, ad.price) FROM com.buysell.server.model.Ad ad WHERE MATCH (maintex
t,headline) AGAINST ('(administrator )' IN BOOLEAN MODE) AND ad.status = '1' AND
ad.buysell = '2' order by ad.date desc]
Name and version of the database you are using:
mysql-4.1.12
text
I have upgrade from hibernate2 to hibernate3.0 and encounter a problem with my native sql question where I use MySQL specific key word AGAINST. I have tryed the MySQLDialect, MySQLInnoDBDialect and MYSQLMyISAMDialect. Im using springframework 1.2.5 and mysql-connector-java-3.1.12-bin.jar
Anyone who can give me a clue....
I can add everything was working perfectly in hibernate2, no changes in sql code have been done.
regards mike
_________________ kmike
|