Problem with connecting with Oracle 9i

Hello..I have oracle 9i on my comp...

the problem is that i cannot connect the jdbc driver for my local host..i m pretty new to this concept of database managment.....

I cannot resolve the porper URL for my comp,bcz either

Exception in thread "main" java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at customer.main(customer.java:7)

crops up...when using the code....jdbc:odbc:DATABASE_NAME

and i cannot connect with me own comp using thin driver.problem wih the URL again...can u guys plz help me...

[661 byte] By [reedipa] at [2007-11-27 6:56:37]
# 1
You either are not loading the driver or your connection string syntax is wrong.
jschella at 2007-7-12 18:33:37 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
java.sql.SQLException: No suitable driver indicates either the connection url is incorrect or the driver jar is not in the classpath.
dvohra09a at 2007-7-12 18:33:37 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

> java.sql.SQLException: No suitable driver

> indicates either the connection url is incorrect or

> the driver jar is not in the classpath.

The second part is wrong. If the loaded class name is correct then if the driver is not in the class path then one will get a class not found exception.

jschella at 2007-7-12 18:33:37 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...