How have you used Hibernate in your projects and what experience do you have with this tool?

In my projects, I used Hibernate as an ORM framework to simplify database interactions. My main experience involves mapping Java entities to database tables, writing HQL queries, and using the Criteria API for dynamic query building.

I applied Hibernate annotations to define relationships between entities (OneToMany, ManyToOne, ManyToMany), as well as to configure lazy and eager data loading. I used transactions through the Hibernate Transaction API and integrated Hibernate with Spring for session and transaction management.

An example of simple entity mapping:

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

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

    @OneToMany(mappedBy = "user", fetch = FetchType.LAZY)
    private Set<Order> orders;

    // getters and setters
}

Thus, Hibernate helped me abstract away from SQL and work with data at the object level.