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.

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / shankar

we can connect with oracle DB using Type-2(partial native
and partial Java)

use driver :
oracle.jdbc.driver.OracleDriver

use URL:
jdbc:oracle:ocis:@hostname:port no:global source name

Dependig on port name and localhost URL will look like
(jdbc:oracle:ocis:@localhost:1521:XE)
XE is global source name Oracle 10g

Is This Answer Correct ?    5 Yes 2 No

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

Answer / s .p priya

through ms accessi think so but as most of the type 2
drivers r system dependent we cannot connect other
database or it is possible only if it oracle os

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More Core Java Interview Questions

can two class in a code be public??if yes then how??

2 Answers  


What is generic type?

0 Answers  


How do you clear an arraylist in java?

0 Answers  


what is the use of thread?Justify it by project point of view

7 Answers  


What is the difference between inheritance and encapsulation?

0 Answers  


Why call by value prevents parameter value change?

0 Answers  


Java support what type of parameter passing ?

7 Answers   Wipro,


What is basic concept of static in java ?

1 Answers   iGate,


tell me some common

2 Answers   TCS,


There are 2 methods in a class. Both have the same method signature except for return types. Is this overloading or overriding or what is it?

9 Answers   KPIT,


Can a class have multiple constructors?

0 Answers  


What is type safety in java?

0 Answers  


Categories