Devart Forums

Hello,

My application makes two kinds of connection to MySQL database.

Server - regular connection... keeps connection for a long time.

Client - sporadic connection... executes a query and the connection should close.

I have changed the MySQL init variables to close INTERACTIVE connections in 30 secs. However, I cant seem to pass that flag and all connections are going as regular connections.

So how do I connect to MySQL using the client_interactive param = true ?

Nirav

Hello,

Unfortunately, for the time being, dbExpress driver for MySQL does not support interactive connections. We will add support of interactive connections in one of the next dbExpress driver for MySQL builds.

5 years left. Is there any progress with support for CLIENT_INTERACTIVE?

I'm adding this support each time we renew DevArt subscription and get new sources. Maybe I can send you the "diff"? There are very few lines of code, but the feature is really important because without it mysql server drops connections for interactive clients (shells, IDE front-ends etc) too shortly, after a very tiny timeout. On the other hand, it's not possible to make this timeout longer than 10-20 seconds for the scripts that produce online pages, otherwise we may get too many open connections and would get problems with online pages.

Support for interactive connections was added in dbExpress Driver for MySQL 6.1.2 от 25-Dec-12.
You can find more details in the Readme.html file at %DBXMySQL%\Readme.html, where %DBXMySQL% - the path to the installed dbExpress driver for MySQL.

guess what? I just updated to it :) (account starts with gitm...)
and guess what? I found your changes are very similar to what I did
Thank you!

Thank you for the interest in our products.
Please contact us if you have any questions about our products.