TableModel-unable to locate error

[Chak Terlapu]

Hi,
I am using TableModel to connect to a database and display the results. I am unable to display the table. It doesn't display anything. Below is the code from the TableModel I am using to connect to database. Could anyone help me find the errors please. any help would be ggreatly appreciated.
Thanks

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.*;
import java.util.StringTokenizer;
import java.util.Vector;
import javax.swing.table.AbstractTableModel;
import java.util.*;
import java.text.*;
import java.sql.*;
import java.net.*;
import java.util.Properties;
import java.applet.Applet;
import oracle.jdbc.driver.*;
public class HolidayTableModel extends AbstractTableModel {
   int rows = 0;
   Vector data = new Vector();
   String[] columnNames = {"HOLIDAY_CODE",
                           "HOLIDAY_DESCR",
                           "HOLIDAY_DATE",
                           "LAST_CHANGE_USERID",
                           "LAST_CHANGE_TMSTMP"};
   Connection con;
   Statement sqlStatement;
   int numCols = 0;
   int numRows = 0;
   Vector tableData;
                          
   public HolidayTableModel() throws ClassNotFoundException,                                      SQLException
   {
       tableData = new Vector();
       int currentRow = 0;
       try
       {
          Class.forName("oracle.jdbc.driver.OracleDriver");
          Connection con = DriverManager.getConnection("jdbc [img]http://www.javaranch.com/ubb/redface.gif[/img]dbc:thin:@d1b:1521:1B","asdf","asdf");
          System.out.println("Connection Established...");
          sqlStatement = con.createStatement();
          ResultSet rs = sqlStatement.executeQuery("select * from                                                     hlday10t");
         System.out.println("ResultSet Statement executed...");
         numCols = rs.getMetaData().getColumnCount();
         columnNames = new String[numCols];
         //Get the column names and cache them
         for(int column = 0; column<numCols; column++)>
         {
           columnNames[column] =                    rs.getMetaData().getColumnLabel(column+1);
         }
         while (rs.next()) 
         {
            Vector rowVector = new Vector();
            for (int currentCol = 1; currentCol < numCols;                  currentCol++) 
            {
              rowVector.addElement(rs.getObject(currentCol));
            }
                                              tableData.addElement(rowVector);
            con.close(); 
            fireTableChanged(null);//Tell the listener a new                                    //table has arrived
          }
        }
        catch(ClassNotFoundException e){
System.out.println("*** Cannot find database driver classes:                         "+e.getMessage());
         }                                                  
         catch(SQLException e) {
         System.out.println("*** Cannot connect to this database:                              "+e.getMessage());
         }
 }
  
  public int getRowCount() {
      return tableData.size();
  }
 
   public int getColumnCount() {
          return columnNames.length; 
   }
                           
   public String getColumnName(int index) {
           return columnNames[index];
   }
                           
   public Object getValueAt(int row, int column) 
   {
      Vector rowVector = (Vector)tableData.elementAt(row);
      return (String)rowVector.elementAt(column);
   }
                     
    public void addRow(Vector rowData) {
          tableData.addElement(rowData);
     fireTableRowsInserted(tableData.size(), tableData.size() );
    }
                          
    public void removeRow(int row)
    {
      data.removeElementAt(row);
      fireTableDataChanged();
    }
                           
    public boolean isCellEditable(int row, int column) {
         return true;
    }
     
    public void setValueAt(Object o, int row, int column) 
    {
       // change a field of hi
       HolidayItem hi = (HolidayItem)data.elementAt(row);
       switch (column) {
        case 4:
              hi.hlday_code = (String)o;
               break;
         default:
 System.out.println("Bad column when editing data: "+column);
            break;
       }
      fireTableCellUpdated(row, column);
    }
}

[Renee Zhang]

Move con.close(); outside while loop at first. You can't close the connection before you get all the data.