[Vertica][VJDBC](4984) ERROR: There is no parameter $-32768
HyeontaeJu
Vertica Customer ✭
What is this error?
### Cause: java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4984) ERROR: There is no parameter $-32768
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4984) ERROR: There is no parameter $-32768
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy71.insert(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93)
at com.sun.proxy.$Proxy93.setDeleteTargetImage(Unknown Source)
at com.wmp.ep.batch.task.product.deletepurge.service.ProductDeletePurgeService.deleteDelTargetProducts(ProductDeletePurgeService.java:36)
at com.wmp.ep.batch.task.product.deletepurge.service.ProductDeletePurgeService$$FastClassBySpringCGLIB$$db60642b.invoke(<generated>)
...
0
Answers
How many parameters are you passing to a prepared statement???
Work around:
https://forum.vertica.com/discussion/212991/vjdbc-error-4984-there-is-no-parameter-32768