Before we dive into different style of database application architecture based on different combination of J2EE component, let us first understand few critical components. Understanding of these critical components will help us in understanding these styles in much better way.

First in line is Understanding JDBC (Java Database Connectivity)

In Oracle SQL*Net is the default method of connecting with the database. It allow easy access to the database from an Oracle client application. We don’t need to worry about anything.

But when accessing it from Java Program we cannot use SQL*Net as Java does not support it.This is where JDBC comes in.

The Java Database Connectivity (JDBC) API comprises of a library of java classes included with JDK. It is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases – SQL databases and other tabular data sources, such as spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access.

The JDBC API makes it possible to do three things:

• Establish a connection with a database or access any tabular data source
• Send SQL statements
• Process the results

To be continue next blog…