6.3.6 Statements

• cacheDefaultTimeZone

  Caches clients default time zone. This results in better performance when dealing with time zone conversions in Date and Time data types, however it wont 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 (defaults to 'true').

  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 ResultSet 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 should be placed "in between" query execution to influence the results. QueryInterceptors are "chainable", the results returned by the "current" interceptor will be passed on to the next in in the chain, from left-to-right order, as 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