Update entity if already exists or create using spring jpa

Question

I am new to spring data jpa. I have a scenario where I have to create an entity if not exists or update based on non primary key name.Below is the code i wrote to create new entity,it is working fine,but if an already exists record ,its creating duplicate.How to write a method to update if exists ,i usually get list of records from client.

@Override
@Transactional
public String createNewEntity(List<Transaction> transaction) {

   List<Transaction> transaction= transactionRespository.saveAll(transaction);
}

you have to write a query to retrieve record with the particular field and do a check to see if any results matches — mkjh, Dec 27 '18 at 02:48

score 1 · Answer 1 · answered Dec 27 '18 at 02:51

1

Add in your Transaction Entity on variable called name this for naming as unique:

  @Entity
  public class Transaction {
      ...
      @Column(name="name", unique=true)
      private String name;
      ... 
  }

Then you won't be able to add duplicate values for name column.

answered Dec 27 '18 at 02:51

Jonathan JOhx

5,784
2
17
33

sorry my question is how to update based on name column which not a primary key on the table? – Rocky4Ever Dec 27 '18 at 03:04

score 1 · Answer 2 · answered Dec 27 '18 at 04:14

First, this is from google composite key means

A composite key is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.

A composite key with an unique key is a waste.

if you want to update an entity by jpa, you need to have an key to classify if the entity exist already.

    @Transactional
public <S extends T> S save(S entity) {
    if(this.entityInformation.isNew(entity)) {
        this.em.persist(entity);
        return entity;
    } else {
        return this.em.merge(entity);
    }
}

There are two ways to handle your problem.

If you can not get id from client on updating, it means that id has lost its original function. Then remove your the annotation @Id on your id field,set name with @Id. And do not set auto generate for it.

I think what you want is an @Column(unique = true,nullable = false) on your name field. And that is the order to update something.

Transaction t = transactionRepository.findByName(name);
t.set.... //your update
transactionRepository.save(t);

Update entity if already exists or create using spring jpa

2 Answers2