You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Galbayar <ga...@mobinet.mn> on 2002/09/14 06:43:01 UTC
RE: jdbc problem - tomcat4.0.4/mod_jk/postgresql7.0.
put driver jar file to the $TOMCAT_HOME/common/lib
-----Original Message-----
From: damar thapa [mailto:damar@netvigator.com]
Sent: Saturday, September 14, 2002 8:28 PM
To: Tomcat Users List
Subject: jdbc problem - tomcat4.0.4/mod_jk/postgresql7.0.
Hi,
I have the following code, which I can compile, but when I run, I get
SQLException (full exception output following this code):
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class AddDispServlet extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try{
Class.forName("org.postgresql.Driver");
con =
DriverManager.getConnection("jdbc:postgresql:contacts","damar","");
stmt = con.createStatement();
rs = stmt.executeQuery("select ser, name, email, hompage,
telephone, postaladdress from address");
out.println("<HTML><HEAD><TITLE>My contacts</title></head>");
out.println("<body>");
out.println("<url>");
while(rs.next()){
out.println("<li>" + rs.getInt("ser")+"
"+rs.getString("name")+" "+rs.getString("email")+
" "+rs.getString("hompage")+" "
+rs.getString("telephone")+" " +rs.getString("postaladdress"));
}
out.println("</ul>");
out.println("</body></html>");
}
catch(ClassNotFoundException e){
out.println("Couldnot load database driver : " + e.getMessage());
}
catch(SQLException e){
out.println("SQLException caught: " + e.getMessage());
}
finally{
try{
if(con!=null)
con.close();
}
catch(SQLException ignored){}
}
}
}
SQLException caught: Something unusual has occured to cause the driver
to fail. Please report this exception: Exception: java.sql.SQLException:
FATAL 1: IDENT authentication failed for user "damar" Stack Trace:
java.sql.SQLException: FATAL 1: IDENT authentication failed for user
"damar" at org.postgresql.Connection.openConnection(Connection.java:178)
at org.postgresql.Driver.connect(Driver.java:149) at
java.sql.DriverManager.getConnection(DriverManager.java:512) at
java.sql.DriverManager.getConnection(DriverManager.java:171) at
AddDispServlet.doGet(AddDispServlet.java:18) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
1027)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125
)
at java.lang.Thread.run(Thread.java:536) End of Stack Trace
Remaining note:
My OS is Debian3. (Woody).
The given sql statement is correct ie it can produce result in normal
circumstances. I have placed pgjdbc2.jar in
/wepapps/Project/WEB-INF/lib, and compiled the above code normally with
javac, and placed in in ../WEB-INF/classes.
What I have missed? Any pointers would be highly appreciated.
Thanks
Damar
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>