DriverManager.getConnection hangs

From: George Peiov <gpeiov(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: DriverManager.getConnection hangs
Date: 2003-04-11 21:17:12
Message-ID: 20030411211712.74238.qmail@web12206.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jason Dinger 2003-04-11 21:24:37 Fixed: tomcat/postgres problem
Previous Message . 2003-04-11 16:42:15 "text" type is java.sql.Types.varchar not longvarchar