What did you specify for the ip address that tomcat uses for connecting to the
database? If, for example, tomcat is using the host name of your machine, or
its ip address that you'd use to connect to it from the outside, and psql is
using localhost (127.0.0.1) which is a special ip address that always goes to
the machine you're on, so that you don't have to know its ip address, that
would be a difference in the configuration. Or psql could be using a unix
filesystem socket and not using tcp/ip.
Postgres uses some config file with hba in its name to configure its network
security; fiddle with that and make it wide open so that tomcat can connect,
then go back and figure out how to tighten its security so that only localhost
can connect.
S Arvind wrote:
from this stack trace i can find that there is no problem in Tomcat or dbcp.
But when i try my postgre from outside application its working fine but when
i connect from local tomcat application it not working fine. I disable the
firewall and all ... but i keep on getting this stack ....
AbandonedObjectPool is used
(org.apache.tomcat.dbcp.dbcp.abandonedobjectp...@d5eb7)
LogAbandoned: true
RemoveAbandoned: true
RemoveAbandonedTimeout: 300
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (Connection refused. Check that the hostname and
port are correct and that the postmaster is accepting TCP/IP connections.)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
When i tried the netstat to check my vista ports , at that time i found one
wierd line...
TCP [::1]:80 Michael:50522 ESTABLISHED
TCP [::1]:50522 Michael:http ESTABLISHED
As my tomcat is listening to 80, i dont know why i dont get the ip address
in the netstat result for port 80 alone..
It is surely my tomcat request since only when i make the request its
showing...
I think the problem in ip only... please any one help.. postgres and tomcat
in same system and postgres is watchin to port 5432 only.
Arvind
*
"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison*
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
