Answer / kalyan

we can update multiple statements using batch as follows

statemenent st = getconnection().getStatement();
st.addBatch(sql stat1);
st.addBatch(sql stat2) ;

....

st.executeBatch();

Answer / guest

through batch update.

Answer / salil kumar

To execute bulk number of queries at once genally we are
using store procedure i.e. CallableStatement. Through store
procedure we can execute bulk number of queries at once to
the differnt-differnt table also.

What is JDBC Batch Processing and what are it’s benefits?

0 Answers  

---

Can you create an index on sex column where there is M or F?

1 Answers   Wipro,

---

What are clob and blob data types in jdbc?

0 Answers  

---

How does jdbc connect to database?

0 Answers  

---

HI ALL, How to Overcome "OutOfMemoryException"? when I am compiling source having more than 1000 LOC throwing this exception. Can any one give correct answer to my question? thx

5 Answers  

---

---

What is ojdbc?

0 Answers  

---

How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

0 Answers  

---

What will happen when ResultSet is not closed?

1 Answers   CTS,

---

Is jdbc an api?

0 Answers  

---

What is meant by a ResultSet?

3 Answers  

---

what are the drawbacks of JDBC? explain briefly?

5 Answers  

---

How can we store and retrieve images from the database?

0 Answers  

---