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
Следующее
От: tony
Дата:
Сообщение: Re: upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work