Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)
От | Radosław Smogura |
---|---|
Тема | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) |
Дата | |
Msg-id | 201108102045.57813.rsmogura@softperience.eu обсуждение исходный текст |
Ответ на | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) (Alex Nordlund <deep.alexander@gmail.com>) |
Ответы |
Re: Cannot create PoolableConnectionFactory (The connection
attempt failed.)
(Bruce Adams <bruce.adams@acm.org>)
|
Список | pgsql-jdbc |
Ok, Try add following for your Tomact's Java (I haven't worked for years with Tomcat but there may be run.bat, run.sh, it will be probaly somewhere near "- mx"): -Djava.net.preferIPv4Stack=true and/or (on Linux) echo 0 > /proc/sys/net/ipv6/bindv6only and/or expose PostgreSQL on IPv6, and change hostname to ::1 Regards, Radek Alex Nordlund <deep.alexander@gmail.com> Wednesday 10 of August 2011 18:48:34 > 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 по дате отправления:
Предыдущее
От: Andrew HastieДата:
Сообщение: Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)
Следующее
От: Bruce AdamsДата:
Сообщение: Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)