Estou com este erro
query
@Query(value =
"SELECT SUM(e.litros) " +
"FROM NotaFiscal e " +
"WHERE (e.usuario.id = :idUsuario) " +
"AND (e.metadadoAuditoria.statusDoRegistro = :statusDoRegistro) " +
"AND (e.vencimento >= :vencimento or :vencimento is null) "
)
BigDecimal somaNotasPorStatus(
@Param("idUsuario") String idUsuario,
@Param("statusDoRegistro") StatusDoRegistroEnum statusDoRegistro,
@Param("vencimento") LocalDate vencimento);
Erro
Hibernate: select sum(notafiscal0_.nr_litros) as col_0_0_ from tab_nota_fiscal notafiscal0_ where notafiscal0_.fk_usuario=? and notafiscal0_.st_registro=? and (notafiscal0_.dt_vencimento>=? or ? is null)
2021-12-23 20:17:17 - o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 42P18
2021-12-23 20:17:17 - o.h.e.jdbc.spi.SqlExceptionHelper - ERROR: could not determine data type of parameter $4
2021-12-23 20:17:17 - b.c.g.p.resource.MensagensRetorno - could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:281)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:528)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:154)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
Para chamar a auery
final LocalDate minusDays = now().minusDays(30);
final BigDecimal pontosExpirar = repository.somaNotasPorStatus(principal.getName(), ATIVO, minusDays);
Campo no model está assim
@Column(name = "DT_VENCIMENTO")
private LocalDate vencimento;
Todos são importados desta import java.time.LocalDate;
O que pode ser este erro ?
Banco de dados postgres
