CODEWITHSUNDEEP
javaspringhibernatespring-data-jpa
Daniel Goers
Daniel Goers

Reputation: 1

Spring Data JPA - repository returns different type

I have a CrudRepository like this:

public interface TestTableRepository extends CrudRepository<TestTable, Long> {

    @Query(
            value = "select count(case when field1 = true then 1 end) as field1Count, count(case when field2 = true then 1 end) as field2Count from test_table",
            nativeQuery = true
    )
    List<Integer> selectRowCount();
    
}

This is a simplified version of a similar query in my application. What is the best return type to use?

As it's currently written, the actual returned type is List<Object[]> instead of List<Integer>. How is that possible? I'm guessing it's something to do with the query implementation being constructed by Spring/Hibernate at runtime.

Upvotes: 0

Views: 1190

Answers (1)

Piyush Chavan
Piyush Chavan

Reputation: 11

**The best return type in this case is `Map<String, Object>`.<br/>
To retrieve data from Map you can used alias name. In this case, key field1Count and field2Count will give you count value.**    
        
For Example
@RestController class :
            @GetMapping("/getCount")
                public String getCounnt() {
                    Map<String, Object> mp =  userRepo.getCount();
                    int field1CountValue = Integer.parseInt(mp.get("field1Count").toString());
                    int field2CountValue = Integer.parseInt(mp.get("field2Count").toString());  
                    System.out.println("field1CountValue :"+field1CountValue+" field2CountValue :"+field2CountValue);
                    return "field1CountValue :"+field1CountValue+" field2CountValue :"+field2CountValue;
                }
    ___________________________________
@Repository Interface
            import java.util.Map;
            import org.springframework.data.jpa.repository.Query;
            import org.springframework.data.repository.CrudRepository;
            
            public interface UserRepo extends CrudRepository<User, Long>{
            
                @Query(
                        value = "select count(case when id > 0 then 1 end) as field1Count, "
                                + "count(case when id > 15 then 1 end) as field2Count from user",
                        nativeQuery = true
                )
                Map<String, Object> getCount(); 
            }
Console :
[Hibernate: select count(case when id > 0 then 1 end) as field1Count, count(case when id > 15 then 1 end) as field2Count from user
field1CountValue :9 field2CountValue :0]

Upvotes: 1

Related Questions