Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)
От | Alex Nordlund |
---|---|
Тема | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) |
Дата | |
Msg-id | CADD7sv2cz9UO+W83J9GLtY_42oq9KBD6z0M8WnA+GGNEhF1j0g@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) (Radosław Smogura <rsmogura@softperience.eu>) |
Ответы |
Re: Cannot create PoolableConnectionFactory (The connection
attempt failed.)
(Dave Cramer <pg@fastcrypt.com>)
Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) (Radosław Smogura <rsmogura@softperience.eu>) |
Список | pgsql-jdbc |
Hi, Same result with 127.0.0.1 2011-08-10 13:14:30,615 main ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot create PoolableConnectionFactory (The connection attempt failed.) 2011-08-10 13:14:30,618 main WARN [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The connection attempt failed.) [snip 60 lines] Caused by: org.postgresql.util.PSQLException: The connection attempt failed. With risk for looping (my eyes are tired and do not easily spot where the log ends) I have the full log here. http://dpaste.org/6O5d/ --- //Alex On Wed, Aug 10, 2011 at 5:31 PM, Radosław Smogura <rsmogura@softperience.eu> wrote: > So it's harder topic, > - try to replace localhost with 127.0.0.1 > I don't know why You don't have (didn't send) PostgreSQL exception, try to > connect to server with simple servlet, using old fashioned JNDI, check > hibernate configuration. > > It's hard to see if You have passed wrong JNDI name, you have no driver in > classpath, or it's PostgreSQL exception. Send full backtrace of error. > > Regards > > On Wed, 10 Aug 2011 17:19:13 +0100, Alex Nordlund wrote: >> >> Hi Radoslaw, >> >> Thank you for your reply. >> >> I can confirm that with psql --host=127.0.0.1 it works, however it >> still does not work with jdbc. > >> --- >> //Alex >> >> >> >> On Wed, Aug 10, 2011 at 5:13 PM, Radosław Smogura >> <rsmogura@softperience.eu> wrote: >>> >>> Hi, >>> >>> Check your "access file" pga_hba.conf if it allows TCP/IP connections. By >>> default psql connects on Unix socket >>> try to connect using >>> psql --host=127.0.0.0.1 --port=5432 -U crowd crowdiddb >>> >>> I this fail You probably didn't exposed TCP/IP access (or You have >>> localhost >>> firewall?). >>> >>> Regards, >>> Radosław Smogura >>> >>> On Wed, 10 Aug 2011 13:53:59 +0100, Alex Nordlund wrote: >>>> >>>> Hi, >>>> >>>> I get the following errors: >>>> >>>> INFO: Deploying configuration descriptor openidserver.xml >>>> 2011-08-10 13:14:30,600 main WARN >>>> [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: >>>> null >>>> 2011-08-10 13:14:30,615 main ERROR >>>> [org.hibernate.util.JDBCExceptionReporter] Cannot create >>>> PoolableConnectionFactory (The connection attempt failed.) >>>> 2011-08-10 13:14:30,618 main WARN [org.hibernate.cfg.SettingsFactory] >>>> Could not obtain connection metadata >>>> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create >>>> PoolableConnectionFactory (The connection attempt failed. >>>> >>>> And my Resource looks like this: >>>> >>>> <Resource name="jdbc/CrowdIDDS" auth="Container" >>>> type="javax.sql.DataSource" >>>> username="crowd" >>>> password="hiddenfortheml" >>>> driverClassName="org.postgresql.Driver" >>>> url="jdbc:postgresql://localhost:5432/crowdiddb" >>>> /> >>>> >>>> >>>> Am I doing something wrong? >>>> >>>> My username is crowd, it's set to only use MD5 auth, the DB is >>>> crowdiddb and I can access it using psql. >>>> >>>> --- >>>> //Alex >>> >>> > >
В списке pgsql-jdbc по дате отправления:
Предыдущее
От: Alex NordlundДата:
Сообщение: Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)