Sybase "Message Empty" / 7738 and "token datastream length was not correct" / 3805 errors during HQL query in Hibernate

Issue

• Performing an HQL query using an IN clause with a list of 2500+ values using Sybase

• The database driver 'jConnect (TM) for JDBC(TM)/7.07' raises an exception when the query is executed

  ... WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 7738, SQLState: null
  ... ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] Message empty.
  
  ... WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] SQL Error: 3805, SQLState: ZZZZZ
  ... ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] The token datastream length was not correct. This is an internal protocol error.