skip to main content
DataDirect Connect Drivers : MySQL Driver : Connection Properties : InteractiveClient
  
InteractiveClient
Purpose
Controls the length of time (in seconds) a connection can be idle before the server ends the connection by setting the connection’s session wait_timeout variable.
Valid Values
true | false
Behavior
If set to true, the session wait_timeout variable is set using the MySQL global interactive_timeout variable value. If the value of the global interactive_timeout variable is changed after a connection is established, any connection that is created after the variable is changed uses the new timeout value.
If set to false, the session wait_timeout variable is set using the MySQL global wait_timeout variable value. If the value of the global wait_timeout variable is changed after a connection is established, any connection that is created after the variable is changed uses the new timeout value.
If the value of the session wait_timeout variable is changed after a connection is established, only the timeout for that connection is affected. For example, if the session wait_timeout variable is changed to a value of 3600 (seconds) using the InitializationString property as shown in the following URL, the new timeout value is used for the current connection:
jdbc:datadirect:mysql://server1:3306;DatabaseName=test;
InitializationString=(set@@wait_timeout=3600)
Default
false
Data Type
boolean