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 are the flow statements of jdbc?

0 Answers  


Explain in detail about JDBC and its general features?

0 Answers  


What is execute(), executeUpdate() and executeQuery() methods?

10 Answers  


What is meant by a ResultSet?

3 Answers  


what is connection pooling?

6 Answers   Wipro,


In JDBC, All the API?s are interfaces? Where is the actual implementation?

3 Answers   HCL,


What is Connection Pooling ??? How we set up a particular connection within connection pooling ????

2 Answers   Cognizant,


What is db client?

0 Answers  


Which interface handles transaction management in jdbc?

0 Answers  


How we store procedure in oralce for callable statements in jdbc

0 Answers  


What is 2-tier and 3-tier architecture?

1 Answers   TCS,


What is the full form of jdbc and what is its purpose?

0 Answers  


Categories