ClientInteractive Property

In This Topic

Determines the inactivity timeout before the server breaks the connection.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ClientInteractive As Boolean

public bool ClientInteractive {get; set;}

Property Value

If true, the server breaks the connection after number of seconds specified in interactive_timeout sever variable, otherwise wait_timeout is used. The default value is false.

Remarks

The interactive_timeout and wait_timeout variables can be set in my.ini file.

Example

The following example demonstrates usage of this property.

csharp

static void Main(string[] args) {

        MySqlConnectionStringBuilder connStrBuilder = new MySqlConnectionStringBuilder();
        connStrBuilder.UserId = "root";
        connStrBuilder.Password = "";
        connStrBuilder.Host = "localhost";
        connStrBuilder.Port = 3306;
        connStrBuilder.Database = "test";
        connStrBuilder.Pooling = false;
        connStrBuilder.ClientInteractive = true;

        MySqlConnection myConn = new MySqlConnection(connStrBuilder.ToString());
        MySqlCommand command = new MySqlCommand("select 1", myConn);
        myConn.Open();

        //If interactive_timeout is set to a value less than 60, the command will throw exception:
        //Lost connection to MySQL server during query
        Thread.Sleep(new TimeSpan(0, 0, 60));
        try {
                command.ExecuteNonQuery();
        }
        catch (MySqlException e) {
                if (e.Code == 2013)
                        Console.WriteLine(e.Message);
        }
}

Visual Basic

Sub Main()
        Dim connStrBuilder As MySqlConnectionStringBuilder = New MySqlConnectionStringBuilder()
        connStrBuilder.UserId = "root"
        connStrBuilder.Password = ""
        connStrBuilder.Host = "localhost"
        connStrBuilder.Port = 3306
        connStrBuilder.Database = "test"
        connStrBuilder.Pooling = False
        connStrBuilder.ClientInteractive = True

        Dim myConn As MySqlConnection = New MySqlConnection(connStrBuilder.ToString())
        Dim command As MySqlCommand = New MySqlCommand("select 1", myConn)
        myConn.Open()

        'If interactive_timeout is set to a value less than 60, the command will throw exception:
        'Lost connection to MySQL server during query
        Thread.Sleep(New TimeSpan(0, 0, 60))
        Try
                command.ExecuteNonQuery()
        Catch ex As MySqlException
                If (ex.Code = 2013) Then
                        Console.WriteLine(ex.Message)
                End If
        End Try
End Sub

Reference

MySqlConnectionStringBuilder Class
MySqlConnectionStringBuilder Members

Send Feedback