type 4 driver

[Dayanand]

package com.lara;

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

public class Mgr
{

public static void main(String[] args)
{

try
{

Class.forName("Oracle.jdbc.driver.OracleDriver");

}
catch (ClassNotFoundException e)
{

e.printStackTrace();

}
Connection con = null;
Statement stmt = null;
try
{

con = DriverManager.getConnection("jdbc:Oracle:thin:@loc alhost:1521:XE","system","mahesh");

stmt = con.createStatement();
stmt.execute("insert into persons values('abc','xyz',22)");
System.out.println("done");

}
catch (SQLException e)
{

e.printStackTrace();

}
finally
{

}

System.out.println("done");
}

}
output:-

java.lang.ClassNotFoundException: Oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.lara.Mgr.main(Mgr.java:14)
java.sql.SQLException: No suitable driver found for jdbc:Oracle:thin:@localhost:1521:XE
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.lara.Mgr.main(Mgr.java:24)
done


i got an run time execption in the below statemnet
con = DriverManager.getConnection("jdbc:Oracle:thin:@loc alhost:1521:XE","system","mahesh");

what is the mistake i have done.?

[Dark]

Is the space supposed to be there in between jdbc:Oracle:thin:@loc alhost:1521:XE

[Tolls]

Oracle.jdbc.driver.OracleDriver
Java is case sensitive, that first Oracle should be oracle.

Presuming you have the odbc jar file on your runtime classpath.

[Dayanand]

Oracle.jdbc.driver.OracleDriver
Java is case sensitive, that first Oracle should be oracle.

Presuming you have the odbc jar file on your runtime classpath.

oh i got it.!!!!!!!!
thanks a lot.........