steps to connect with Oracle Databse using TYPE-2 Jdbc driver.
- 3 Answers
- 11355 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 |
how to open and edit XML file in Weblogic???
Is boolean a wrapper class in java?
How many threads can I run java?
When do you get classcastexception?
Can we execute a program without main() method?
What does a void function return?
In what circumstances, compiler will supply a default constructor for a class?
What is the relationship between a method?s throws clause and the exceptions that can be thrown during the method?s execution?
What is the symbol for line break?
Can we override constructors in java?
What is the use of an interface?
What is the multi-catch block in java?
Core Java 
