1 / 10

The Point on the Web Oracle Tools Today

The Point on the Web Oracle Tools Today. Eric Grancher IT/ASD-DB Eric.Grancher@cern.ch. Agenda of the presentation. Oracle Web Application Server PL/SQL cartridge PL/SQL by hand & Designer/2000 web generator Java and perl cartridges Forms cartridge Schema Restrictions Status

hetal
Download Presentation

The Point on the Web Oracle Tools Today

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Point on the Web Oracle Tools Today Eric GrancherIT/ASD-DB Eric.Grancher@cern.ch

  2. Agenda of the presentation • Oracle Web Application Server • PL/SQL cartridge • PL/SQL by hand & Designer/2000 web generator • Java and perl cartridges • Forms cartridge • Schema • Restrictions • Status • Advantages / drawbacks

  3. ORB Services Application Server Oracle Web Application Server • Network Computing Architecture • Three-tier architecture • Terminology • Client (browser, Java capable) • Web Application Server (ex web server) • Database server Client/Browser Database

  4. Application Server PL/SQL Cartridge • PL/SQL stored procedures produce HTML which is sent back to the browser • PL/SQL code can be • Typed by hand • Generated by designer/2000 v1.3.2 PL/SQL URL execute proc1; HTTP SQL*Net PL/SQL HTML HTML Client/Browser Database

  5. Application Server Java/perl Cartridge • Java classes run in a JVM on the application server, JDK 1.0.2 is supported • Perl scripts run on the application server perl JVM URL Perl scripts HTTP Java .class SQL*Net HTML Client/Browser Database

  6. Data ManagerPL/SQL engine Data ManagerPL/SQL engine User interface layer User interface layer Application Logic Application Logic Application Server Forms Cartridge • User-interface is moved to the browser SQL*Net GUI/text client Database Forms SQL*Net Forms 4.5 Client/Browser Database

  7. ActiveX, OCX, OLE, VBX MDI window When-Mouse-% triggers Web-forms Restrictions Unsupported Restricted • Display in console • USER_EXIT, ORA_FFI, HOST • Iconic button in GIF format Critical Area Developer/2000 2.0 • Fonts • Timers • Level of validation • Bubble help • Combo boxes • Menu accelerators http://oraweb01:9000/database/

  8. Status of Web Forms • Client/browser • No JDK 1.1.2 compatible browser • OWAS / Developer/2000 • 1.5 (NT) : not ready for production • 1.5.1 (Solaris) : not received • Need of a new architecture • Security ? • Plans • Production around Q1 1998 • Think about it from NOW on

  9. Advantages/drawbacks PL/SQL, perl, Java Web Forms Interaction level Character Pixel Bandwidth Very low-> inter/extra-net High ->intranet Transaction Manual (- Des/2k) Automatic Availability Now Q1 1998

  10. http://wwwinfo/~grancher/odf/http://oraweb01:9000/database/ Eric.Grancher@cern.ch

More Related