some problem in JDBC operation

hi,

i have this problem i am new to JDBC and i wrote a sample program to try out , when i complied the program it compiled fine but when i ran the program

java progname

i got a class not defined error , below is my sample code

please can anybody tell me where the problem is

import java.sql.*;

public class JDBCTry

{

public static void main(String arg[])

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection DBconn = DriverManager.getConnection("jdbc:odbc:technical_library");

System.out.println("connected");

Statement st = DBconn.createStatement();

ResultSet rs = st.executeQuery("Select lastname,firstname from authors");

while(rs.next())

{

System.out.println(rs.getString("lastname"));

System.out.println(rs.getString("firsttname"));

System.out.println("\n");

}

}

catch(Exception e)

{

System.out.println(e);

}

}

}

regards

raghav

[1052 byte] By [raghav21] at [2007-9-26 2:01:46]