select for update using JDBCTemplate like, apologize, message, current, example

amy

Hi all,

First of all, I apologize to post the same message in two forums (dataAccess and here), but I couldn't delete from the other one.

I'd like to know how to perform a 'select for update query' using JDBCTemplate.
Once I make the query:
Code:
select ID_MOVIE, NAME, DESCRIPTION from T_MOVIES where ID_MOVIE gt; 10 AND ID_MOVIE lt; 20 for update
Then, I have to do:
Code:
update T_MOVIES set DESCRIPTION = ? where current of ?
But I don't know how to do!!! I've tried to find an example, but I didn't get it using JDBCTemplate.

Can you help me? An example or a site explaining it will be enough... I hope

Thanks a lot!!!