|Home |Login |Registration |Struts Step by Step Tutorial |Hibernate Step by Step Tutorial |Spring Step by Step Tutorial |JSP Step by Step Tutorial |JDBC Step by Step Tutorial |Web Services Step by Step Tutorial |EJB fundamentals | ORACLE Step by Step Tutorial | SCJP 5.0 and SCJP 6.0 Study Guide | SCWCD 5.0 Study Guide | SCJP Tips
Java mock test | SCJP mock test | SCJP DUMP | SCBCD mock test |Java online test exam | JSP online test | ORACLE online test | Hibernate online test | Servlet online test | Struts online test | EJB online test | C online test | C++ online test | Aptitude online test

Java interview questions | JSP interview questions | ORACLE interview questions | Hibernate interview questions | Servlet interview questions | Struts interview questions | JDBC interview questions | C/C++ interview questions | Spring interview questions | JMS interview questions | Informatica interview questions | EJB interview questions | OOPS and Design Pattern interview questions
1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc) JobsJobs and Walkins

 

Recent Questions

!!! JDBC Frequently Asked Questions !!!

Q. What is Batch Updates Using Statements in JDBC ?

SCJP 1.5/1.6 Exam Kit

!!!Answer!!!- From Technical Expert

Batch Updates calls to database as a chunk.
If you want to run more than one sql statement in a single database call then you have to go for Batch Update.
All Insert in single data base call and single transaction ( if one fail the all fail)

For Example :
public class TestDB {
public static void main(String[] args) {
try {

/** Loading the driver*/

Class.forName("com.oracle.jdbc.Driver");

/** Getting Connection*/
Connection con = DriverManager.getConnection("jdbc:oracle://localhost:3306/test","test","test");

/** Creating Statement*/
con.setAutoCommit(false); // This means after all insert then commit at last
Statement stmt = con.createStatement();
        stmt.addBatch("INSERT INTO EMP VALUES(1,'Ram1')");
        stmt.addBatch("INSERT INTO EMP VALUES(2,'Ram2')");
        stmt.addBatch("INSERT INTO EMP VALUES(3,'Ram3')");
        stmt.addBatch("INSERT INTO EMP VALUES(4,'Ram4')");
        int [] updateCounts= stmt.executeBatch();
        con.commit();
        con.setAutoCommit(true);
        /// All Insert in single data base call and single transaction ( if one fail the all fail)

stmt.close();
con.close();

} catch (Exception e) {

e.printStackTrace();
}
     }
}

Answered By : null Replied Date : Mar 29 2012
Answer :


Answered By : null Replied Date : Mar 28 2012
Answer :


Answered By : null Replied Date : Mar 26 2012
Answer :


Answered By : null Replied Date : Mar 25 2012
Answer :


Answered By : null Replied Date : Mar 24 2012
Answer :


Answered By : null Replied Date : Mar 23 2012
Answer :


Answered By : null Replied Date : Mar 21 2012
Answer :


Answered By : null Replied Date : Mar 19 2012
Answer :


Answered By : null Replied Date : Mar 18 2012
Answer :


Answered By : null Replied Date : Mar 15 2012
Answer :


Answered By : null Replied Date : Mar 11 2012
Answer :


Answered By : null Replied Date : Mar 9 2012
Answer :


Answered By : null Replied Date : Mar 6 2012
Answer :


Answered By : null Replied Date : Mar 5 2012
Answer :


Answered By : null Replied Date : Mar 5 2012
Answer :


Answered By : null Replied Date : Mar 1 2012
Answer :


Answered By : null Replied Date : Feb 24 2012
Answer :


Answered By : null Replied Date : Feb 23 2012
Answer :


Answered By : null Replied Date : Feb 22 2012
Answer :


Answered By : null Replied Date : Feb 21 2012
Answer :


Answered By : null Replied Date : Feb 7 2012
Answer :


Answered By : null Replied Date : Feb 5 2012
Answer :


Answered By : null Replied Date : Feb 2 2012
Answer :


Answered By : null Replied Date : Jan 26 2012
Answer :


Answered By : null Replied Date : Jan 14 2012
Answer :


Answered By : null Replied Date : Jan 3 2012
Answer :


Answered By : null Replied Date : Jan 3 2012
Answer :


Answered By : null Replied Date : Jan 2 2012
Answer :


Answered By : null Replied Date : Jan 2 2012
Answer :


Answered By : null Replied Date : Nov 26 2011
Answer :


Answered By : null Replied Date : Oct 26 2011
Answer :


Answered By : null Replied Date : Oct 15 2011
Answer :


Answered By : null Replied Date : Oct 4 2011
Answer :


Answered By : null Replied Date : Sep 26 2011
Answer :


