JPA insert query spring boot

Question

I have class City which is:

@Entity
@Table(name="city",schema="rezervisi")
public class City {

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Getter
@Setter
private int id;
@Getter
@Setter
@NotBlank(message = "Name is mandatory")
private String name;
}

Now I want to override save method in which I send object city. How can I do it if i want to send whole object and not @Params separately. And also since ID is generated how I handle it through parameter here?

Code for repository class is:

public interface CityRepo extends JpaRepository<City,Integer> {

@Query(value="select id, name from city where id = :id ", nativeQuery = true)
Optional<City> findById(Integer id);

@Query(value="select id, name from city where name = :name ", nativeQuery = true)
City findByName(String name);

@Modifying
@Query(value = "insert into city (id,name) VALUES (:id,:name)", nativeQuery = true)
City save(City city ); // instead City save(@Param("id) int id .... 

void delete(City city);
}

Actually I didn't get what you want exactly .. but please have a look at this question you may find something useful stackoverflow.com/questions/60682315/… — hakima maarouf
– hakima maarouf, Commented Apr 26, 2022 at 22:08

AidH · Accepted Answer · 2022-04-26 22:16:59Z

0

You can try using repository.save(city) from your service if it is a CrudRepository.
If that is not what you need for some reason, you can try this out:

    @Modifying
    @Transactional
    @Query(value = "insert into city (id, name) VALUES (?, ?)", nativeQuery = true)
    City save(Long id, String name);
    
    default City save(City city) {
        return save(city.getId(), city.getName());
    }

answered Apr 26, 2022 at 22:16

AidH

6504 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

JPA insert query spring boot

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related