it seems as if you referenced some variable (or sth.; look at the javadocs
at java.lang.NullPointerException for further details on what might be null)
in line 51 (in method cleanUp) that is null.
-mw
----- Original Message -----
From: "Mauricio Villa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 14, 2001 10:58 PM
Subject: Servlet Question.
> Hi, I have a Sun Microsystems machine, on this machine a .jsp page that
> inovkes a servlet called InsContactenos, when the page call the servlet it
> returns an error. I dont know wht must be happening, any one of you can
> help me? In previos messages i received your help and it worked fine!!!
now
> I need some help again. Thanks in advance, the log looks like this:
>
> [14/Feb/2001:15:23:01] info ( 887): Internal Info: loading servlet
> /institucional_contactenos.jsp
> [14/Feb/2001:15:23:16] info ( 887): Internal Info: loading servlet
> /contactenos.jsp
> [14/Feb/2001:15:23:30] info ( 887): Internal Info: loading servlet
> /servlet/InsContactenos
> [14/Feb/2001:15:23:30] info ( 887): /servlet/InsContactenos: init
> [14/Feb/2001:15:23:30] failure ( 887): Internal error: exception thrown
> from the servlet service function (uri=/servlet/InsContactenos):
> java.lang.NullPointerException, Stack: java.lang.NullPointerException
> at InsContactenos.cleanUp(InsContactenos.java:51)
> at InsContactenos.doPost(InsContactenos.java:39)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:826)
> at
>
com.netscape.server.http.servlet.NSServletRunner.Service(NSServletRunner.jav
> a:497)
>
>
> This is the page:
>
>
> <table>
> Aca se Ingresan los Datos Nuevos
> <Form Method="Post" ACTION="/servlet/InsContactenos">
> <Input Type="Text" Id="Fecha_Recibo" Name="Fecha_Recibo">
> <Input Type="Text" Id="Email_Origen" Name="Email_Origen">
> <Input Type="Text" Id="Destinatario" Name="Destinatario">
> <Input Type="Text" Id="Asunto" Name="Asunto">
> <Input Type="Text" Id="Cc" Name="Cc">
> <Input Type="Text" Id="Texto" Name="Texto">
> <Input Type="Submit">
> </Form>
> </table>
>
>
>
> This is the servlet:
>
>
>
> import java.io.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.sql.*;
>
> public class InsContactenos extends HttpServlet{
>
>
> protected String dbURL = "jdbc:odbc:orclx07";
> protected String dbuserID = "xxx";
> protected String dbpasswd = "xxx";
> protected Connection dbConnection;
> protected PreparedStatement stmt;
>
> public void doPost(HttpServletRequest req, HttpServletResponse res) throws
> ServletException, IOException
> {
>
> try{
> String Fecha_Recibo = req.getParameter("Fecha_Recibo");
> String Email_Origen = req.getParameter("Email_Origen");
> String Destinatario = req.getParameter("Destinatario");
> String Asunto = req.getParameter("Asunto");
> String Cc = req.getParameter("Cc");
> String Texto = req.getParameter("Texto");
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> dbConnection =
> DriverManager.getConnection("jdbc:oracle:oci:solutech/solutech@orclx07");
>
> Statement stmt = dbConnection.createStatement();
>
> String sql= "INSERT INTO bdct_conepros (FECHRECI, EMAILORIG,
> EMAILDEST, ASUNCONE, COPICONE, DATAMENS, FECHRESP, DATARESP) VALUES ('" +
> Fecha_Recibo + "', '" + Email_Origen +"', '" + Destinatario + "', '" +
> Asunto + "', '" + Cc + "','" + Texto + "', ' ', ' ', ' '";
>
> ResultSet rs = stmt.executeQuery(sql);
> stmt.close();
> dbConnection.close();
> }
> catch (Exception e)
> {
> cleanUp();
> e.printStackTrace();
> }
>
>
> }
>
>
> public void cleanUp()
> {
> try {
> System.out.println("Closing database connection");
> dbConnection.close();
> }
> catch (SQLException e)
> {
> e.printStackTrace();
> }
> }
>
>
> }
>
>
>
> __________________________
> Mauricio A. Villa
> Microsoft Certified Professional
> Development Department
> Solutech e-Business
> (574) 3120019 Ext. 13
> [EMAIL PROTECTED]
> www.solutech.com.co
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
