CODEWITHSUNDEEP
javahibernatehql
Nilam Naghor
Nilam Naghor

Reputation: 55

query must begin with select or from: update

I'm using this code for update occupation but I'm getting an error like query must begin with select or from : update so please help me:

public static void changeOccup(String email,String occup){
 try{  Session sess=UtilClass.createSession();
  Transaction tx=sess.beginTransaction();Query que=sess.createQuery("update Userrecord set occupation=occup where emailId=email");
  que.setParameter("occup", occup);
  que.setParameter("email", email);
  int result=que.executeUpdate();
  JOptionPane.showMessageDialog(null,"occup changed"+result);
    tx.commit();
 }

Upvotes: 1

Views: 2811

Answers (2)

Nilam Naghor
Nilam Naghor

Reputation: 55

Problem solved.. i have used method update of session

public static void changeOccup(String email,String occup){Session sess=null;try{sess=UtilClass.createSession();Transaction tr=sess.beginTransaction();Userrecord u=(Userrecord) sess.get(Userrecord.class, email); u.setOccupation(occup); sess.update(u);tr.commit();}catch(Exception e){} }

Upvotes: 0

developerwjk
developerwjk

Reputation: 8659

Use SQLQuery and createSQLQuery instead of Query and createQuery. If you're using Query and createQuery you have to use Hibernate's syntax. If you want regular SQL syntax, use SQLQuery.

Upvotes: 1

Related Questions