Gilberto C Andrade created DELTASPIKE-1470: ----------------------------------------------
Summary: PSQLException: ERROR: syntax error at or near ")" when using IN clause and empty list Key: DELTASPIKE-1470 URL: https://issues.apache.org/jira/browse/DELTASPIKE-1470 Project: DeltaSpike Issue Type: Improvement Security Level: public (Regular issues) Components: Data-Module, JPA-Module Affects Versions: 1.9.4 Reporter: Gilberto C Andrade I'm getting this exception every time one query, that uses IN clause, receives an empty parameter: {code:java} // Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.7.v20200504-69f2c2b80d): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Posição: 396 Error Code: 0 Call: SELECT titulo_cobranca_id, ACEITE, codigo_movimento_remessa, codigo_movimento_retorno, documento, dt_documento, dt_efetivacao_credito, dt_emissao, dt_ocorrencia, dt_vencimento, especie, valor_juro, motivo_ocorrencia, valor_multa, nosso_numero, situacao, valor, valor_juros_multa_encargos, valor_pago, valor_tarifa, conta_bancaria_id, pagador_id FROM gace.titulo_cobranca WHERE (nosso_numero IN ()) Query: ReadAllQuery(referenceClass=TituloCobranca sql="SELECT titulo_cobranca_id, ACEITE, codigo_movimento_remessa, codigo_movimento_retorno, documento, dt_documento, dt_efetivacao_credito, dt_emissao, dt_ocorrencia, dt_vencimento, especie, valor_juro, motivo_ocorrencia, valor_multa, nosso_numero, situacao, valor, valor_juros_multa_encargos, valor_pago, valor_tarifa, conta_bancaria_id, pagador_id FROM gace.titulo_cobranca WHERE (nosso_numero IN ?)") at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391) at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264) at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482) at org.apache.openejb.persistence.JtaQuery.getResultList(JtaQuery.java:87) at org.apache.deltaspike.data.impl.builder.result.QueryProcessorFactory$ListResultQueryProcessor.executeQuery(QueryProcessorFactory.java:96) at org.apache.deltaspike.data.impl.handler.CdiQueryInvocationContext.executeQuery(CdiQueryInvocationContext.java:253) at org.apache.deltaspike.data.impl.builder.AnnotatedQueryBuilder.execute(AnnotatedQueryBuilder.java:51) at org.apache.deltaspike.data.impl.builder.QueryBuilder.executeQuery(QueryBuilder.java:57) at org.apache.deltaspike.data.impl.builder.AnnotatedQueryBuilder$$OwbNormalScopeProxy0.executeQuery(org/apache/deltaspike/data/impl/builder/AnnotatedQueryBuilder.java) at org.apache.deltaspike.data.impl.tx.TransactionalQueryRunner.executeNonTransactional(TransactionalQueryRunner.java:62) at org.apache.deltaspike.data.impl.tx.TransactionalQueryRunner.executeQuery(TransactionalQueryRunner.java:57) at org.apache.deltaspike.data.impl.tx.TransactionalQueryRunner$$OwbNormalScopeProxy0.executeQuery(org/apache/deltaspike/data/impl/tx/TransactionalQueryRunner.java) at org.apache.deltaspike.data.impl.handler.QueryHandler.process(QueryHandler.java:151) at org.apache.deltaspike.data.impl.handler.QueryHandler.invoke(QueryHandler.java:130) at org.apache.deltaspike.data.impl.handler.QueryHandler$$OwbNormalScopeProxy0.invoke(org/apache/deltaspike/data/impl/handler/QueryHandler.java) at org.apache.deltaspike.proxy.spi.invocation.DeltaSpikeProxyInvocationHandler.proceed(DeltaSpikeProxyInvocationHandler.java:97) at org.apache.deltaspike.proxy.spi.invocation.DeltaSpikeProxyInvocationHandler.invoke(DeltaSpikeProxyInvocationHandler.java:78) at org.apache.deltaspike.proxy.spi.invocation.DeltaSpikeProxyInvocationHandler$$OwbNormalScopeProxy0.invoke(org/apache/deltaspike/proxy/spi/invocation/DeltaSpikeProxyInvocationHandler.java) at br.gov.to.bem.gace.repository.TituloCobrancaRepository$$DSPartialBeanProxy.findAllByNossoNumero(Unknown Source) at br.gov.to.bem.gace.service.RetornoService.gerar(RetornoService.java:191) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:205) at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:186) at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:191) at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:102) at jdk.internal.reflect.GeneratedMethodAccessor105.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:205) at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:186) at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:85) at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:252) at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:212) at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:265) at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:260) at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:89) at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:349) ... 67 common frames omitted Caused by: org.eclipse.persistence.exceptions.DatabaseException: Internal Exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Posição: 396 Error Code: 0 {code} {code:java} @Query("SELECT e FROM TituloCobranca e WHERE e.nossoNumero IN :identificadores") public List<TituloCobranca> findAllByNossoNumero(@QueryParam("identificadores") List<String> identificadores);{code} Maybe checking if the parameter is null before the execuction could solve this problem. -- This message was sent by Atlassian Jira (v8.20.10#820010)