Can we use the one instance of Statment to execute more
than one query ?
Answers were Sorted based on User's Feedback
Answer / sathya
Yes,its possible to use the same instance provided the
Result Set of the first Statement is fetchd out.
|Is This Answer Correct ?||4 Yes||0 No|
Answer / sachin
To make batch updates using a single statement with several
sets of input parameters, follow these basic steps:
Disable AutoCommit for the Connection object.
Invoke the prepareStatement method to create a
PreparedStatement object for the SQL statement with input
For each set of input parameter values:
Execute setXXX methods to assign values to the input
Invoke the addBatch method to add the set of input
parameters to the batch.
Invoke the executeBatch method to execute the statements
with all sets of parameters.
Check for errors. If no errors occurred:
Get the number of rows that were updated by each execution
of the SQL statement from the array that the executeBatch
Invoke the commit method to commit the changes.
|Is This Answer Correct ?||1 Yes||0 No|
What is jdbc odbc in java?
How can I determine the isolation levels supported by my DBMS?
What are the types of jdbc drivers that exist?
What are different types of ResultSet?
What are the considerations for deciding on transaction boundaries?
Is jdbc faster than hibernate?
What is the reason why we need a jdbcrowset like the wrapper around resultset?
wa is connection pooling? how do u create connection pooling?wat is use connection pooling?
why are using type4 driver in realtime projects?
What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?
What are types of jdbc drivers?
What does executeupdate return in jdbc?