How did you interact with the database in your previous position?

In the previous position, interaction with the database was carried out through ORM (for example, Hibernate or JPA), which allowed working with data at the object level rather than directly with SQL queries. This simplified support and development of the code.

For complex queries, native SQL or JPQL was used when optimization or specific logic was required.

An example of using JPA to retrieve a list of users:

@Entity
public class User {
    @Id
    private Long id;
    private String name;
    // getters and setters
}

// In the service
List<User> users = entityManager.createQuery("SELECT u FROM User u", User.class).getResultList();

Transactions were also used to ensure data integrity, and connection pools were employed to optimize database operations.