Summary of November 15 Web-Walkers meeting

Date: Tue, 10 Dec 1996 08:41:07 -0500
From: Judy Hallman <hallman@gibbs.oit.unc.edu>
To: web-walkers@unc.edu
Cc: Pratik Patel <prpatel@bme.unc.edu>
Subject: Summary of November 15 Web-Walkers meeting

To Web-Walkers list:

Summary of November 15 Web-Walkers meeting on Developing Java Applications and Java Database Connectivity, by Pratik Patel (http://sunsite.unc.edu/prpatel/)

Next meeting

The next Web-Walkers meeting will be Wednesday, December 18, 3:00 pm, 209 Manning

Kathy Thomas and Bob Henshaw will describe and demonstrate some of the tools and templates being used in the UNC-CH Simple Start Program (http://www.unc.edu/courses/ssp/), a program designed to facilitate the instructional use of Internet technologies.

[We had planned to have a presentation on Intranets, but scheduling did not work out for the December meeting.]

Developing Java Applications and Java Database Connectivity

Pratik talked from http://sunsite.unc.edu/prpatel/presentation/ and http://sunsite.unc.edu/prpatel/jdbc/

From the page http://sunsite.unc.edu/prpatel/presentation/, Pratik pointed out some of the common misconceptions about Java.

Then, from the pages starting at http://sunsite.unc.edu/prpatel/jdbc/, he talked about Java DataBase Connectivity (JDBC) -- why it is needed, who is developing it, and what it is.

JDBC is an API for using low level JDBC drivers. It is based on the X/Open SQL Call Level Interface ( CLI ) that defines how client/server interactions are implemented for databased systems. A programmer writes one database interface, in JDBC, and the program can access any SQL data source -- without recoding.

JDBC uses a three-tiered approach:

(1) database (DBMS)
(2) application server (middle tier)
(3) client

The application server handles concurrency problems, locking data elements, and updates to clients, thus allowing a "stated" connection.

The drivers may be, but do not have to be, pre-installed. Java will bring down the drivers it needs.

JDBC uses an extended URL of the form:

  jdbc:driver://host port catalog
                     [this part depends on the driver]

for example

jdbc:odbc:ODBCDATASOURCE

Part way through the presentation, the network connection to our building was lost. However, there were several attendees who had questions and Pratik addressed them while we waited for the network to come back up.

Many thanks to Pratik for his presentation and to all for their patience.

Attendees

Deb Aikat, JOMC, daikat@email.unc.edu
Jay Aikat, Journalism, jay_aikat@unc.edu
Scott Beland, CDLHC, beland@cs.unc.edu
Raymond Bokenkamp, SOWO, rpbokenk@email.unc.edu
Andy Broughton, SOWO, abrought@email.unc.edu
Kirstin Chafin, SILS, chafk@ils.unc.edu
Joe Conder, OIS, jconder@med.unc.edu
Mike Conway, AIS, mcc.admin@mhs.unc.edu
Kathleen Crook, Sheps Ctr. for HSR, kathleen_crook@unc.edu
Bert Dempsey, SILS, bert@ils.unc.edu
Sheila Denn, SILS, denns@ils.unc.edu
Frank DiMauro, UNC Hosps., fadim@med.unc.edu
Nancy Doyle, AIS/Registrar, nmd@email.adp.unc.edu
Elizabeth A. Evans, Carolina Pop Ctr, evans@unc.edu
Chuck Fennimore, SOWO, cjfennim@email.unc.edu
Judy Hallman, ATN, judy_hallman@unc.edu
Teresa Heffron, OIS, heffrom@med.unc.edu
Terry Hill, JOMC, terry_hill@unc.edu
Freb Hunt, Alcohol Studies, freb@unc.edu
Ken Langley, OIT, langley@med.unc.edu
Duckjae Kim, Information Science, kimd@ils.unc.edu
Judd Knott, ATN, knott@unc.edu
Darrell Mills, AIS, smdmm@email.adp.unc.edu
Susie Moffat, AIS, pbm.admin@mhs.unc.edu
Mary Overby, ATN, mary_overby@unc.edu
Jeff Sacks, AHEC, jeff.ahec@mhs.unc.edu
Sandra Shirley, S&P, sshirley@email.unc.edu
Charlie Speight, SunSITE, speight@sunsite.unc.edu
Bob Stepno, JOMC, rbstepno@email.unc.edu
Trish Towne, OIS, trish@med.unc.edu
Bill Ussler, Geology, ussler@marine.unc.edu
Loren Watterson, CPC, loren_watterson@unc.edu
Jeanne Yang, CPC, jeanne.cpc@mhs.unc.edu

Judy Hallman (judy_hallman@unc.edu, http://www.unc.edu/~hallman/) Campus-Wide Information Systems Manager, UNC-Chapel Hill