6.3.7 Prepared Statements

• allowNanAndInf

  Should the driver allow NaN or +/- INF values in PreparedStatement.setDouble()?

  Default Value	false
  Since Version	3.1.5

• autoClosePStmtStreams

  Should the driver automatically call .close() on streams/readers passed as arguments via set*() methods?

  Default Value	false
  Since Version	3.1.12

• compensateOnDuplicateKeyUpdateCounts

  Should the driver compensate for the update counts of "ON DUPLICATE KEY" INSERT statements (2 = 1, 0 = 1) when using prepared statements?

  Default Value	false
  Since Version	5.1.7

• emulateUnsupportedPstmts

  Should the driver detect prepared statements that are not supported by the server, and replace them with client-side emulated versions?

  Default Value	true
  Since Version	3.1.7

• generateSimpleParameterMetadata

  Should the driver generate simplified parameter metadata for PreparedStatements when no metadata is available either because the server couldn't support preparing the statement, or server-side prepared statements are disabled?

  Default Value	false
  Since Version	5.0.5

• processEscapeCodesForPrepStmts

  Should the driver process escape codes in queries that are prepared? Default escape processing behavior in non-prepared statements must be defined with the property 'enableEscapeProcessing'.

  Default Value	true
  Since Version	3.1.12

• useServerPrepStmts

  Use server-side prepared statements if the server supports them?

  Default Value	false
  Since Version	3.1.0

• useStreamLengthsInPrepStmts

  Honor stream length parameter in PreparedStatement/ResultSet.setXXXStream() method calls (true/false, defaults to 'true')?

  Default Value	true
  Since Version	3.0.2