What are the advantages and disadvantages of using Hibernate for object persistence in a database?

Hibernate is an ORM framework for Java that simplifies working with databases by allowing objects to be saved directly.

Advantages:

• Automatic mapping of Java objects to database tables.
• Simplification of CRUD operations without writing SQL.
• Caching to improve performance.
• Support for transactions and lazy loading.
• Portability across different DBMS.

Disadvantages:

• Complexity of setup and learning.
• Potential performance issues if used improperly (e.g., N+1 queries).
• Abstraction can hide complex SQL queries, making optimization difficult.
• Sometimes excessive for simple applications.

Example of saving an object:

Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();
User user = new User("Ivan", "ivan@example.com");
session.save(user);
tx.commit();
session.close();