how do u do multiple updates in the database?

i wanted 2 know how can i do multiple updates in the database at d same time using JSP.

Originally posted by rita aiyar:
i wanted 2 know how can i do multiple updates in the database at d same time using JSP.

Set autocommit off
update 1
update 2
commit

You need to be using a database that supports transactionality (or a single-user DB, or a write-locking DB).

Rita,
JavaRanch is a community of people from all over the world, many of who are not native English speakers. While using abbreviations like "u" instead of spelling out "you" is convenient when text messaging your friends on a cell phone or in a chat room, it presents an extra challenge to those that are already struggling with English. Additionally, such shortcuts may confound automated translation tools that patrons of the Ranch may be making use of.

I would like to ask for your help in making the content of JavaRanch a little easier to read for everybody that visits here by not using such abbreviations.

Thanks,
Jeanne
Forum Bartender