[Hibernate] Pb with full text on mysql

[Laurent Fleuriot]

Hi,

 

I have a table in which I have a column having a full-text.

the syntaxe in sql to make a query is (in mysql) : select * from tableA where match (colA, colB) against ('toto')

 

BUT hibernate doesn't understand the query.

 

the exception is :

   

net.sf.hibernate.QueryException: Incorrect query syntax [select doc from core.tableA as doc where MATCH(doc.description, doc.comment) AGAINST (?)]

at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:162)

at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:132)

at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:373)

at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:351)

at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1383)

at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1347)

at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:76)

at fr.capp.database.internal.impl.DocumentSituationImpl.searchSituations(DocumentSituationImpl.java:607)

... 43 more

HELP PLEASE.

 

THANKS