returning a connection

Ranch Hand

Posts: 42

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
I am working with Tomcat with Netscape ES 3.6 on Solaris hitting a Sybase database.
I have been asked to put all my 'connecting methods' (i.e. those with sensitive information like password etc.) in separate classes.
I am trying the following code to 'return' the connection but it does not seem to be working.
I get this error:
java.sql.SQLException: No suitable driver
Now the same code, put in one class instead of two, works just fine.
What is going on?
I am attaching both codes below.

And this is the class that invokes the above class:

import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.sql.*;
import java.net.*;
import java.io.*;
import java.lang.*;
import java.lang.String.*;

public class rowCounter extends HttpServlet
{
    ResultSet CustResults;
    static Connection conx;
    public PrintWriter out;
    Statement stmt;
    Statement stmt2;
    String query1;
    public int h;

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

public void doGet(HttpServletRequest request,
      HttpServletResponse response)
      throws ServletException, IOException
  {
    
    response.setContentType("text/html");
    out = response.getWriter();
    out.println("<html><title>No. of rows in Customer Table</title>" +
                   "<body bgcolor=FFFFCC>");
    makeConnection conobj=new makeConnection();
    try
    {
      conx = conobj.makeDBconn();
    }
    catch(Exception ex) 
    {
      System.out.println("Exception [in call to makeConnection class]: "+ex.toString());
    }

makeQuery();
    readTable(query1);
    out.println("<h3>No. of Records: "+String.valueOf(h)+"</h3>");
  }

public void makeQuery()
  {
    query1="select uid, startdate, blah, blah, blah, blah, blah, blah from Customer";
  }
  public void readTable (String q)
   {
//counting rows in customer table
       try {
      stmt = conx.createStatement();
      CustResults = stmt.executeQuery(q);
      while(CustResults.next())
      {
        h++;
      }
       } catch (Exception ex) {
        System.out.println("CustResults - rowcount: "+ex.toString());
       }

}
}

If tomatoes are a fruit, then ketchup must be a jam. Taste this tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser