VJDBC error 4984 There is no parameter $-32768

Jack_Kidwell

java.sql.SQLException: [Vertica][VJDBC](4984) ERROR: There is no parameter $-32768
        at com.vertica.util.ServerErrorData.buildException(Unknown Source)
        at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)
        at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
        at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
        at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
        at com.vertica.jdbc.SPreparedStatement.<init>(Unknown Source)
        at com.vertica.jdbc.VerticaPreparedStatementImpl.<init>(Unknown Source)
        at com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)
        at com.vertica.jdbc.SConnection.prepareStatement(Unknown Source)
        at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:295)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:318)


Is there a limit on the number of parameters? The query has many thousands of parameters.

Jack_Kidwell

I worked around this error by breaking up queries, ensuring that the number of parameters does not exceed 32,767. Apparently there is an undocumented limit on the number parameters.