Limitation of JDBC

Java Application can use either JDBC code/O-R Mapping persistence logic to interact with Database software ,but JDBC is having a following Limitations

• Sql Queries are Database software dependent Query
• JDBC uses sql Queries ,so jdbc code is database software dependent persistence logic
• Changing database software in the Middle of Project development after releasing project is complex 
• ResultSet object is not Serializable ,so we can't send this object over the network
• Version is not possible on Database table column,keeping track of number of Modification done in Database table column values
• Exception Handling is mandatory,because JDBC code throws checked Exception (Ex : SQLException)
• Transaction Management support not sufficient

Note :

To overcome above problems user O-R Mapping persistence logic.

Use files are persistence stores IO Streams based persistence logic while developing small scale applications

Eg: Mobile Games

Use database software as persistence store and jdbc code as persistence logic while developing medium scale applications

Eg:

·         Entry level websites

·         Office Automation Application

·         Super market Application etc………

Use database software as persistence store and O-R Mapping logic as persistence logic (Hibernate)

While developing large scale Applications

Eg:

·         Banking Application

·         Online Shopping etc….

O-R Mapping(Object Relational Mapping):

The process of mapping java class with database table ,java class member variable with database table column and making java class object representing database table records having synchronization between them is called as O-R Mapping.

Synchronization is nothing but the modification done in java object will reflect to the associated database table records and vice versa.

In O-R Mapping persistence logic development we can perform “CURD” operations on database table records through objects, and without using sql queries ,This means the O-R Mapping persistence logic as database software independent persistence logic.

O-R Mapping software’s are responsible to maintain the synchronization between objects and table rows

Since the O-R Mapping persistence logic is database software independent persistence logic and because of other features we can overcome all the problems of  jdbc ,while working with O-R Mapping persistence logic