Monday, August 4, 2014

Drawbacks of JDBC?

Drawbacks of JDBC:


  • JDBC uses the software dependent sql queries,so the JDBC Persistence logic is database software dependent.
  • All Exceptions of JDBC are checked exceptions, so  the Exception Handling is Mandatory.
  • There is no proper support of Transaction Management.
  • There is no built-in support of Caching/Buffering to reduce network round trips between Java App & Database.
  • We can not keep objects in relationship while underlying Database tables are in relationship.