problem connecting to postgres 8.2.3

[Anand Shrivastava]

With the following code, i am getting error of class not found exception:

package screen;
import javax.swing.*;
import java.sql.*;
 
/**
 *
 * @author Lenovo
 */
 
public class connect {
   public String uname,pwd;
   public char dname;
   connect(char dbase,String username,String password)
   { dname=dbase;
     uname=username;
     pwd=password;
   }
    /** Creates a new instance of connect */
    public Connection connected(){
        Connection conn;
        String dstr=new String();
        String db=new String();
        switch(dname) {
            case 'o':dstr="oracle.jdbc.driver.OracleDriver";
            db="jdbc:oracle:oci:@xe";
            break;
            case 'p':dstr="org.postgresql.Driver";
            db="jdbc:postgresql://localhost:5432/postgres";
            break;
               }
        
        try {
            Class.forName(dstr);
        } catch (Exception E) {
            System.err.println("Unable to load driver");
            E.printStackTrace();
        }
        try {
            
             conn = DriverManager.getConnection(db,uname,pwd);
            System.out.println("Connected to database");
            return conn;
        } catch (SQLException E) {
            System.out.println("SQLException: " + E.getMessage());
            System.out.println("SQLState: "+E.getSQLState());
            System.out.println("VenderError: "+ E.getErrorCode());
        }
        return null;
    }
    ResultSet jset(String query) {
        ResultSet rset;
        try {
            System.out.println(dname);
            Statement smnt = connected().createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
            rset = smnt.executeQuery(query);
            return (rset);
            
            
        } catch (Exception E) {System.out.println(E.getMessage());
        return (null);}
    }
     // public static void main(String args[]) {connect com;}
    
}

[Ulf Dittmer]

Welcome to JavaRanch.

Which class is it that is not found? The error message should tell you that. Is the missing class in your classpath?

[Anand Shrivastava]

i have solved the issue. it was classpath trouble. thanks.