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 are the restrictions imposed by a Security Manager on Applets?.
Give any two differences between C++ and java.
What are the limitations of procedural programming approach?
What is final keyword?
What is boolean false?
Can a list be null in java?
What is an object in java and how is it created?
What is the difference between a local variable and an instance variable?
Explain about the select method with an example?
how to write a program for sending mails between client and server
What is get () in java?
What is variable and example?
Can a static block throw exception?
What do you mean by boolean?
Explain the difference between serializable and externalizable in java?