Hibernate Error after upgrading from 2.1.6 to 2.1.7

[syamsu-smansa]

After upgrading spring boot to 2.1.7 from 2.1.6, running application are failing due to the issue:

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: count near line 1, column 8 [select count(new map(model as levelTingkat)) from com.jasamedika.medifirst2000.entity.LevelTingkat model left join model.id id  where id.kdProfile=:kdProfile  and model.statusEnabled=true  ]

public interface  interface LevelTingkatDao extends CrudRepository.

Query : "select new map(model as levelTingkat) " 
            + " from LevelTingkat model left join model.id id "
            + " where id.kdProfile=:kdProfile "
            + " and model.statusEnabled=true  "

method: Page<Map<String, Object>> findAllList(
            @Param("kdProfile") Integer kdProfile,
            Pageable pageable);

In new CrudRepository, it seem, has adding "count" to Query HQL, because present of Pageable parameter.

[philwebb]

This looks related to either a Spring Data JPA or Hibernate upgrade. I've opened https://jira.spring.io/browse/DATAJPA-1598 to see if the Spring Data team can help. Can you please attach your full LevelTingkatDao file to that issue. It's not currently clear if you're relying on the query generated by the method name findAllList or if you're using @Query.

[syamsu-smansa]

This looks related to either a Spring Data JPA or Hibernate upgrade. I've opened https://jira.spring.io/browse/DATAJPA-1598 to see if the Spring Data team can help. Can you please attach your full LevelTingkatDao file to that issue. It's not currently clear if you're relying on the query generated by the method name findAllList or if you're using @Query.

Here it is:

import com.jasamedika.medifirst2000.entity.LevelTingkat;
import com.jasamedika.medifirst2000.entity.vo.LevelTingkatId;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository("LevelTingkatDao")
public interface LevelTingkatDao extends CrudRepository<LevelTingkat, LevelTingkatId> {

    @Query(QfindAllList)
    Page<Map<String, Object>> findAllList(
            @Param("kdProfile") Integer kdProfile,
            Pageable pageable);

    @Query(QfindAllList + " and model.namaLevelTingkat like :namaLevelTingkat ")
    Page<Map<String, Object>> findAllList(
            @Param("kdProfile") Integer kdProfile,
            @Param("namaLevelTingkat") String namaLevelTingkat,
            Pageable pageable);
    
   String QfindAllList = "select new map(model as levelTingkat) "
            + " from LevelTingkat model left join model.id id "
            + " where id.kdProfile=:kdProfile "
            + " and model.statusEnabled=true  ";

}

[snicoll]

@syamsu-smansa this issue is closed and has been superseded by the Spring Data issue so please don't add further comments here. Phil asked you to

Can you please attach your full LevelTingkatDao file to that issue

Can you please do that? That issue.

[wilkinsona]

I guess @syamsu-smansa may not have a JIRA account. I've copied the snippet over to the Data JPA issue.