Re: JDBC Connection & Listener

From: Dustin Aleksiuk <daleksiuk_at_home.com>
Date: Sat, 24 Nov 2001 09:00:16 GMT
Message-ID: <AkJL7.67461$6b.3520174@news2.calgary.shaw.ca>

You might want to make 100% sure you're closing/returning all your connections properly in your Java code. If not, you'll hit whatever the maximum number of connections (big trouble).

Dustin Aleksiuk

"soweto" <bwa.bwa_at_wanadoo.fr> wrote in message news:3bfe8c81$0$9964$626a54ce_at_news.free.fr...
> hi
> all of my JDBC connectors break after 3 hour and i don't know why to on my
> AIX 43 and oracle 805.
>
> "Tarik" <tarik_sadat_at_amat.com> a écrit dans le message de news:
> b4f9d801.0111230926.5a590e6c_at_posting.google.com...
> > Hello everybody
> >
> > Has anybody experienced strange behaviour with the TNS Listener when
> > connecting via JDBC? What I've found is that when a connection request
> > is rejected, usually because of an invalid username/password, the JDBC
> > driver makes lots of connection attempts (eg about 100). Why is it
> > doing this? I'm using JDBC 1.2 (I think; well, classes12.zip at any
> > rate), and the Listener is running on a Windows NT server (to an 8.1.6
> > database).
> >
> > I notice when I try similar invalid login attempts via ODBC or via
> > SQL*Plus I don't see this behaviour. I just get the one connection
> > attempt.
> >
> > Thanks in advance.
> > Tarik
>
>
Received on Sat Nov 24 2001 - 03:00:16 CST