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
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 |