What does JDC mean in DATABASES

Using JDBC, applications can access virtually any type of tabular data sources such as Oracle, SQL Server, flat files, etc. that use industry-standard SQL and X/Open CLI query languages. Additionally, JDBC makes it easier to write database-independent code which adds scalability and portability for your applications.

The JDBC API uses a driver manager and database-specific drivers to provide transparent connectivity to heterogeneous databases. The driver manager accepts requests for connections from client programs like Java application or applets and passes the request to the appropriate driver based on its configuration info. After establishing a connection with the designated data source, the driver manager passes back a connection object handle to the requesting program which can then invoke various methods to interact with the underlying database.

A Type 2 Driver implements client-side emulation of server side functionality by making ODBC calls directly to the target DBMS or third party middleware product's APIs on behalf of users or applications. This allows Type 2 drivers to access databases hosted by different platforms (e.g., Windows, Solaris).

A Type 4 Driver is pure Java code that translates all calls into vendor specific native calls so that no external libraries are necessary for execution; thus allowing for platform independent access via Java's portability features instead of relying on platform-dependent native libraries such as ODBC or OLEDB drivers used in Type 2 implementations.

To create an application using JDBC with an Oracle Database Server as its back end, you need: 1) Oracle server installed in your local machine2) An Oracle account with all privileges granted 3) Install Oracle's jdbc thin driver 4) Set up your class path correctly 5) An IDE configured correctly 6) Appropriate permissions 7) Write Java classes invoking APIs provided by the jdbc thin driver8 ) Run tested program9 ) Debug errors if encountered 10)Test sample data