I need to execute a "intermedia text" ( or "oracle Text" ) search, how can I do it using Hibernate? is possible?

Maybe using session.reateSQLQuery() which allow you to query using native SQL

An example of a Intermedia Text Query is:

SELECT ID, COMMENT FROM EMP_RESUME
WHERE CONTAINS (COMMENT, '!SMYTHE') > 0 ;

so, it is not a SQL standard Query. Does CreateSQLQuery work with no standard SQL querys?

Thank you very much for your excellent help!!

This should also work in HQL, like
select f from Forum f where contains(f.comment, '!SMYTHE') > 0

I've used Orace text succesfully two ways. Directly using HQL, as per the previous reply, and I also wrote my own extension of the AbstractCriterion class to use the Criteria query method.

This is my SQL ( it works fine ):
[code]SELECT *
FROM bopa b
WHERE
b.nlegis = 7
AND contains(b.resum, 'Andaluc

Check the generated SQL

Restarting the Oracle Server has been the solution to the problem. Now Hibernate seems to work perfectly.