Interested to Buy Any Domain ? << Click Here >> for more details...
steps to connect with Oracle Databse using TYPE-2 Jdbc driver.
- 3 Answers
- 11909 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is encapsulation in java?
What are the differences between heap and stack memory in java?
what are upcasting and downcasting?
What do you understand by the term singleton?
Explain which of the following methods releases the lock when yield(), join(),sleep(),wait(),notify(), notifyall() methods are executed?
How to convert String into primitive datatype.
What is meant by class loader and how many types are there?
Difference between static and dynamic class loading.
how can i take the inputs from users in java program?
Can we access instance variables within static methods ?
How do you override a method in java?
Given a singly linked list, how will you print out its contents in the reverse order? Can you do it with consuming any extra space?
0 Answers Akamai Technologies,
Core Java 
