Oracle and Java Connectivity!!!

[rameshraj]

How to connect Oracle with JAVA.will u Plz explain me.

[r035198x]

How to connect Oracle with JAVA.will u Plz explain me.

Check the directory
oraclexe\app\oracle\product\10.2.0\server\jdbc\lib
or something like it and see if you have any of the following zip files
ojdbc14
or
ojdbc14_g
If you don't have them, then go the oracle site and download them (You just need one of them).
Once you have them, add their path to your classpath and then connect to the database using jdbc

[praveen2gupta]

How to connect Oracle with JAVA.will u Plz explain me.

Hi

There are many ways to connect to database. For begainers you should use the Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); driver.

Now go to control panel open odbc, create a sytem DSN, new write a name Learning and select the oracle driver.

after that use the Connection class
String url = "jdbc:odbc:Learning";//Learning is DSN Name
java.sql.Connection c = DriverManager.getConnection(url,"Learning", "Learning");

For details read following article
http://www.javacoffeebreak.com/articles/jdbc/