How to execute bulk number of queries at once?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of drivers under jdbc?
Result set’s index starts with 0 or 1?
What does connection pooling mean ?
In which ways is driver class is registered with drive manager?
What do you mean by odbc?
What is in term of jdbc a datasource?
Why isn't the java.sql.DriverManager class being found?
How many types of jdbc drivers are available?
Explain about column name and getter method?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
What are the classes and methods used for sending sql statements to database?
What is SQL Warning? How to retrieve SQL warnings in the JDBC program?
Why prepared statements are faster?
What is database connection pooling? Advantages of using a connection pool?
RowSetInternal caller and returns void. What can I do in the readData method?