Spring data JDBC, can I get a return value as an entity in a custom insert query?

Question

@Repository
public interface RoomRepository extends CrudRepository<RoomEntity, Long> {
    @Override
    List<RoomEntity> findAll();

    @Modifying
    @Query("INSERT INTO room VALUES(:id, :name)")
    RoomEntity insert(@Param("id") String uuid, @Param("name") String name);
}

I made an insert custom query to use the default key for the UUID. Is there any way for custom queries to receive result values as entities? The above code doesn't work. The framework is returning an int.

It is returning the number of rows affected - please have a look here https://stackoverflow.com/questions/23122846/query-returning-object-instead-of-entity — somshivam, Apr 30 '20 at 08:25

score 0 · Answer 1 · answered May 01 '20 at 07:25

This is not directly possible.

Some database allow execution of multiple statements: Multiple queries executed in java in single statement

But the infrastructure of Spring Data JDBC is not prepared to handle such a case.

What you may create a custom method to do this by first inserting the row and then selecting it in two steps using a JdbcTemplate or similar mechanism.

Spring data JDBC, can I get a return value as an entity in a custom insert query?

1 Answers1