Skip to main content

VJDBC error 4984 There is no parameter $-32768

  • January 10, 2014
  • 1 reply
  • 7 views

Jack_Kidwell
Forum|alt.badge.img+1
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.

1 reply

Jack_Kidwell
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • January 11, 2014
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.