1. Best way to implement a keyword search from a MySQL CLOB or VARCHAR column stackoverflow.comI have to implement a keyword search from a CLOB column in my MySQL / JPA project.
I know that I can use a JPA query something like |
2. i have a clob column , but how can i search it? forum.hibernate.orgI'd also like to query a Clob field. Other than this short thread, I haven't found much info. Would it be correct to sum up this issue as "You can't..."? Of course, it's possible using native SQL in the FirstSQL OO database I'm using, via the Clob's toString() method, but this doesn't apply to HQL. I could alway use Session.createSQLQuery(), but ... |
3. Search CLOB column forum.hibernate.orgI have got a Clob column in database, in mapping i have given it as "text" i am using a Oracle 10 g, Hibernate 2. I am getting the following exception 17:14:36,421 INFO [STDOUT] Hibernate: select this.id as id0_, this.description as descript2_0_, this.grouptype as grouptype0 _, this.name as name0_ from groups this where this.grouptype=? and this.name=? 17:14:36,453 WARN [JDBCExceptionReporter] SQL Error: ... |