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...


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

Does jdbc require oracle client?

0 Answers  


commit() and rollback() methods are defined in which interface?

5 Answers  


Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?

0 Answers  


What is the difference between ExecuteUpdate and ExecuteQuery?

1 Answers   Exilant,


What does the connection object represents?

0 Answers  


Can I use JDBC to execute non-standard features that my DBMS provides?

0 Answers  


Jdbc-odbc bridge is multi-threaded or not?

0 Answers  


Why do we use jdbc statements?

0 Answers  


Can the JDBC-ODBC Bridge be used with applets?

2 Answers  


Hi my doubt is that preparedStatement is a interface means which has no implemenation.plz go thru the code below String sql = "SELECT * FROM movies WHERE year_made = ?"; prest = con.prepareStatement(sql); prest.setInt(1,2002); ResultSet rs1 = prest.executeQuery(); Now setInt and executeQuery how it works since it is interface it does not have implementation how it works, how executeQuery returns result from database as executequery method has no implementation even in Statement interface.

4 Answers   Cybermate, Hexaware,


What is meant by jdbc and odbc?

0 Answers  


how do we get the connection from connection pool

1 Answers  


Categories