steps to connect with Oracle Databse using TYPE-2 Jdbc driver.
Answer Posted / 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 |
Post New Answer View All Answers
What is cr keyboard?
What is the full meaning of java?
What is linked hashmap and its features?
What is the use of default method in interface in java? Explain
What is the use of put method?
What are parsing rules?
Is double bigger than float?
Can size_t be negative?
Can a class have multiple superclasses?
Why is multithreading important?
Why is the main method declared static?
What is a java predicate?
How java uses the string and stringbuffer classes?
What is return data type?
What are the main uses of this keyword?