Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Java Related >> Java J2EE >> JDBC
  2. Suggest New Category

How to execute bulk number of queries at once?

Question Posted / nimitha

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 does the connection object represents?

0 Answers  

How to create Connection interface object because it is Interface , Interface is not instansiated?

9 Answers   Aptech, CTS, HCL,

Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

0 Answers  

What is the difference between execute, executeQuery, executeUpdate?

0 Answers  

Can I get a null resultset?

0 Answers  

What does executeupdate return in java?

0 Answers  

Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?

0 Answers  

What is a Connection?

1 Answers  

Does jdbc require oracle client?

0 Answers  

How to rollback a JDBC transaction?

0 Answers  

Describe odbc?

0 Answers  

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

10 Answers  

For more JDBC Interview Questions Click Here
Categories