This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Batch processing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Batch processing" Watch "Batch processing" New topic

Batch processing

subhashchandra medhiassam
Ranch Hand

Joined: Sep 10, 2008
Posts: 72
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:

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?

subhashchandra medhiassam
Ranch Hand

Joined: Sep 10, 2008
Posts: 72
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 where".

I agree. Here's the link:
subject: Batch processing
Similar Threads
Join using HQL
Issue with Hibernate Update Basi Query
HQL Inner Join problem
What causes Hiberante to issue a SQL update command
Batch Delete Problem