Interested to Buy Any Domain ? << Click Here >> for more details...
steps to connect with Oracle Databse using TYPE-2 Jdbc driver.
- 3 Answers
- 12051 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 the default modifier in Interface?
What is arraylist e in java?
Why you should not use singleton?
What is the difference between the Reader/Writer class hierarchy and the InputStream/OutputStream class hierarchy?
What is the functionality of the stub?
Explain the use of javap tool.
What is function and method in java?
What are the differences between path and classpath variables?
How do you override a method in java?
What is the return type of readLine() when end of a file is reached?
Explain about the select method with an example?
What is the output of the below java program?
Core Java 
