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