Thread: problem in Derby embedded database connection

Hello Java forum members !

Firstly please forgive my ignorance , I am beginner in java database programming.
I cannot make connection to Embedded derby database. This is what I did

1)created derby database with one table using netbeans 7.1.2. And inserted some data in that table via sql command

Now I want to read data from this database's table from a java class but I am getting this message when I run

Errorjava.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver

here is my code of the class

 
 
package mypackage;
 
import java.sql.*;
 
 
 
public class DbConnection {
 
    Connection con;
    Statement st;
    ResultSet rs;
 
    public DbConnection() {
        connect();
 
    }
    public void connect() {
        try{
 
            String driver = "jdbc:derby:fida;user=scott;password=tiger";
            Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
 
 
            con= DriverManager.getConnection(driver);
            st=con.createStatement();
            String sql = "select * from APP.STUDENT";
            rs = st.executeQuery(sql);
            while(rs.next())
            {
                System.out.println(rs.getInt("ID"));
                System.out.println(rs.getString("name"));
                System.out.println(rs.getString("fname"));
 
            }
 
        }catch(Exception ex){
            System.out.println("Error"+ex);
        }
 
 
    }
    public static void main (String args[]){
        new DbConnection();
    }
 
}

Please help me out , and forgive my ignorance.

Hi Norm ! Thank you for the reply , I didn't include the jar file. Now problem is solved . Can you please send me links of good sources of learning material on jdbc and also on derby. I am newbie although I have strong java OOP concepts. I want to learn database programming in java.

Forgot to mention I also know SQL.

Please help .

hi Norm,
how are you doing? i found another problem hopefully will solve it, i am trying to connect embedded database but can't.
the error i get is "java.sql.SQLSyntaxErrorException: 'DROP TABLE' cannot be performed on 'APP.TABEL1' because it does not exist.
and i have created this table in database.
here is my code

 
package db;
 
import java.sql.*;
public class Derby {
    public static void main(String[] args) {
        Connection con = null;
        Statement st = null;
 
        String url = "jdbc:derby:javaDB";
 
        try
        {
 
            con = DriverManager.getConnection(url);
            st = con.createStatement();
            st.executeUpdate("drop table app.tabel1");
        }
        catch(Exception e)
        {
            System.out.println(e);
        }   
    }
}

Thanks

its okay dear,
and thanks for your response