Full HTML for
Given by Konrad Olszewski,Gang Cheng at Rome Lab Quarterly Review for CIV on June 28 96. Foils prepared 23 February 97
Outside Index
Summary of Material
| This covers how one can use Java links to Databases in CIV and other applications |
| It covers use and not the base JDBC/LiveWire/OWS/WebLogic Technology |
Denote Foils where Image Critical
Denote Foils where HTML is sufficient
Java/Database Connectivity
Motivation
Traditional Web/RDBMS Configuration
What's new with Java ?
JDBC - main features
JDBC scheme
Two tier vs. three tier
Oracle Web Server
Principle of operation
WebLogic
LiveWire
Summary
Outside Index
Summary of Material
HTML version of Basic Foils prepared 23 February 97 
Full HTML Index
| Konrad Olszewski |
| Gang Cheng |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| Java - interactive Web computing, portable programming language, persistent client-server networking |
| RDBMS - information management, search backend, data processing |
| Java + RDBMS - fully integrated client-server application on WWW |
HTML version of Basic Foils prepared 23 February 97 
Full HTML Index
| WWW client |
| HTTP server |
| traditionally using CGI for HTTP server to access databases and query results were displayed as HTML pages on Web browsers |
| the requests and responses were transmitted using HTTP protocol; no session notion; database transaction logic is not perserved. |
| CGI script |
| HTTP |
| protocol |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| WWW client |
| HTTP server |
| integrated |
| DB client |
| applet |
| standalone application |
| server |
| Java offers the following advantages: |
| puts application logic into the client side |
| session protocols (overcoming the limitations of HTTP ) |
| interactive access to database objects |
| direct access |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| Portable Java API for connecting to RDBMS and executing SQL statements |
| designed after ODBC (but with Java-specific features) |
| dependent on database drivers provided by vendors |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| JDBC-ODBC |
| Driver |
| JDBC API |
| JDBC Driver API |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| Client application |
| socket |
| connection |
| Client application |
| Server application |
| JDBC access |
| JDBC access |
| client side |
| server side |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| tightly integrated with Oracle DBMS |
| executes Java code on server side |
| communication with database based on PL/SQL wrappers |
| designed to work with dynamically created HTML |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| Web client |
| URL |
| Oracle |
| Web Server |
| HTML |
| WRB is a Web Request Broker |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| Full environment to develop Java/database applications |
| works with Oracle, Sybase and Microsoft SQL Server |
| Database access based on JDBC standard |
| Libraries to create three-tier applications |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| provided by Netscape FastTrack server |
| using JavaScript to perform database operations on the server side |
| database connection and SQL queries can be embedded in Javascript code in HTML pages (Javascript can interact with Java applets in future versions of Javascript) |
| application server is part of HTTP server |
| currently working with Oracle, Sybase, Informix, ODBC |
HTML version of Basic Foils prepared 23 February 97
Full HTML Index
| The JDBC will establish general-purpose standard in Java/DB connectivity in cooperation with other companies (WebLogic) |
| OWS is a good solution for applications tightly related to Oracle and based on PL/SQL |
| LiveWire is suitable for easy access to DB from HTML pages |