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 learn java.");
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.