Find this at http://www.npac.syr.edu/users/gcf/jdbcjan98/

Overview of JDBC and its use with CORBA or Java RMI

Given by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal) at CPS616 Technologies of Information Age on Spring 1998. Foils prepared 4 Feb 98

JDBC provides a set of classes for Java with a standard SQL database access interface.
  • Goal is uniform access to a wide range of relational databases
Provides an API for database "drivers" to make actual connections and transactions to database products.
  • includes JDBC-ODBC bridge to standard ODBC drivers, a common interface for relational databases from C
JDBC is "low-level" interface, calling SQL commands directly but is meant to be a base for higher-level interfaces.
This talk has three sections:
  • Using JDBC in Java, with a 2 tier example
  • JDBC drivers
  • 3 tier examples


Table of Contents for Overview of JDBC and its use with CORBA or Java RMI


001 JDBC  Java Database Connectivity
002 JDBC Main Features
003 Traditional Web/RDBMS access Compared to using Java
004 JDBC Software Architecture
005 Driver Access Architecture
006 JDBC API is Package java.sql
007 Driver Manager
008 Driver class creates Connection
009 SQL Statements
010 Statement Class
011 ResultSet class
012 Data from ResultSets
013 PreparedStatement class
014 CallableStatement class
015 Generalized example of getting results
016 A typical JDBC API usage sequence
017 Simple JDBC 2 Tier Applet - An Example
018 JDBC 2 Tier Applet
019 JDBC 2 Tier Applet
020 More Details on JDBC Driver Architectures
021 Driver Classification- I
022 Driver Classification  - II
023 JDBC Driver API - I
024 JDBC Driver API - II
025 JDBC Driver API - III
026 List of vendors
027 Remote Database Access Current Options
028 mSQl jdbc driver for mSQl database
029 Weblogic jdbcKona driver for Oracle
030 3 tier Remote JDBC driver Architecture
031 PPT Slide
032 Remote jdbc Driver  Client-side Description
033 Remote jdbc Driver  Server-side Description - I
034 Remote jdbc Driver  Server-side Description - II
035 JDBC 2+ Tier Architecture
036 Advantages of JDBC 2+ Tier Architecture
037 Java WebServer with Servlets
038 Programming Java Servlets
039 JDBC 3 Tier Servlet Example
040 JDBC Servlet Example (contd.)
041 JDBC Servlet Example (contd.)
042 JDBC Servlet Example (contd.)
043 JDBC 3 Tier Example using RMI
044 The RMI Example
045 3-Tier JDBC Example Using CORBA
046 CORBA IDL Structure
047 Mapping CORBA IDL to Java - I
048 Mapping CORBA IDL To Java - II
049 An IDL Example - hello.idl
050 Compile An IDL file
051 Example Server - Hello
052 Example Server I - HelloServant
053 Methods in Server Class
054 Example Server II - HelloServer
055 Example Application Client
056 Example Client - Hello
057 JDBC Example using CORBA
058 Using JDBC-ODBC Bridge


© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Sun Nov 29 1998