The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

Comments

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