How to let JPArepository.save() do insert only and prevent update?

Question

I am using JPArepository.save() to insert the record to the database but it will automatically update the existing record in the database. What I want to do is let it throw exception if there are records with same primary key in the database.

I searched the solution in Google and find a solution that said use saveAndFlush instead of save can solve it. However, it still update the existing record after I used saveAndFlush.

Does this answer your question? [Spring JPA / Hibernate transaction force insert instead of update](https://stackoverflow.com/questions/37253175/spring-jpa-hibernate-transaction-force-insert-instead-of-update) — M. Rizzo, Feb 11 '22 at 13:57

Michael Tsai · Accepted Answer · 2022-08-29T01:04:59.877

8

Finally, I've found the solution. I just implement Persistable interface and ovrride the isNew() to be always true.

Example:

@Entity
public class ChessGame implements Persistable<Long> {
 
    @Id
    private Long id;

 
    @Override
    public boolean isNew() {
        return true;
    }
}

edited Aug 29 '22 at 01:04

answered Aug 12 '22 at 02:46

Michael Tsai

751
2
11
21

It would be great if Accepted answer has an code example without just saying the approach – Menuka Ishan Aug 28 '22 at 08:19
@MenukaIshan updated example – Michael Tsai Aug 29 '22 at 01:05
this is not working... – Michael Nov 06 '22 at 17:41
@Michael why not working? can u show any error log? – Michael Tsai Nov 11 '22 at 03:30
@MichaelTsai i still have an update query – Michael Nov 13 '22 at 10:25
@Michael did u return true in the isNew method? or can u reproduce ur code sample? – Michael Tsai Nov 15 '22 at 06:55
Yeah i just return true – Michael Nov 15 '22 at 12:03

score 0 · Answer 2 · answered Jul 07 '22 at 15:34

There is no way to do just an INSERT without UPDATE in JPA out-of-the-box.

You need to define your own INSERT method on your JpaRepository and then call it from your code.

public interface MyRepository extends JpaRepository<MyRecord, Integer> {
    
    ....

    @Modifying(clearAutomatically = true)
    @Transactional
    @Query(value = "INSERT INTO my_table (field1, field2) "
        + "VALUES (:#{#c.field1}, :#{#c.field2})", nativeQuery = true)
    public void insert(@Param("c") MyRecord c);

}

And then in the code doing the insert:

final var newRecord = MyRecord.builder()
    .field1(...)
    ....
    .build();

try {
    myRepository.insert(newRecord);
} catch (DataIntegrityViolationException e) {
    ....
}

How to let JPArepository.save() do insert only and prevent update?

2 Answers2