Interested to Buy Any Domain ? << Click Here >> for more details...
steps to connect with Oracle Databse using TYPE-2 Jdbc driver.
- 3 Answers
- 12054 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 |
diffrence b\w println() and printf()
what is the logic inside any default constuctor?
What are the advantages of unicode?
What is java autoboxing?
What is factor r?
Is void a data type in java?
What is hash table in java?
Is the milky way in a void?
describe synchronization in respect to multithreading? : Java thread
What are the various access specifiers in java?
What is difference between float and double?
Explain a situation where finally block will not be executed?
Core Java 
