GeeCON Prague 2014*
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


JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Batch processing" Watch "Batch processing" New topic
Author

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?

Thanks,
Subhash
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 a.name=? where a.name=?".

Thanks,
Subhash
 
GeeCON Prague 2014
 
subject: Batch processing