Documentation Home
MySQL Connector/J 8.0 Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.8Mb
PDF (A4) - 0.8Mb


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