Important JDBC Concepts

Transactions: Whenever a connection is created by using the JDBC, then by default it is in auto- commit mode. This means that SQL statement will be automatically committed immediately after it is executed and it is treated as a transaction.

Important JDBC Concepts

Important JDBC Concepts

     

Transactions: Whenever a connection is created by using the JDBC, then by default it is in auto- commit mode. This means that SQL statement will be automatically committed immediately after it is executed and it is treated as a transaction. But imagine a situation where you want to execute a batch of statements, either they should commit at on go or they should get failed together. For this we need to disable the auto- commit mode by using the method:

con.setAutoCommit(false).

After setting the auto- commit as false, no SQL statement will be committed until we call the con.commit() method. If there arises any problem while committing then the set of statements will be rollback, without committing.

Logging: on the server--->logging--->JDBC.

By this we can enable JDBC logging and specify a log file name for the JDBC log.

Attributes of Logging:

1) Enable JDBC Logging: It determines whether the server has a JDBC log file.

2) JDBC Log File Name: It is the name of the log file.

Isolation: The isolation is needed when there are concurrent transactions. Concurrent transactions are transactions are transactions that occurs at the same time. In isolation one transaction does not interfere with another. For setting the isolation level for a JDBC transaction, use the

Connection.setTransaction(int level) method

By using the snapshot isolation level we can only see the snapshot of the data locked by other transactions when running from inside the transaction with snapshot isolation level.

Some of the transaction level are given below:

1). TRANSACTION_NONE

2). TRANSACTION_READ_UNCOMMITED

3. TRANSACTION_READ_COMMITTED

4. TRANSACTION_REPEATABLE_READ

5. TRANSACTION_SERIALIZABLE

By setting the isolation levels you are having an impact on the performance of the transaction. You can get the existing isolation level with:

getTransactionIsolation() method.

Concurrency: Database concurrency controls ensure that the transactions occur in an ordered fashion.

Concurrency control deals with the issue involved with allowing multiple people simultaneous access to shared entities.

 

Tutorials

  1. First Step towards JDBC
  2. Accessing the Database from Servlet
  3. Accessing Databases Using Java and JDBC
  4. First Step towards JDBC!
  5. First Step towards JDBC!
  6. Accessing Database from servlets through JDBC!
  7. JDBC, JDBC Tutorial, JDBC Tutorials
  8. What is JDBC?
  9. Product Components of JDBC
  10. Understanding the JDBC Architecture
  11. JDBC Driver and Its Types
  12. JDBC Versions
  13. Features of JDBC 3.0 API
  14. Features of JDBC 4.0
  15. Difference between JDBC 3.0 & JDBC 4.0
  16. Relational Database Concepts
  17. Understanding Common SQL statements
  18. Important JDBC Concepts
  19. Introduction to java.sql package
  20. Driver Manager Class
  21. Understanding Data Source
  22. Understanding Connection Object
  23. Mapping MySQL Data Types in Java
  24. Connecting to a MySQL Database in Java
  25. Creating a Database in MySQL
  26. Creating a Database Table
  27. Creating a MySQL Database Table to store Java Types
  28. Description of Database Table
  29. Deleting a Table from Database
  30. Retrieving Tables from a Database
  31. Inserting values in MySQL database table
  32. Retrieving All Rows from a Database Table
  33. Adding a New Column Name in Database Table
  34. Change Column Name of a Table
  35. Make Unique Column in Database Table
  36. Remove Unique Column in Database Table
  37. Arrange a Column of Database Table
  38. Arrange a Column of Database Table
  39. Sum of Column in a Database Table
  40. Deleting All Rows from a Database Table