I have a criteria query not really working. Here the model:
Code:
@Entity
public class Flaw extends BaseEntity implements Serializable {
...
@Lob
@Basic(fetch=FetchType.LAZY)
private String text;
...
This query is going to be executed by hibernate (from Logs):
Code:
Hibernate:
select
...
flaw0_.text as col_7_0_,
...
from
Flaw flaw0_,
where
...
and (
flaw0_.text like ?
)
order by
flaw0_.text desc
But then I get the following StackTrace:
Code:
3171 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 42883
3171 [main] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: operator does not exist: text ~~ bigint
3198 [main] INFO org.hibernate.impl.SessionFactoryImpl - closing
If I run the above sql command (produced by hibernate) in the db, everything just works fine. I am using am using Hibernate 3.6.3.
Any Ideas?
BR, Rene
Login
FAQ
Search