Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How to execute bulk number of queries at once?

Answers were Sorted based on User's Feedback



How to execute bulk number of queries at once?..

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();

Is This Answer Correct ?    7 Yes 0 No

How to execute bulk number of queries at once?..

Answer / guest

through batch update.

Is This Answer Correct ?    5 Yes 0 No

How to execute bulk number of queries at once?..

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.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer



More JDBC Interview Questions

What is SQL Warning? How to retrieve SQL warnings in the JDBC program?

0 Answers  


Is jdbc database independent?

0 Answers  


What are the higher level apis under development on top of jdbc currently?

0 Answers  


How to set NULL values in JDBC PreparedStatement?

0 Answers  


What does adapter class provide?

0 Answers  






How to handle when the database crashes while reading the data from the database?

2 Answers   IBM,


What is Type-2 Driver and when this driver is used?

2 Answers  


What is xe in oracle jdbc url?

0 Answers  


What does it mean to "materialize" data?

0 Answers  


Can you define a foreign key, with a key from the same table?

2 Answers   IBM,


What is meant by a ResultSet?

3 Answers  


What is java soft framework?

0 Answers  






Categories