Batch processing

[subhashchandra medhiassam]

Hi all,
I have a table a1 in MYSQL. Its columns are "identity"(type int) and "name"(type varchar).

I am having two entries in table a1 whose "name" column has value = abc.

I am trying to set the value of the "name" column of these two entries using batch update.

Here's the code fragment:

 public static void main(String[] args) {
Session session = null;
    try {
      // This step will read hibernate.cfg.xml and prepare hibernate for
      // use
      SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
      session = sessionFactory.openSession();
      Transaction tx = session.beginTransaction();
      Query query = session.createQuery("Update a1 set name=? where name=?");
      query.setString(0,"xyz");
      query.setString(1,"abc");
      query.executeUpate();
      tx.commit();
      
    } catch (Exception e) {
      System.out.println(e.getMessage());
    } finally {
session.flush();
session.close();
    }    
 
    
    }   

But when i run this program, i am getting the following message:

expecting DOT, found '=' near line 1, column 19 [Update a1 set name=? where name=?]

Could anybody kindly tell me where i went wrong and what i should do to rectify the error?

Thanks,
Subhash

[subhashchandra medhiassam]

hi all,
My problem has been fixed. I have changed the HQL query a bit and its working now.

My changed query is "Update a1 a set a.name=? where a.name=?".

Thanks,
Subhash