Page 1 of 1

Time out tzconnection with lazarus and firebird2.5

Posted: 01.02.2017, 11:20
by joviali
Hello everyone, this is my first message. I am making an application that attacks a remote database in firebird 2.5. In principle it works fine. The problem comes with the response time of fall. To see if I explain tego the connection open against my remote server and if I remove the ethernet cable. When I do an open a table takes to say that it has no connection 15 minutes .


The operating system server is a windows 10 and the one that makes the connection is a debian linux.
What can I do when the network drops? .

Re: Time out tzconnection with lazarus and firebird2.5

Posted: 02.02.2017, 08:57
by marsupilami
Hello joviali,

currently there is no way to change the timeout for firebird - at least not that I am aware of it. Usually you will get some kind of exception that you will have to handle. But the only thing you can do in a situation like this is to close all datasets and close the connection.

With best regards,

Jan

Re: Time out tzconnection with lazarus and firebird2.5

Posted: 02.02.2017, 10:57
by joviali
Thank you for answering so quickly.

I come from delphi and what I pose has no major problem (I do not use in delphi Zeos).

We'll see .
1- There will be a connection with a zconnection.
2-The connection is satisfactory.
3 Lift the ethernet cable
4 I open with a tquery

I do not understand how it takes 15 minutes to make a mistake.

There has to be something, this is not viable.

I understand what you tell me to lift the connection and then close it every time there is something. But I refer to the law of Murphi.Si something can happen will happen. At the same time that there is the open the Tquery remove the cable and I have the same problem.

Re: Time out tzconnection with lazarus and firebird2.5

Posted: 06.02.2017, 11:29
by marsupilami
Hello Joviali,

I understand what you mean. But the 15 minutes are an issue in the firebird client lib and not within Zeos. Even more it possibly is a problem in your Windows configuration because usually I would expect Windows to signal a lost connection to the FB client if the network cable is removed almost immediately. Maybe you want to ask this question on the FB mailinglist?

With best regards,

Jan

Re: Time out tzconnection with lazarus and firebird2.5

Posted: 08.02.2017, 17:28
by joviali
SOLUTION. At the end is the configuration of the operating system itself in this case in linux (debian). I leave you a link:
https://www.ibphoenix.com/resources/documents/how_to/doc_104

Thank you