tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From S Arvind <arvindw...@gmail.com>
Subject Re: Database pooling prob
Date Mon, 04 May 2009 07:18:49 GMT
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.wright@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.AbandonedObjectPool@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message