On Feb 2, 2005, at 6:46 AM, Dossy Shiobara wrote:
On 2005.02.02, Sapna Gupta <[EMAIL PROTECTED]> wrote:
I have installed the AOLServer with oracle and it's working good. I
want to specify the connection timeout in the nsoracle driver. How i
can do that?
I mean i want to configure the timeout when server tries to connect to
the database.
This may be something you'll have to configure in your Oracle SQL*Net
configuration -- on the client side, this would be your TNSNAMES.ORA
file.
I don't think there is a connection time out parameter in tnsnames.ora
- at least not in the stock setups that I have built using the Oracle
network configuration assistant.
Sapna, what are you trying to do? AOLserver tries to get database
handles on startup and then it holds onto a minimal number of them even
if they are not being used. If the database is not available on server
start up, the server logs an error and goes on. When you try to get a
database handle, that API has a timeout parameter:
ns_db gethandle ...If a timeout is not specified or timeout is zero,
ns_db gethandle will wait indefinitely (perhaps forever) for the
requested number of handles to become available. If timeout is greater
than zero, ns_db gethandle will either return with the handles within
that time period, or return "" if the time period was exceeded, or
generate a Tcl error of the form "could not allocate n handle(s) from
pool 'poolname'. If timeout is less than zero, ns_db gethandle will not
block. It will either return with the handles, or generate the above
Tcl error.
So I think you need to specify the time out you want in your
application code - whenever it gets database handles.
--
[EMAIL PROTECTED]
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
