6.3.6 Statements

• cacheDefaultTimeZone

  Caches client's default time zone. This results in better performance when dealing with time zone conversions in Date and Time data types, however it won't be aware of time zone changes if they happen at runtime.

  Default Value	true
  Since Version	8.0.20

• continueBatchOnError

  Should the driver continue processing batch commands if one statement fails. The JDBC spec allows either way.

  Default Value	true
  Since Version	3.0.3

• dontTrackOpenResources

  The JDBC specification requires the driver to automatically track and close resources, however if your application doesn't do a good job of explicitly calling 'close()' on statements or result sets this can cause memory leakage. Setting this property to "true" relaxes this constraint, and can be more memory efficient for some applications. Also the automatic closing of the statement and current result set in 'Statement.closeOnCompletion()' and 'Statement.getMoreResults([Statement.CLOSE_CURRENT_RESULT | Statement.CLOSE_ALL_RESULTS])', respectively, ceases to happen. This property automatically sets "holdResultsOpenOverStatementClose=true".

  Default Value	false
  Since Version	3.1.7

• queryInterceptors

  A comma-delimited list of classes that implement 'com.mysql.cj.interceptors.QueryInterceptor' that intercept query executions and are able influence the results. Query iterceptors are chainable: the results returned by the current interceptor will be passed on to the next in the chain, from left-to-right in the order specified in this property.

  Since Version	8.0.7

• queryTimeoutKillsConnection

  If the timeout given in 'Statement.setQueryTimeout()' expires, should the driver forcibly abort the connection instead of attempting to abort the query?

  Default Value	false
  Since Version	5.1.9