Answered By : null Replied Date : Sep 26 2011
Answer :


Answered By : null Replied Date : Aug 29 2011
Answer :


Answered By : null Replied Date : Aug 16 2011
Answer :


Answered By : null Replied Date : Aug 16 2011
Answer :


Answered By : null Replied Date : Aug 6 2011
Answer :


Answered By : null Replied Date : Aug 6 2011
Answer :


Answered By : null Replied Date : Aug 4 2011
Answer :


Answered By : null Replied Date : Aug 4 2011
Answer :


Answered By : null Replied Date : Aug 2 2011
Answer :


Answered By : null Replied Date : Jul 31 2011
Answer :


Answered By : null Replied Date : Jul 29 2011
Answer :


Answered By : null Replied Date : Jul 25 2011
Answer :


Answered By : null Replied Date : Jul 20 2011
Answer :


Answered By : null Replied Date : Jul 16 2011
Answer :


Answered By : null Replied Date : Jul 16 2011
Answer :


Answered By : null Replied Date : Jul 15 2011
Answer :


Answered By : null Replied Date : Jun 27 2011
Answer :


Answered By : null Replied Date : Jun 22 2011
Answer :


Answered By : null Replied Date : Jun 17 2011
Answer :


Answered By : null Replied Date : Jun 17 2011
Answer :


Answered By : null Replied Date : Jun 15 2011
Answer :


Answered By : null Replied Date : Jun 13 2011
Answer :


Answered By : null Replied Date : Jun 8 2011
Answer :


Answered By : null Replied Date : Jun 3 2011
Answer :


Answered By : null Replied Date : May 30 2011
Answer :


Answered By : null Replied Date : May 18 2011
Answer :


Answered By : null Replied Date : May 8 2011
Answer :


Answered By : null Replied Date : May 4 2011
Answer :


Answered By : null Replied Date : Apr 24 2011
Answer :


Answered By : null Replied Date : Apr 16 2011
Answer :


Answered By : null Replied Date : Mar 31 2011
Answer :


Answered By : null Replied Date : Mar 31 2011
Answer :


Answered By : null Replied Date : Mar 28 2011
Answer :


Answered By : null Replied Date : Mar 28 2011
Answer :


Answered By : null Replied Date : Mar 25 2011
Answer :


Answered By : null Replied Date : Feb 14 2011
Answer :


Answered By : null Replied Date : Feb 2 2011
Answer :


Answered By : null Replied Date : Jan 15 2011
Answer :


Answered By : null Replied Date : Jan 11 2011
Answer :


Answered By : null Replied Date : Jan 8 2011
Answer :


Answered By : null Replied Date : Jan 4 2011
Answer :


Answered By : null Replied Date : Jan 3 2011
Answer :


Answered By : null Replied Date : Dec 31 2010
Answer :


Answered By : null Replied Date : Dec 30 2010
Answer :


Answered By : null Replied Date : Dec 27 2010
Answer :


Answered By : null Replied Date : Dec 11 2010
Answer :


Answered By : null Replied Date : Nov 25 2010
Answer :


Answered By : null Replied Date : Aug 19 2010
Answer :


Answered By : null Replied Date : May 21 2012
Answer :


Answered By : null Replied Date : May 23 2012
Answer :


Answered By : null Replied Date : Jun 4 2012
Answer :


Answered By : null Replied Date : Jun 27 2012
Answer :


Answered By : null Replied Date : Jul 3 2012
Answer :


Answered By : null Replied Date : Jul 4 2012
Answer :


Answered By : null Replied Date : Jul 30 2012
Answer :


Answered By : null Replied Date : Aug 20 2012
Answer :


Answered By : null Replied Date : Aug 31 2012
Answer :


Answered By : null Replied Date : Sep 2 2012
Answer :


Answered By : null Replied Date : Sep 8 2012
Answer :


Answered By : null Replied Date : Sep 8 2012
Answer :


Answered By : null Replied Date : Sep 8 2012
Answer :


Answered By : null Replied Date : Oct 10 2012
Answer :


Answered By : null Replied Date : Nov 10 2012
Answer :


Answered By : null Replied Date : Nov 10 2012
Answer :


Answered By : null Replied Date : Nov 29 2012
Answer :


Answered By : null Replied Date : Dec 1 2012
Answer :


Answered By : null Replied Date : Dec 13 2012
Answer :


Answered By : null Replied Date : Jan 16 2013
Answer :


Answered By : null Replied Date : Apr 15 2013
Answer :


 

You can also contribute to this answer:

Your Name:
Answer:

 
Ask Question and get answer from Expert.
View Answers List from Expert.

The information you are posting should be related to java and ORACLE technology. Not political.