Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

steps to connect with Oracle Databse using TYPE-2 Jdbc driver.

Answer Posted / nigel

[NOTE: This description is for oracle 10g]

Step 1: Set the classpath to the oracle driver in your
oracle_home directory

eg:CLASSPATH=C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar;

Step 2: USE -- Class.forName("oracle.jdbc.OracleDriver");

Step 3: USE jdbc url =
("jdbc:oracle:oci:USERNAME/PASSWORD@localhost:1521:XE");

In My Case it was : USERNAME=hr PASSWORD=hr

The rest of the code is similar to jdbc:odbc connection.
just compile and run the code.....:D

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an i/o filter?

1819


How can we make a class virtual?

1114


What happens if constructor is private?

1029


Is there any limitation of using inheritance?

1089


What is numeric data type?

989


What is an argument java?

973


What is a vararg?

1036


How do you convert an int to a double in java?

1062


When should we create our own custom exception classes?

1016


What is general methodology?

1038


What does it mean to flush a file?

1066


What is the relationship difference the canvas class and the graphics class?

1060


What is the difference between stringbuffer and stringbuilder class?

1106


Does java set allow duplicates?

1084


Why synchronization is important?

1027