Archives par étiquette : JPA

How to prevent updates of a SQL column using JPA ?

Laisser un commentaire

When working with JPA / Hibernate, you may want to prevent updates of a given column. This is typically the case with your primary key. This is possible using the « updatable » attribute of the @Column annotation. Ex : 

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", updatable = false, nullable = false)
    private Long id;

Named parameter not found in JPA/Hibernate native SQL queries

Laisser un commentaire

When using named parameters in native SQL queries with Hibernate implementation of the Java Persistence API (JPA), you may run into the following error
[code lang=java]
org.springframework.dao.InvalidDataAccessApiUsageException: Parameter with that name [orderId] did not exist;
nested exception is java.lang.IllegalArgumentException: Parameter with that name [orderId] did not exist
[/code]

This happens even if the named parameter was properly set, as in the following example :

For example :
[code lang=java]
void update(EntityManager em) {
Query q = em.createNativeQuery(« SELECT * FROM orders where id = :orderId; »);
q.setParameter(« orderId », « 1234 »);
q.executeUpdate();
}
[/code]

The issue comes from Continuer la lecture →