[Hibernate] Exception with full text search methods of mysql database.

[Laurent Fleuriot]

Does Hibernate support the generation of SQL that will invoke the full text search methods of certain databases? For example, both MySQL (Full Text Search)  have specific syntax within a SQL statement to perform the search against a column that has a full text search index defined.

 

For example, the needed SQL syntax would look like the following:

mysql> SELECT  *
FROM tableA
WHERE MATCH (title,body) AGAINST ('database');

I have an exception :

 

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)

 

 

Please, could you hep me???

Thanks.