Re: [ODBC] SQL_QUERY_TIMEOUT

Hi Ondrej,

On 2017/05/09 18:13, Ondrej Dzivy Balucha wrote:
> Hi,
>
> This is only way to use SQL_QUERY_TIMEOUT?

In 9.06.0300, you can set ConnSettings(commands sent to backend on
connection)
in odbc.ini like

ConnSettings = set statement_timeout=30

regards,
Hiroshi Inoue

>
> Can I setup this in odbc.ini like global parameter for all my
> connections (applications)?
> It can be useful to independently check/break (outside application -
> when using third-party applications ) dead connection or unexpected
> long running query or other communication error.
>
> Other databases(ODBC clients) has parameter to set up this in config
> file.
> For example DB2 ODBC client has parameter ReceiveTimeout where I can
> setup how many second client wait for response from server. After this
> timeout client return communication error. This is great parameter for
> situation when I use third-party applications, for example.
>
> Regards
>
> Ondrej Dzivy Balucha
> Horizon, s.r.o. Prešov
> Francisciho 21
> 08001 Prešov
> tel/fax +421517491400/02
>
> On 06.05.2017 04:59, Inoue, Hiroshi wrote:
>> Hi Ondrej,
>>
>> On 2017/05/05 22:09, Ondrej Dzivy Balucha wrote:
>>> Hi,
>>>
>>> I found that in psqlODBC 09.05.0300 Release was implemented
>>> SQL_QUERY_TIMEOUT.
>>> How it works?
>>
>> Please call ODBC API like
>>
>>     SQLSetStmtAttr(hstmt, SQL_ATTR_QUERY_TIMEOUT, (void *) timeout, 0);
>>
>> regards,
>> Hiroshi Inoue
>>
>>> I need to set up odbc connection in Debian, that send me
>>> error(disconnet dead connection) after defined time, but I can`t find
>>> how can I setup SQL_QUERY_TIMEOUT in odbc.ini.
>>> I have installed latest odbc driver(09.06.0200)
>>>
>>> Regards