Session timeout

[scheprj]

Can I set the session timeout?
I'm using a Orcale XE 10 client installation.

I want to have a quicker respons on the TQuery when the remote database is down.

Kind Regards,

Rob van Scheppingen
Sun Test Systems

 

[Marco Kalter]

You can only set session timeouts on the Oracle Server by assigning a profile to the Oracle user. For more information, see:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm

 

[scheprj]

Thanks for the reply.
This is not what I'm looking for.
If I connect to a database with sql I can set a CONNECTION_TIMEOUT see example:

sqlplus rolladm_sun/sun@"(DESCRIPTION = (CONNECT_TIMEOUT=3)(ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcpcomm)(PROTOCOL = TCP)(Host = oracle_server.net)(Port = 1521)))(CONNECT_DATA = (SID = xe)))"

Can I set this in the connection with DOA?

br.

 

[Marco Kalter]

Yes, you can use the same connection parameters:

MySession.LogonUsername := 'rolladm_sun';
  MySession.LogonPassword := 'sun';
  MySession.LogonDatabase := '(DESCRIPTION = (CONNECT_TIMEOUT=3)(ADDRESS_LIST = ....))';

 

[scheprj]

Thanks.

I didn't know that you could place a connect string in this possition.

The connection is made, I have to test the timeout yet.

br.