How to execute bulk number of queries at once?
Answers were Sorted based on User's Feedback
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 |
Does jdbc require oracle client?
commit() and rollback() methods are defined in which interface?
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
What is the difference between ExecuteUpdate and ExecuteQuery?
What does the connection object represents?
Can I use JDBC to execute non-standard features that my DBMS provides?
Jdbc-odbc bridge is multi-threaded or not?
Why do we use jdbc statements?
Can the JDBC-ODBC Bridge be used with applets?
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?
how do we get the connection from connection pool