Page 1 of 1

timeouts query/connection

Posted: 14.07.2006, 13:19
by Terence
Howto Set/Get Query and Connection Timeouts in Zeos?

Tx for help.

Posted: 14.07.2006, 14:43
by mdaems
Hi Fabian,

Depends fully on the database. All this kind of options are db independent.
For mysql you can look in 'TZMySQLConnection.Open'. There somebody tried to implement this. I never tried. As you see, the options available in the API are not all implemented. Just compression and timeout. Whether this works or not? No idea. Getting this information is impossible as far as I know (unless you query something like "show session variables like '%timeout%'")

Ideas about a general solution?

Mark

Posted: 14.07.2006, 15:00
by Terence
No, not really. I thought it was already implemented.
As far as no one has problems witrh timeouts i would see it as "nice2have".