Foilset Search Full Index for Basic foilset

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

There are two types of foils -- html and image which are each available in basic and JavaScript enabled "focused" style
(basic:)(focus style:) Denote Foils where Image Critical
(basic:)(focus style:) Denote Foils where Image has important information
(basic:)(focus style:) Denote Foils where HTML is sufficient
denotes presence of Additional linked information which is greyed out if missing
1 JDBC Java Database Connectivity
Link to Sun web page on JDBC 2 JDBC Main Features
3 Traditional Web/RDBMS access Compared to using Java
4 JDBC Software Architecture
5 Driver Access Architecture
Suns API for JDBC 6 JDBC API is Package java.sql
7 Driver Manager
8 Driver class creates Connection
9 SQL Statements
10 Statement Class
11 ResultSet class
12 Data from ResultSets
13 PreparedStatement class
14 CallableStatement class
15 Generalized example of getting results
16 A typical JDBC API usage sequence
17 Simple JDBC 2 Tier Applet - An Example
18 JDBC 2 Tier Applet
2 tier person database example for Foil 19 19 JDBC 2 Tier Applet
20 More Details on JDBC Driver Architectures
21 Driver Classification- I
22 Driver Classification - II
23 JDBC Driver API - I
24 JDBC Driver API - II
25 JDBC Driver API - III
26 List of vendors
27 Remote Database Access Current Options
28 mSQl jdbc driver for mSQl database
29 Weblogic jdbcKona driver for Oracle
30 3 tier Remote JDBC driver Architecture
31 PPT Slide
32 Remote jdbc Driver Client-side Description
33 Remote jdbc Driver Server-side Description - I
34 Remote jdbc Driver Server-side Description - II
35 JDBC 2+ Tier Architecture
36 Advantages of JDBC 2+ Tier Architecture
37 Java WebServer with Servlets
38 Programming Java Servlets
39 JDBC 3 Tier Servlet Example
40 JDBC Servlet Example (contd.)
41 JDBC Servlet Example (contd.)
Suns servlet database example for Foil 42 42 JDBC Servlet Example (contd.)
43 JDBC 3 Tier Example using RMI
3 tier person database example using RMI for Foil 44 44 The RMI Example
45 3-Tier JDBC Example Using CORBA
46 CORBA IDL Structure
47 Mapping CORBA IDL to Java - I
48 Mapping CORBA IDL To Java - II
49 An IDL Example - hello.idl
50 Compile An IDL file
51 Example Server - Hello
52 Example Server I - HelloServant
53 Methods in Server Class
54 Example Server II - HelloServer
55 Example Application Client
56 Example Client - Hello
3 tier person database example using CORBA IDL for Foil 57 57 JDBC Example using CORBA
58 Using JDBC-ODBC Bridge
Full WebWisdom URL and this Foilset Search
This contains all WebWisdom links preceded by those referenced in this foilset
© 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