How will you insert multiple rows into a database in a single transact

1.	How will you insert multiple rows into a database in a single transaction?
Answer» Follow steps as below //turn off the implicit commitConnection.setAutoCommit(false);//..your insert/update/delete goes hereConnection.Commit();//a new transaction is implicitly started.

How will you insert multiple rows into a database in a single transaction?

Answer»

Follow steps as below

//turn off the implicit commitConnection.setAutoCommit(false);//..your insert/update/delete goes hereConnection.Commit();//a new transaction is implicitly started.

Discussion

No Comment Found

Related InterviewSolutions

What is difference between JDBC, JNDI and Hibernate?
How to Connect to an Excel Spreadsheet using JDBC in Java?
What is Metadata and why should you use it?
Which isolation level prevents dirty read in JDBC, connection class?
What is a "dirty read"?
What are different types of RowSet objects?
What is a RowSet?
What we set the attribute Concurrency in ResultSet?
When you say Class.forName() loads the driver class, does it mean it imports the driver class using import statement?
What does the Class.forName("MyClass") do?

How will you insert multiple rows into a database in a single transaction?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment