From: | Stuart Robinson <stuart(at)zapata(dot)org> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work with Tomcat |
Date: | 2002-07-02 07:11:15 |
Message-ID: | Pine.LNX.4.44.0207012356570.25686-100000@www.dreamingamerica.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello, all. I had a web application running on version 7.2 of Linux with
version 7.1.3 of PostgreSQL running together with version 7.1-1.2 of the
JDBC driver with version 3.2.3 of Tomcat. It worked fine.
Recently, I upgraded to version 7.2 of PostgreSQL and created a new
database from scratch. I put the latest version of the JDBC driver
(pgjdbc2.jar) in these directories:
/usr/local/jakarta/jakarta-tomcat/lib
/usr/local/driver
But when I start up Tomcat and try to run a query in the app against it, I
get the server output below, which I'm hoping someone can help me
understand. Thanks in advance.
-Stu
P.S. Here's the server output:
Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: FATAL 1: No pg_hba.conf
entry for host 127.0.0.1, user postgres, database mayanlanguages
Stack Trace:
java.sql.SQLException: FATAL 1: No pg_hba.conf entry for host 127.0.0.1,
user postgres, database mayanlanguages
at org.postgresql.Connection.openConnection(Connection.java:178)
at org.postgresql.Driver.connect(Driver.java:149)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at
com.mayanlanguages.db.DBConnection.getConnection(DBConnection.java:31)
at
com.mayanlanguages.db.DBConnection.getConnection(DBConnection.java:18)
at
com.mayanlanguages.misc.BaseFactory.select(BaseFactory.java:262)
at
com.mayanlanguages.misc.BaseFactory.select(BaseFactory.java:253)
at com.mayanlanguages.misc.BaseObject.select(BaseObject.java:144)
at
com.mayanlanguages.servlets.LanguageListServlet.processRequest(Unknown
Source)
at
com.mayanlanguages.servlets.BaseServlet.preProcessRequest(Unknown Source)
at com.mayanlanguages.servlets.CoreServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
End of Stack Trace
at org.postgresql.Driver.connect(Driver.java:166)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at
com.mayanlanguages.db.DBConnection.getConnection(DBConnection.java:31)
at
com.mayanlanguages.db.DBConnection.getConnection(DBConnection.java:18)
at
com.mayanlanguages.misc.BaseFactory.select(BaseFactory.java:262)
at
com.mayanlanguages.misc.BaseFactory.select(BaseFactory.java:253)
at com.mayanlanguages.misc.BaseObject.select(BaseObject.java:144)
at
com.mayanlanguages.servlets.LanguageListServlet.processRequest(Unknown
Source)
at
com.mayanlanguages.servlets.BaseServlet.preProcessRequest(Unknown Source)
at com.mayanlanguages.servlets.CoreServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: FATAL 1: No pg_hba.conf
entry for host 127.0.0.1, user postgres, database mayanlanguages
Stack Trace:
java.sql.SQLException: FATAL 1: No pg_hba.conf entry for host 127.0.0.1,
user postgres, database mayanlanguages
at org.postgresql.Connection.openConnection(Connection.java:178)
at org.postgresql
-- Stuart P. Robinson [stuart(at)zapata(dot)org]
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Robinson | 2002-07-02 07:32:33 | Re: upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work |
Previous Message | webmaster | 2002-07-01 17:13:14 | Connection failed |