----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
please if somebody knows the answer of my problem, sen me a mail to:
[EMAIL PROTECTED]
thank yu
I made a small application to connect with a DataBase postgres on
command line. Everything worked well. When I do a similar program, but
in a servlet, the problems appear. I'm using the following:
Jserv 1.1.2
Apache 1.3.6
I have the following directories that I believe are vry importantas to
acces postgress from a servlet:
/usr/lib/pgsql/lib/postgresql.jar
/usr/local/JSDK2.0/lib/jsdk.jar
/usr/lib/apache/ApacheJserv.jar
After, I put the following lines on jserv.properties file
wrapper.classpat=/usr/lib/pgsql/lib/postgresql.jar
wrapper.classpat=/usr/local/JSDK2.0/lib/jsdk.jar
wrapper.classpat=/usr/lib/apache/ApacheJserv.jar
I have this problem during one week. I'm trying to run the following
servlet that I think is done right. Next the servlet and the exception
is:
InServlet: init
[12/10/2000 19:16:51:620 GMT+00:00] Error en ClassForName:
java.lang.ClassNotFoundException: postgresql.Driver
It means the servlet don't load postgresql.Driver, But If ido this
program om coomand line, it is loaded. Thanks in advance
///////////////////////////////////////////////////////////
import java.sql.*;
import java.util.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*Esta clase lo que hace es recibir datos de un formulario del web y
meter, consultar o modificar
*los datos en la tabla tienda de postgres.
*
*@author dr7tbientu miralo y mira a ver s
*/
public class InServlet extends HttpServlet {
Connection con;
public void init(ServletConfig sc) throws ServletException {
super.init(sc);
//se carga el driver
try {
Class.forName("postgresql.Driver");
}catch (ClassNotFoundException ex) {
sc.getServletContext().log("Error en ClassForName:
"+ex.toString());
System.out.println(ex.toString());
}
//conectamos a la base de adatos
try{
con=DriverManager.getConnection("jdbc:postgresql:mydb",
"postgres", "");
}catch (SQLException ex) {
System.out.println(ex.toString());
}
}//fin init()
public void destroy() {
super.destroy();
try{
con.close();
}catch(SQLException e){
System.out.println("Imposible cerrarla
conexión"+e.toString());
}
}//fin destroy
public void doPost(HttpServletRequest request,
HttpServletResponse response) throws
ServletException, IOException {
String pvp, pbase;
response.setContentType("text/html");
pvp = request.getParameter("pvp");
pbase= request.getParameter("pbase");
Statement stm;
try{
stm = con.createStatement();
int numRowsUpdated = stm.executeUpdate("INSERT INTO tienda
VALUES ("+Integer.parseInt(pvp)+","+Integer.parseInt(pbase)+")");
PrintWriter out = response.getWriter();
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>Registro actualizado</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("<H1>Operación realizada con exito</H1>");
out.println("<H3>Actualizadas"+numRowsUpdated +
"filas</H3>");
out.println("</BODY>");
out.println("</HTML>");
out.flush();
out.close();
}catch(Exception e){
try{
System.out.println(e.toString());
//System.out.println("Error en la actualización" +
e.getMessage());
//Este es el código que muestra un html en el navegador
y
que arrija un NullPointerException
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<HEAD>");
out.println("</HEAD>");
out.println("<body>");
out.println("Error: "+e.toString());
out.println("</body></html>");
out.flush();
out.close();
}catch(Exception ex){
System.out.println(e.getMessage());
}finally {
try{
stm = null;
}catch(Exception ex){}
}
}
}
}
///////////////////////////////////////////////////////////////////
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
