jdbc problem

[jain vaibhav]

hello
i m connecting my java program with oracle 10 g. But it is giving error Driver not found..Please help me..
this is my code...i m new to jdbc...

import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Connect

{

	public static void main(String args[]) {
		System.out.println("Hello");
		System.out.println("Welcome to the world of java");
		System.out.println("Lets [surl='http://www.LearnNowJava.com' class='scratch' title='Hot Dog! LearnNowJava is keen on JavaRanch!']learn java[/surl].");
		String host = "10.248.11.67";
		String port = "1521";
		String dbName = "mydb";

		String url = "jdbc:oracle:thin:@" + host + ":" + port + ":" + dbName;
		Connection con = null;
		Statement stmt = null;
		ResultSet result = null;
		String query;

		try {
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
			} catch (Exception e) {
				System.out.println("driver not found " + e.getMessage());
			}

			con = DriverManager.getConnection(url, "hello", "helloo");
			stmt = con.createStatement();
			query = "create table emp1(name varchar(20), id int)";
			stmt.executeUpdate(query);
			query = "insert into emp1 values('khan', 17601)";
			stmt.executeUpdate(query);
			query = "insert into emp1 values('shahrukh', 17602)";
			stmt.executeUpdate(query);
			query = "insert into emp1 values('rahul', 786)";
			stmt.executeUpdate(query);
			query = "select * from emp1";
			result = stmt.executeQuery(query);
			while (result.next())
			{
				String name = result.getString("name");
				String ID = result.getString("id");
				int id = Integer.parseInt(ID);
				System.out.print(name + "    ");
				System.out.println(id);
			}
		}
		catch (Exception e)
		{
			System.out.println("SQLException caught: " + e.getMessage());
		}
		finally {
			try {
				if (con != null)
					con.close();
			}
			catch (SQLException e) {
			}
		}
	}
}

[Christophe Verré]

The next time you post some code, please UseCodeTags to make it more readable.

[Christophe Verré]

Where did you put the JDBC driver ? Is it in your CLASSPATH ? This FAQ may help you.

[jain vaibhav]

NO I didnt put in class path...should i do so?from where i can find the driver?

[Christophe Verré]

should i do so?

Yes, otherwise it's never going to work.

from where i can find the driver?

If you installed Oracle, the driver should be somewhere in the installation path (like jdbc\lib). Otherwise, you can download it.

[jain vaibhav]

Christophe Verré wrote:

should i do so?

Yes, otherwise it's never going to work.

ok thanks

from where i can find the driver?

If you installed Oracle, the driver should be somewhere in the installation path (like jdbc\lib). Otherwise, you can download it.