Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

VJDBC error 4984 There is no parameter $-32768

java.sql.SQLException: [Vertica][VJDBC](4984) ERROR: There is no parameter $-32768
        at com.vertica.util.ServerErrorData.buildException(Unknown Source)
        at 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(
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(

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


  • 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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.