Problem connecting by JDBC with a SERVLET

From: Andres Davila <adavila0026(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem connecting by JDBC with a SERVLET
Date: 2002-02-28 23:46:27
Message-ID: 20020228234627.99730.qmail@web12305.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I try to access a database on a Linux server, with
Apache, Tomcat & Postgres.

The servlet should connect to the database, make a
select and display the results in a webpage

My code is the following:

Connection con = null;
Statement stmt = null;
ResultSet rs = null;

res.setContentType("text/html");
PrintWriter out = res.getWriter();

try {
String database = "intvuelos";
String username = "nobody";
String password = "";
Class.forName("org.postgresql.Driver");

con =
DriverManager.getConnection("jdbc:postgresql://10.65.28.12/invuelos",
username, password);
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT numeroempleado,
origen, destino FROM viajes");

out.println("<html><head><title>Consulta de
Datos</title></head>");
out.println("<body>");

out.println("<ul>");

while(rs.next()){

out.println("<li>"+
rs.getString("numeroempleado") + " " +
rs.getString("nombre") + " " +
rs.getString("apellidos"));

}
out.println("</ul>");
out.println("</body></html>");
}

catch(ClassNotFoundException e){
out.println("Couldn't load database driver: " +
e.getMessage());
}
catch(SQLException e){
out.println("SQLException caught: " +
e.getMessage());
}
finally{
try{
if(con !=null) con.close();
}
catch (SQLException ignored){ }
}
}
}

****

Please help me if you can

__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-02-28 23:54:56 Re: Problem connecting by JDBC with a SERVLET
Previous Message Amandeep Jawa 2002-02-28 21:19:23 Here is a Servlet for Testing Servlet-JDBC Connections & JDBC Drivers