I have a query like this:
with t1 as
( select c.id cv_id, age(end_date, start_date) experience_year from cv c
join candidate ca on c.candidate_id = ca.id
left join work_experience we on c.id = we.cv_id
left join major_level ml on c.id = ml.cv_id
where (ca.address like concat('%',:candidateAddress,'%') or :candidateAddress is null or :candidateAddress = '')
and ml.major_id in (select m.id from major m where m.major_name like concat('%',:techStack,'%')))
select t1.cv_id cvId, sum(experience_year) sumExperienceYear from t1
group by cv_id
having ((extract(year from sum(experience_year))) < :experienceYearSearch1 and :experienceOption = 1)
or ((extract(year from sum(experience_year))) >= :experienceYearSearch1
and (extract(year from sum(experience_year))) < :experienceYearSearch2 and :experienceOption = 2)
or ((extract(year from sum(experience_year))) >= :experienceYearSearch2 and :experienceOption = 3)
or :experienceOption = 0
I use Java8 and my properties like this:
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
This is my Entity:
@Getter
@Setter
@Entity
@Table(name = "cv")
@AllArgsConstructor
@NoArgsConstructor
public class CV {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private long id;
@Column(name = "summary")
private String summary;
}
Finally, I got the error code:
org.springframework.orm.jpa.JpaSystemException: No Dialect mapping for JDBC type: 1111; nested exception is org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111