More than 1 preparedStatement object

**swati.jyoti** · 06-02-2009, 08:28 AM

Hey but i want to use more than one preparedStatement object using batch update

**RamyaSivakanth** · 06-02-2009, 10:03 AM

Hi,
Iam not getting you.
1.For a single PreparedStatement object u can pass single query using that you can insert/update multiple values as a batch(i.e) single transaction.For each and every value passing you have to call "addbatch().Finally you have to call executeBatch().So,entire batch will be executed in a single transaction.
One PreparedStatement object contains only one query.

2.Again if you want to have differenent query you need to create another PreparedStatement object and do the same process what I mentioned in the above step.

-Regards
Ramya

**Eranga** · 06-02-2009, 10:03 AM

Yes, it's possible. It's better to look at this example.

Use Batch Multiple Updates with PreparedStatement : Batch Update*«*Database*«*Java Tutorial

**DarrylBurke** · 06-02-2009, 10:18 AM

New To Java - More than 1 preparedStatement object using batch update

**RamyaSivakanth** · 06-02-2009, 10:37 AM

Hi Swathi,
Already we have discussed regarding this with example.I don't know why you are getting doubts.Please go thru this thread for recalling what we did and send the piece of code what u have tried now.

http://www.java-forums.org/database/...t-queries.html

-Regards
Ramya