upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work with Tomcat - Mailing list pgsql-jdbc

From Stuart Robinson
Subject upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work with Tomcat
Date
Msg-id Pine.LNX.4.44.0207012356570.25686-100000@www.dreamingamerica.com
Whole thread Raw
In response to Re: Posgresql - openoffice-JDBC  (Glenn Holmer <gholmer@weycogroup.com>)
Responses Re: upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work
List 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 by date:

Previous
From: "Konstantinos Spyropoulos"
Date:
Subject: Re: Problem with JDBC: no suitable driver
Next
From: tony
Date:
Subject: Re: upgraded from 7.1.3 to 7.2.4 and can't get JDBC to work