Our application (a service) uses a thread with a TOracleSession to connect to a database. We are using an other thread to create a new connection.
A dataModule is created in the create of this new thread, after the create we connect to the database
In the execute of the thread we try to make a new (third) connection using a NEW TOracleSession. To connect to the database takes about 30 seconds. The second time we try to do this it takes 1 minute, the next takes 1:30 and so on.
We have traced the problem in to the attach of the server (oracle.pas). The time increases every time we try to connect.
We are using DOA (4.0.7.1) with Delphi 2005.
We are using default settings of the TOracleSession.
This problem only occurs when we make a connection in the execute of a thread.
If someone has any ideas, share them please, we are running out
A dataModule is created in the create of this new thread, after the create we connect to the database
In the execute of the thread we try to make a new (third) connection using a NEW TOracleSession. To connect to the database takes about 30 seconds. The second time we try to do this it takes 1 minute, the next takes 1:30 and so on.
We have traced the problem in to the attach of the server (oracle.pas). The time increases every time we try to connect.
We are using DOA (4.0.7.1) with Delphi 2005.
We are using default settings of the TOracleSession.
This problem only occurs when we make a connection in the execute of a thread.
If someone has any ideas, share them please, we are running out