Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)
От | Bruce Adams |
---|---|
Тема | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) |
Дата | |
Msg-id | 4E42D3C9.4010904@acm.org обсуждение исходный текст |
Ответ на | Re: Cannot create PoolableConnectionFactory (The connection attempt failed.) (Radosław Smogura <rsmogura@softperience.eu>) |
Список | pgsql-jdbc |
For recent Tomcat releases, the clean place for Java options is in bin/setenv.sh (for Unix-like platforms) and bin/setenv.bat (for Windows). My specific example tunes Java heap stuff and tells Tomcat to keep a pid file (which improves the behavior of Tomcat's shutdown script). = setenv.bat = set CATALINA_PID="%CATALINA_HOME%\temp\tomcat.pid" set JAVA_OPTS=-Xmx1g -XX:MaxPermSize=256m = setenv.sh = export CATALINA_PID="$CATALINA_HOME/temp/tomcat.pid" export JAVA_OPTS="-Xmx1g -XX:MaxPermSize=256m" - Bruce On 08/10/2011 02:45 PM, Radosław Smogura wrote: > 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 по дате отправления:
Предыдущее
От: Radosław SmoguraДата:
Сообщение: Re: Cannot create PoolableConnectionFactory (The connection attempt failed.)