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


6.3.8 Result Sets

  • clobberStreamingResults

    This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.

    Default Value false
    Since Version 3.0.9
  • emptyStringsConvertToZero

    Should the driver allow conversions from empty string fields to numeric values of "0"?

    Default Value true
    Since Version 3.1.8
  • holdResultsOpenOverStatementClose

    Should the driver close result sets on 'Statement.close()' as required by the JDBC specification?

    Default Value false
    Since Version 3.1.7
  • jdbcCompliantTruncation

    Should the driver throw 'java.sql.DataTruncation' exceptions when data is truncated as is required by the JDBC specification? This property has no effect if the server sql-mode includes 'STRICT_TRANS_TABLES'.

    Default Value true
    Since Version 3.1.2
  • maxRows

    The maximum number of rows to return. The default "0" means return all rows.

    Default Value -1
    Since Version all versions
  • netTimeoutForStreamingResults

    What value should the driver automatically set the server setting 'net_write_timeout' to when the streaming result sets feature is in use? Value has unit of seconds, the value "0" means the driver will not try and adjust this value.

    Default Value 600
    Since Version 5.1.0
  • padCharsWithSpace

    If a result set column has the CHAR type and the value does not fill the amount of characters specified in the DDL for the column, should the driver pad the remaining characters with space (for ANSI compliance)?

    Default Value false
    Since Version 5.0.6
  • populateInsertRowWithDefaultValues

    When using result sets that are 'CONCUR_UPDATABLE', should the driver pre-populate the insert row with default values from the DDL for the table used in the query so those values are immediately available for 'ResultSet' accessors? This functionality requires a call to the database for metadata each time a result set of this type is created. If disabled, the default values will be populated by the an internal call to 'refreshRow()' which pulls back default values and/or values changed by triggers.

    Default Value false
    Since Version 5.0.5
  • scrollTolerantForwardOnly

    Should the driver contradict the JDBC API and tolerate and support backward and absolute cursor movement on result sets of type 'ResultSet.TYPE_FORWARD_ONLY'?

    Regardless of this setting, cursor-based and row streaming result sets cannot be navigated in the prohibited directions.

    Default Value false
    Since Version 8.0.24
  • strictUpdates

    Should the driver do strict checking, i.e. all primary keys selected, of updatable result sets?

    Default Value true
    Since Version 3.0.4
  • tinyInt1isBit

    Since the MySQL server silently converts BIT to TINYINT(1) when creating tables, should the driver treat the datatype TINYINT(1) as the BIT type?

    Default Value true
    Since Version 3.0.16
  • transformedBitIsBoolean

    If the driver converts TINYINT(1) to a different type, should it use BOOLEAN instead of BIT?

    Default Value false
    Since Version 3.1.9