[Vertica][VJDBC](4984) ERROR: There is no parameter $-32768

HyeontaeJu

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>)

...

Jim_Knicely

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