[news.eclipse.newcomer] Eclipse Deug ClassNotfoundException

[honchoyuk@xxxxxxxxxxx (Peter Hon)]

Dear all,

      I have a java which can Run Successfully when I just chose Run -> 
Java application. But When I run it in debug mode. It complains 
ClassNotFoundException in

Class.forName"com.microsoft.sqlserver.jdbc.SQLServerDriver");

It is strange to me why it can run successfully in Run Application. But 
when
debug line by line to the above line. The debug windows says 

ClassNotFoundException(Throwable).<init> (String,Throwable) line 217

Any setting in Eclipse that I need to add in order to debug it 
successfully?


Here is my code:

import java.*;
public class Connect{
    private java.sql.Connection  con = null;
    private final String url = "jdbc:sqlserver://";
    private final String serverName= "localhost";
    private final String portNumber = "1433";
    private final String databaseName= "pubs";
    private final String userName = "sa";
    private final String password = "sa";
    // Informs the driver to use server a side-cursor, 
    // which permits more than one active statement 
    // on a connection.
    private final String selectMethod = "cursor"; 
    
    // Constructor
    public Connect(){}
    
    private String getConnectionUrl(){
         return 
url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
    }
    
    private java.sql.Connection getConnection(){
         try{
              
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
              con = 
java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
              if(con!=null) System.out.println("Connection Successful!");
         }catch(Exception e){
              e.printStackTrace();
              System.out.println("Error Trace in getConnection() : " + 
e.getMessage());
        }
         return con;
     }

    /*
         Display the driver properties, database details 
    */ 

    public void displayDbProperties(){
         java.sql.DatabaseMetaData dm = null;
         java.sql.ResultSet rs = null;
         try{
              con= this.getConnection();
              if(con!=null){
                   dm = con.getMetaData();
                   System.out.println("Driver Information");
                   System.out.println("\tDriver Name: "+ 
dm.getDriverName());
                   System.out.println("\tDriver Version: "+ 
dm.getDriverVersion ());
                   System.out.println("\nDatabase Information ");
                   System.out.println("\tDatabase Name: "+ 
dm.getDatabaseProductName());
                   System.out.println("\tDatabase Version: "+ 
dm.getDatabaseProductVersion());
                   System.out.println("Avalilable Catalogs ");
                   rs = dm.getCatalogs();
                   while(rs.next()){
                        System.out.println("\tcatalog: "+ 
rs.getString(1));
                   } 
                   rs.close();
                   rs = null;
                   closeConnection();
              }else System.out.println("Error: No active Connection");
         }catch(Exception e){
              e.printStackTrace();
         }
         dm=null;
    }     
    
    private void closeConnection(){
         try{
              if(con!=null)
                   con.close();
              con=null;
         }catch(Exception e){
              e.printStackTrace();
         }
    }
    public static void main(String[] args) throws Exception
      {
         Connect myDbTest = new Connect();
         myDbTest.displayDbProperties();
         System.exit(0);
      }
}