Interested to Buy Any Domain ? << Click Here >> for more details...
steps to connect with Oracle Databse using TYPE-2 Jdbc driver.
- 3 Answers
- 11936 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 difference in between cpp and java? Can u explain in detail?
Why we used vector class?
What is string in java with example?
What is r in java?
what is a transient variable?
what are the different non-access specifiers in java?
What is mysql driver class name?
What is java jit compilers?
What is ternary operator in java?
What does file separator do in java?
Difference between static binding and dynamic binding?
What is advantage of java?
Core Java 
