For Windows users only
Pre-Requisites:
If you are using older version of JDK(1.2 or below). You need to set CLASSPATH for classes12.zip
C:\oracle\product\10.1.0\Db_1\jdbc\lib\classes12.zip
Step:1
Setting CLASSPATH
1. Right click the My Computer icon. In that click properties
2. You will see a window System Properties. In that window click Advanced
3. You will see a button Environment Variables. Click that button.
4. In the popup window you will see User variables for XXXXXX (your name) and System variable. Select the New button which is below the User variables for XXXXX.
5. You will see the window New User Variable. In Variable name type CLASSPATH and in Variable value type .;C:\oracle\product\10.1.0\Db_1\jdbc\lib\ojdbc14.jar
The first entry must be a period, which denotes the current directory. The second entry must be the directory for the ojdbc14.jar or classess12.zip (jdk 1.2 or below).
If CLASSPATH is not set correctly, you will get a NoClassDefFoundError error when you run a compile class.
NOTE
Be sure to use a version of the JDK that is compatible with the Oracle release you are using. If you use a new release of the JDK with an older release of Oracle’s drivers, you may encounter “access violation” errors when executing your programs.
Step 2
The PATH environment variable should already be set for JDK Step 3
JDK is already provided by Oracle itself(You can even use your own JDK). If you install Oracle10g It comes automatically. It lies in
C:\oracle\product\10.1.0\Db_1\jdk(I have installed oracle in C: in your case it might be D: or E: ….)
Setting PATH
1. Right click the My Computer icon. In that click properties
2. You will see a window System Properties. In that window click Advanced
3. You will see a button Environment Variables. Click that button.
4. In the popup window you will see User variables for XXXXXX (your name) and System variable. Select the New button which is below the User variables for XXXXX.
5. You will see the window New User Variable. In Variable name type PATH and in Variable value type
C:\oracle\product\10.1.0\Db_1\jdk\bin;
Click ok. You have finished setting PATH and CLASSPATH.
Testing your Connection
Oracle provides a sample program called JdbcCheckup.java that you can use to verify your JDBC configuration. This file may be in a zip file (demo.zip on the C:\oracle\product\10.1.0\Db_1\jdbc\demo.zip. After unzipping you will get C:\oracle\product\10.1.0\Db_1\jdbc\demo\samples\generic\. You will need to extract it before running the program. Go to the directory where the sample file is, then compile and execute the JdbcCheckup.iava class:
javac JdbcCheckup.java
Java JdbcCheckup
NOTE
Java commands are case sensitive. When you execute jdbcCheckup, you are prompted for usename, password, and connect string for a database. That connection Information will be used to attempt a connection; if successful, that attempt will return the following output:
Connecting to the database...Connecting…
connected.
Hello World.
Your JDBC Installation is correct.
If you don't receive feedback telling you that your Installation is correct, you need to check your configuration. Common problems include incorrectly set environment variables (PATH and CLASSPATH) and mismatched versions of database connection drivers. It you change the environment variable values, you need to shut down and restart the command windows for the changes to take effect.
If you are not able to find demo.zip then try the below programs.
Sample programs
Sample program: 1
ConnectOracle.java
connection=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
In the above line, username is “scott” and password is “tiger”.
Thin is the JDBC driver
1521 is the default port number which the connection is to be established and orcl is the database name.
Sample program: 2
ConnectOracle.java
Pre-Requisites:
- jdk1.6.0_11
- Oracle 10g
- ojdbc14.jar
If you are using older version of JDK(1.2 or below). You need to set CLASSPATH for classes12.zip
C:\oracle\product\10.1.0\Db_1\jdbc\lib\classes12.zip
Step:1
Setting CLASSPATH
1. Right click the My Computer icon. In that click properties
2. You will see a window System Properties. In that window click Advanced
3. You will see a button Environment Variables. Click that button.
4. In the popup window you will see User variables for XXXXXX (your name) and System variable. Select the New button which is below the User variables for XXXXX.
5. You will see the window New User Variable. In Variable name type CLASSPATH and in Variable value type .;C:\oracle\product\10.1.0\Db_1\jdbc\lib\ojdbc14.jar
The first entry must be a period, which denotes the current directory. The second entry must be the directory for the ojdbc14.jar or classess12.zip (jdk 1.2 or below).
If CLASSPATH is not set correctly, you will get a NoClassDefFoundError error when you run a compile class.
NOTE
Be sure to use a version of the JDK that is compatible with the Oracle release you are using. If you use a new release of the JDK with an older release of Oracle’s drivers, you may encounter “access violation” errors when executing your programs.
Step 2
The PATH environment variable should already be set for JDK Step 3
JDK is already provided by Oracle itself(You can even use your own JDK). If you install Oracle10g It comes automatically. It lies in
C:\oracle\product\10.1.0\Db_1\jdk(I have installed oracle in C: in your case it might be D: or E: ….)
Setting PATH
1. Right click the My Computer icon. In that click properties
2. You will see a window System Properties. In that window click Advanced
3. You will see a button Environment Variables. Click that button.
4. In the popup window you will see User variables for XXXXXX (your name) and System variable. Select the New button which is below the User variables for XXXXX.
5. You will see the window New User Variable. In Variable name type PATH and in Variable value type
C:\oracle\product\10.1.0\Db_1\jdk\bin;
Click ok. You have finished setting PATH and CLASSPATH.
Testing your Connection
Oracle provides a sample program called JdbcCheckup.java that you can use to verify your JDBC configuration. This file may be in a zip file (demo.zip on the C:\oracle\product\10.1.0\Db_1\jdbc\demo.zip. After unzipping you will get C:\oracle\product\10.1.0\Db_1\jdbc\demo\samples\generic\. You will need to extract it before running the program. Go to the directory where the sample file is, then compile and execute the JdbcCheckup.iava class:
javac JdbcCheckup.java
Java JdbcCheckup
NOTE
Java commands are case sensitive. When you execute jdbcCheckup, you are prompted for usename, password, and connect string for a database. That connection Information will be used to attempt a connection; if successful, that attempt will return the following output:
Connecting to the database...Connecting…
connected.
Hello World.
Your JDBC Installation is correct.
If you don't receive feedback telling you that your Installation is correct, you need to check your configuration. Common problems include incorrectly set environment variables (PATH and CLASSPATH) and mismatched versions of database connection drivers. It you change the environment variable values, you need to shut down and restart the command windows for the changes to take effect.
If you are not able to find demo.zip then try the below programs.
Sample programs
Sample program: 1
ConnectOracle.java
- /**
- * ConnectOracle.java
- */
- package com.fazle.connectoracle;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- /**
- * @author www.fazlerabbicse.blogspot.com
- *
- */
- public class ConnectOracle {
- public static void main(String[] args) {
- try {
- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
- System.out.println("Connecting to the database...");
- Connection connection = DriverManager.getConnection(
- "jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
- Statement statement = connection.createStatement();
- ResultSet resultset = statement.executeQuery("select 'Connected' from dual");
- resultset.next();
- String s = resultset.getString(1);
- System.out.println(s);
- statement.close();
- connection.close();
- } catch (Exception e) {
- System.out.println("The exception raised is:" + e);
- }
- }
- }
In the above line, username is “scott” and password is “tiger”.
Thin is the JDBC driver
1521 is the default port number which the connection is to be established and orcl is the database name.
Sample program: 2
ConnectOracle.java
- /**
- * ConnectOracle.java
- */
- package com.fazle.connectoracle;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.Statement;
- /**
- * @author www.fazlerabbicse.blogspot.com
- *
- */
- public class ConnectOracle {
- public static void main(String[] args) {
- try {
- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
- Connection connection = DriverManager.getConnection(
- "jdbc:oracle:thin:@localhost:1521:orcl", "scott", "t");
- Statement statement = connection.createStatement();
- ResultSet resultSet = statement
- .executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
- while (resultSet.next()) {
- System.out.println("EMPLOYEE NAME:"
- + resultSet.getString("EMPNAME"));
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
He (the narrator, Abu Hurairah) said: Then the person turned back and
went away. Allah's Messenger (may peace be upon him) said: Bring that
man back to me. They (the Companions of the Holy Prophet present there)
went to bring him back, but they did not find him. Upon this Allah's
Messenger (may peace be upon him) remarked: He was Gabriel. He came
to teach people their religion. 
