Oracle JDBC Connection Test

Here we are starting our first JDBC program after installing Oracle 10g XE in our local machine. Connecting Oracle database through java is little bit interesting. We need a medium to connect Oracle throug java for that java has provided four types of drivers in API. JDBC having four types of drivers to connect Databases.Here we are using Type 1 driver (JDBC-ODBC Bridge Driver) "sun.jdbc.odbc.jdbcOdbcDriver". This is common driver to connect all databases.
Oracle database through java is little bit interesting. We need a medium to connect Oracle throug java for that java has provided four

 In Our program we are using DriverManager class to get the Connection for Oracle database. For this we use getConnection( ) method. This is a Static method.
This driver is dependent on native libraries of the Operating System. Not recommended for all projects like applets and server client projects.

Installing Oracle Database 10g Express Edition

Oracle has introduced several features in 10g XE. These are very user friendly and very secure. The main features are: Application Development, Availability, Business Intelligence, Clustering, Content Management, Database Overall, Database Security,Grid Computing, Grid Management, Information Integration, Location Services, Performance and Scalability, Server Manageability, Windows, Workspace Manage.

Let's start installing Oracle 10g XE into our local machines.

Double click on OracleXE exe file to install Oracle

Oracle ODBC Driver Configuration in Windows XP

To start doing JDBC programs in your local machines you should configure the following softwares:

1. Install Java 1.5 or higher version
2. Install Oracle XE (recommended)
3. Set up classpaths for Java and Oracle and ojdbc14 jar file

These three are common things need to be installed in your system to learn JDBC. Make sure Java and Oracle is working fine with out any problems. To run JDBC programs we should configure a Driver Connection to Java and Oracle to interact each other. For that we have Drivers like a bridge for these two. The Oracle ODBC Driver provides access to Oracle databases for applications written using the ODBC interface.

Setting up an Oracle ODBC Driver and Data Source