Transaction Management In JDBC
Transaction represents a single unit of work. Transaction is a set of statements executed on a resource or resources applying ACID properties. Transactions are used to provide the data integrity over multiple users. The transaction includes the interaction between the databases and users.
ACID Properties :
- • Atomicity, it's simple either all operations in database occur, or nothing occurs.
- • Consistency, ensures that the database is in a valid state before and after the transaction.
- • Isolation, any transaction is independent of another, and your result doesn't depends of any other.
- • Durability, the result of commit a transaction must persist in a non-volatile memory even if occurs a crash or power loss.
Let's see an example of a transaction management:
import java.sql.*; class TransactionDemo { public static void main(String args[])throws Exception { Class.forName("oracle.jdbc.driver.OracleDrive"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle"); con.setAutoCommit(false); Statement stmt=con.createStatement(); stmt.executeUpdate("insert into student values(101,'tapuuu','CSE')"); stmt.executeUpdate("insert into student values(1o2,'prerik','IT')"); con.commit(); con.close(); } }
If we see the table student, (select * from student) we will see that 2 records has been added.
For this we need to create the student tables first.
create table student
( regdno varchar(25), name char(45), branch char(55) );
About the Author
Silan Software is one of the India's leading provider of offline & online training for Java, Python, AI (Machine Learning, Deep Learning), Data Science, Software Development & many more emerging Technologies.
We provide Academic Training || Industrial Training || Corporate Training || Internship || Java || Python || AI using Python || Data Science etc
PreviousNext
Join our newsletter for the latest updates.
About us
Our Services
Contact Us
Our Courses
Learn Python | Learn AI | Learn Machine Learning | Learn Deep Learning | Learn Core Java | Learn Java JSP | Learn Java Servlet | Learn Java Spring | Learn Spring Boot | Learn Power BI | Learn DAA | Learn HTML | Learn SQL | Learn C Programming | Learn Bootstrap | Learn Git | Learn JavaScript | Learn Data Structure Using C | Learn RDBMS | Learn Data Science | Learn PHP
Our Tutorials
Python Tutorial | AI Tutorial | Machine Learning Tutorial | Deep Learning Tutorial | Core Java Tutorial | Java JSP Tutorial | Java Servlet Tutorial | Java Spring Tutorial | Spring Boot Tutorial | Power BI Tutorial | DAA Tutorial | HTML Tutorial | SQL Tutorial | C Programming Tutorial | Bootstrap Tutorial | Git Tutorial | JavaScript Tutorial | Data Structure Using C Tutorial | RDBMS Tutorial | Data Science Tutorial | PHP Tutorial
Copyright © 2023 Pythontpoints Powered by Silan Software Pvt. Ltd. All rights reserved.