Showing unexpected token while executing Hibernate Query

Question

When i excuting below query showing org.hibernate.hql.ast.QuerySyntaxException: unexpected token: AGAINST near line 1, column 106 [SELECT NAME,address,country,district,state,cpr_no,age FROM tbl_patient_general WHERE MATCH (NAME,cpr_no) AGAINST (:params)]

            Query q3 = session.createQuery("SELECT NAME,address,country,district,state,cpr_no,age FROM tbl_patient_general WHERE MATCH (NAME,cpr_no) AGAINST (:params)");
            q3.setParameter("params", name);

I guess the table name is wrong!! what is the beans/hibernate-pojo's name ? — coding_idiot
– coding_idiot, Commented Aug 5, 2013 at 18:45

Luca Basso Ricci · Accepted Answer · 2013-08-05 13:14:05Z

1

Are you using native SQL or HQL? In first case use session.createSQLQuery().
AGAINST is not an HQL function/reserved word

answered Aug 5, 2013 at 13:14

Luca Basso Ricci

18.5k2 gold badges51 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Showing unexpected token while executing Hibernate Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related