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 cr keyboard?

1344


What is the full meaning of java?

1097


What is linked hashmap and its features?

1075


What is the use of default method in interface in java? Explain

1048


What is the use of put method?

1002


What are parsing rules?

1046


Is double bigger than float?

1040


Can size_t be negative?

1247


Can a class have multiple superclasses?

1245


Why is multithreading important?

995


Why is the main method declared static?

1181


What is a java predicate?

1018


How java uses the string and stringbuffer classes?

1131


What is return data type?

1060


What are the main uses of this keyword?

1121