freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Problems with servlets and FreeTDS-JDBC since using JDK1.1.8

From: Andreas Tille <tillea AT rki.de>
To: FreeTDS mailing liste <freetds AT franklin.oit.unc.edu>
Subject: Problems with servlets and FreeTDS-JDBC since using JDK1.1.8
Date: Mon, 20 Mar 2000 16:32:22 +0100 (CET)

Hello,

since I upgrade to JDK 1.1.8 (from Debian GNU/Linux potato) I
have problems with my servlets which use FreeTDS JDBC to access
a MS SQL 7.0 server.

I appended an example.

The result is a page just containing item "1". There are no
explizite errors. It just dies.

I'm really clueless and hope that anybody could help.

It's the same with the latest JDBC-Snapshot and the one before (which
I used a long time successfully).

Kind regards

Andreas.

import java.io.*;
import java.sql.*;

import javax.servlet.*;
import javax.servlet.http.*;


/**
 * This is a simple example of an HTTP Servlet.  It responds to the GET
 * and HEAD methods of the HTTP protocol.
 */
public class Hallo extends HttpServlet
  implements SingleThreadModel
{ 

Connection          con;
ResultSet           rs;
Statement           stmt; 
ServletOutputStream out;


  public void init(ServletConfig conf) throws ServletException {
    super.init(conf);

    try {
      Class.forName("com.internetcds.jdbc.tds.Driver");
      //      Class.forName("com.internetcds.jdbc.tds.SybaseDriver");
    } catch (ClassNotFoundException e) { 
      System.err.println("CNF: " + e.getMessage());
      return;
    }

    String url      = "jdbc:freetds:sqlserver://sql03/Test";
    String user     = "TestUser" ;
    String password = "test";

    try {
      con   = DriverManager.getConnection(url, user, password);
    } catch (SQLException se) {
      System.err.println("SQL: " + se.getMessage());
      return;
    } 

  }


    /**
     * Handle the GET and HEAD methods by building a simple web page.
     * HEAD is just like GET, except that the server returns only the
     * headers (including content length) not the body we write.
     */
  public void service (HttpServletRequest request,
                       HttpServletResponse res) 
    throws ServletException, IOException
  {
	   //            PrintWriter out;
    String title = "Example Apache JServ Servlet", query;

    res.setContentType("text/html");

    out  = res.getOutputStream();
            
    out.println("<HTML><HEAD><TITLE>");
    out.println(title);
    out.println("</TITLE></HEAD><BODY bgcolor=\"#FFFFFF\">");
    out.println("<H1>" + title + "</H1>");

    try {
      out.println("1<br>");
      rs    = stmt.executeQuery("SELECT * FROM Mitarbeiter");
      out.println("2<br>");
      if ( !rs.next() ) {
      out.println("3<br>");
        System.err.println("Fehler 4");
        return ;
      }
      out.println("4<br>");
      query = rs.getString("FName");
      out.println("5<br>");
      out.println(query);
      out.println("6<br>");
    } catch (SQLException se) {
      out.println("SQL: " + se.getMessage());
      return;
    } 
    out.println("<H2>Gratulation<br>");
    out.println("</BODY></HTML>");
    out.close();
  }
}

Problems with servlets and FreeTDS-JDBC since using JDK1.1.8, Andreas Tille, 03/20/2000