What is your experience with using Hibernate?

Hibernate is a popular ORM framework for Java that simplifies working with databases by allowing you to work with objects instead of SQL queries. In my experience, I have used Hibernate for mapping entities to tables, configuring relationships (OneToMany, ManyToOne), and writing queries using HQL and Criteria API.

Example of a simple entity class with Hibernate annotations:

@Entity
@Table(name = "users")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(nullable = false, unique = true)
    private String username;

    // getters and setters
}

I also configured Hibernate via XML and Java configuration, and used transactions and caching to optimize database operations.