Re: [cx-oracle-users] Time out parameter for connect?

[Anthony T. <ant...@gm...>]

Oops. You're right. Expire time is what I was thinking of but that is
only for expiring idle sessions as you said. So I believe there is no
way of doing this directly using Oracle alone. If anyone knows
otherwise, I'd be happy to be enlightened. :-)

On 10/25/05, Molina, Gerardo <Ger...@sc...> wrote:
> The only parameter I'm aware of relating to timeout on sqlnet is
> sqlnet.expire_time.  But this is for disconnecting idle sessions after a
> specified amount of time.  This is not exactly what I'm looking for -
> terminating an attempted connect after a specified amount of time.
>
> I very much appreciate the insightful feedback everyone has given
> already.
>
> Thanks,
> Gerardo
>
> -----Original Message-----
> From: cx-...@li...
> [mailto:cx-...@li...] On Behalf Of Paul
> Moore
> Sent: Tuesday, October 25, 2005 12:46 PM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Time out parameter for connect?
>
> On 10/25/05, Anthony Tuininga <ant...@gm...> wrote:
> > I don't believe there is any method in the OCI that allows you to
> > specify this value. Googling certainly suggests as much (others have
> > asked for this capability and been told that it does not exist). Note
> > that SQL*Net does allow you to specify such things so perhaps you need
>
> > to look at the SQL*Net configuration.
>
> I have certainly wanted this and never found a suitable way of managing
> it.
>
> You can do the connect in a thread, and wait for the thread to complete
> for a set time. If the connection hasn't been made by then, you can do
> whatever you want on a timeout (report an error, whatever).
> But if you then want to end your program, you'll need to wait for the
> thread - if you don't (for example, by making the thread a daemon) I've
> found you can get odd crashes or other errors (I never worked out why,
> or managed to put together a useful test case - I just marked it down as
> "don't do that").
>
> I'm not quite sure how you configure SQL*Net to time out after a given
> period. I remember looking, but I don't recall finding any suitable
> parameter.
>
> Paul.
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course Free
> Certification Exam for All Training Attendees Through End of 2005 Visit
> http://www.jboss.com/services/certification for more information
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course
> Free Certification Exam for All Training Attendees Through End of 2005
> Visit http://www.jboss.com/services/certification for more information
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>