Re: DriverManager.getConnection hangs - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: DriverManager.getConnection hangs
Date
Msg-id 3E9ADCFF.7000708@xythos.com
Whole thread Raw
In response to DriverManager.getConnection hangs  (George Peiov <gpeiov@yahoo.com>)
List pgsql-jdbc
George,

This seems very strange.  I don't have a clue as to what could be
causing the problem.  Can you submit a simple test case that reproduces
the problem so that we can investigate?

thanks,
--Barry

George Peiov wrote:
> Hi,
> I have a server written in java that uses the postgres
> JDBC driver to read
> data from Postgresql 7.2 server. The driver is the
> latest JDBC3 driver from
> their website. I am making a lot of selects when a
> client comes in but
> I am having a problem. After about 100 selects done
> from multiple
> threads each one using it's own connection object
> DriverManager.getConnection can't get a connetion any
> more. It hangs
> there for about 10-15 seconds and then I get a
> "connection refused.
> Make sure the server is running ...  bla bla bla"
> error. The Postgres
> server is still up, I can connect to it from another
> client and select
> data but the JDBC driver can't get a connection any
> more. I restart
> the server and then again, it gets 2 connections from
> 2 threads, it
> executes about 100 selects and hangs again when is
> trying to get the
> third connection. Any idee on what might be hapenning
> ?
> Thanks,
> George
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://tax.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: Getting the real column name.
Next
From: Barry Lind
Date:
Subject: Re: "text" type is java.sql.Types.varchar not longvarchar