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

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

2 Answers   IBM,


what happen if we set JDBC string to NULL?

0 Answers   Sapient,


What type of drivers are used for web application?

2 Answers  


Is jdbc object oriented?

0 Answers  


What does it mean to "materialize" data?

0 Answers  






Explain in detail about JDBC and its general features?

0 Answers  


Which package contains jdbc api?

0 Answers  


What is Statement and PreparedStatement? whatz the difference?

2 Answers  


What is jdbc and odbc in java?

0 Answers  


What are the common tasks of JDBC?

0 Answers  


What type of driver called is pure Java driver?

3 Answers   Vertex,


what are the types of result sets in JDBC 3.0 ?

3 Answers   HCL,






Categories