Thanks everone. The problem i found is completely different. Its vista administaratve rights problem. I corrected that and our rocking tomcat is rocking.. Thanks every one.
Arvind S *"Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison* On Mon, May 4, 2009 at 8:42 AM, Rusty Wright <rusty.wri...@gmail.com> wrote: > 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 > >
