• Home
  • Courses

    About Courses

    • Core Java
    • JDBC
    JDBC

    JDBC

    Free
    Read More
  • Features
    • Portfolio
    • About Us
    • FAQs
  • Gallery
  • Blog
  • Contact
      • Cart

        0
    Hacked by Katib | Turkish Hacker | SpyHackerz.OrgHacked by Katib | Turkish Hacker | SpyHackerz.Org
    • Home
    • Courses

      About Courses

      • Core Java
      • JDBC
      JDBC

      JDBC

      Free
      Read More
    • Features
      • Portfolio
      • About Us
      • FAQs
    • Gallery
    • Blog
    • Contact
        • Cart

          0

      JAVA TECHNOLOGIES

      • Home
      • All courses
      • JAVA TECHNOLOGIES
      • JDBC
      LP CoursesJAVA TECHNOLOGIESJDBC
        • Lecture1.1
          What is JDBC? 30 min
        • Lecture1.2
          DBMS and RDBMS 30 min
        • Lecture1.3
          Basic SQL Syntax 30 min
        • Lecture1.4
          Install MySql 30 min
        • Lecture1.5
          JDBC driver 30 min
        • Lecture1.6
          JDBC Connection 30 min
        • Lecture1.7
          JDBC Statement 30 min
        • Lecture1.8
          JDBC ResultSet 30 min
        • Lecture1.9
          JDBC Transactions 30 min
        • Lecture1.10
          Insert Records-PreparedStatement Example 30 min
        • Lecture1.11
          Insert Records-Statement Example 30 min
        • Lecture1.12
          Update Records-Example 30 min
        • Lecture1.13
          Delete Records-Example 30 min
        • Lecture1.14
          Stored Procedures-Example 30 min

        JDBC Transactions

        JDBC allows SQL statements to be grouped together into a single transaction. Thus, we can ensure the ACID (Atomicity, Consistency, Isolation, Durability) properties using JDBC transactional features.

        Transaction control is performed by the Connection object. When a connection is created, by default it is in the auto-commit mode. This means that each individual SQL statement is treated as a transaction by itself, and will be committed as soon as it’s execution finished. We can turn off auto-commit mode for an active connection with:

        con.setAutoCommit(false) ;

        and turn it on again with:

        con.setAutoCommit(true) ;

        Once auto-commit is off, no SQL statements will be committed (that is, the database will not be permanently updated) until you have explicitly told it to commit by invoking the commit() method:

        con.commit() ;

        Prev JDBC ResultSet
        Next Insert Records-PreparedStatement Example

        Leave A Reply Cancel reply

        Your email address will not be published. Required fields are marked *

        All Courses

        • JAVA TECHNOLOGIES

        Latest Courses

        Core Java

        Core Java

        Free
        JDBC

        JDBC

        Free
        logo-eduma-the-best-lms-wordpress-theme

        contactus@tech2our.com

        Company

        • About Us
        • Blog
        • Contact

        Links

        • Courses
        • Events
        • FAQs

        Support

        • Documentation
        • Forums
        • Language Packs

        Copyright © 2012-2017 Tech2Our.com. All Rights Reserved.

        • Privacy
        • Terms
        • Sitemap