Spring Data JPA JpaRepository.save() does not return default values

Question

I have a very confusing problem stealing a lot of time:

@Column(name = "created", columnDefinition = "TIMESTAMP DEFAULT CURRENT_TIMESTAMP", insertable = false, updatable = false)
@Temporal(TemporalType.TIMESTAMP)
private Date created;

This code the timestamp is set in my Postgres DB but the repository returns a entity with created = null;

I've tried some annotations like:

@Generated

from : Spring Data JPA JpaRepository.save(entity) not returning database default values

But nothing worked for me.

It's probably because of the updatable=false and passing null. Related: stackoverflow.com/questions/42023070/… — AlikElzin-kilaka
– AlikElzin-kilaka, Commented Nov 19, 2023 at 18:46

trollr · Accepted Answer · 2015-05-19 14:22:12Z

13

The generated values are only guaranteed to be generated at flush time. Saving an entity only makes it "attached" to the persistence context. So, either you have to flush the entity manager explicitely.

Try to use entity.saveAndFlush() and it should work.

edited May 19, 2015 at 14:22

answered May 19, 2015 at 14:04

trollr

1,12512 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Doug Over a year ago

In my case, I have a column modified_at and default value is current datetime. The only thing that worked for me was @UpdateTimestamp. I did not need to call .flush(). Neither @Generated or @GeneratedValue annotations worked, even after using .flush() the field would still come back as null after a .save().

Alex Over a year ago

thx I was suspicious about the Transaction not completly over as I was trying to generate modification and creation date on my entity. But the value is probably inserted after the entity save.

Alex Over a year ago

When I save my object with an already existing ID, it does return me only the @UpdateTimestamp bound field, not the @CreationTimestamp field ... (null value)

Henry · Accepted Answer · 2018-03-20 22:48:44Z

10

Using Spring Data we were facing the same issue with sql server

We solved it using

import org.hibernate.annotations.Generated;
import org.hibernate.annotations.GenerationTime;

@Generated(GenerationTime.INSERT)
@Column(name = "created", insertable = false, updatable = false)
private LocalDateTime created;

You can combine it saveAndFlush (From JpaRepository)

If nothing works you can either implement refresh method by extending SimpleJpaRepository or avoid using the database default and replace it with an EntityListener

@EnableJpaAuditing
public class ConfigClass {...}


@EntityListeners(AuditingEntityListener.class)
public class YourEntity {

    @Column(name = "created", insertable = false, updatable = false)
    @CreatedDate
    private LocalDateTime created;
}

Take in consideration that using EntityListener you have to remove the database default. You could set insertable=true and use ColumnTransformer

    @Column(name = "created", updatable = false)
    @ColumnTransformer(write = "coalesce(sysutcdatetime(), ?)")
    @CreatedDate
    private LocalDateTime created;

answered Mar 20, 2018 at 22:48

Henry

82510 silver badges18 bronze badges

1 Comment

Tomas Lukac Over a year ago

@Generated(GenerationTime.INSERT) did the trick for me. Even works with regular save(). Thanks

Collectives™ on Stack Overflow

Spring Data JPA JpaRepository.save() does not return default values

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related