upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work with Tomcat
От | Stuart Robinson |
---|---|
Тема | upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work with Tomcat |
Дата | |
Msg-id | Pine.LNX.4.44.0207012356570.25686-100000@www.dreamingamerica.com обсуждение исходный текст |
Ответ на | Re: Posgresql - openoffice-JDBC (Glenn Holmer <gholmer@weycogroup.com>) |
Ответы |
Re: upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work
(tony <tony@animaproductions.com>)
|
Список | 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@zapata.org]
В списке pgsql-jdbc по дате отправления:
Предыдущее
От: "Konstantinos Spyropoulos"Дата:
Сообщение: Re: Problem with JDBC: no suitable driver