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.

Why prepared statements are faster?

0 Answers  

---

What is jdbc in dbms?

0 Answers  

---

give me a java code snippet to connect Microsoft excel through.... I am trying alot... plz help me.

7 Answers  

---

Which is best database for java?

0 Answers  

---

What are clob and blob data types in jdbc?

0 Answers  

---

---

What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?

0 Answers  

---

Which interface handles transaction management in jdbc?

0 Answers  

---

What is the difference between jdbc and odbc?

0 Answers  

---

Why do I have to reaccess the database for Array, Blob, and Clob data?

0 Answers  

---

Differentiate between stored procedure and functions?

0 Answers  

---

Explain the various types of locking system in jdbc?

0 Answers  

---

Explain the life cycle of jdbc.

0 Answers  

---