Material for Meetings. The table should have 2 columns: | date | Who and Where | I attached 6 files with minutes from previous meetings. After clicking at the date, we should receive full text. Please format in html. ================================= 06.29.1999 1. 4:30-5:40 YuPing, Jake, Roman 2. Jake received a copy of SoW Jake and YuPing received list of Deliverables and my notes from Oracle8i installation 3. Installed on mira Orcale 8i ver 8.1.5 Oracle Enterprise Manager (client + server) Intelligent Agent Oracle Application Server 4. What we need Oracle Server 8i Oracle Enterprise Manager (for Solaris and NT) WebDB Apache server 1.3.6 + Servlets JDeveloper ? not really Oracle Application Server ? No, lack of XML support XML Parser/renderer 5. Plan Roman : WebDB, Apache+ Servlets YuPing: XML parser (from Oracle and WWNT) DB contents design and prototype Jake: Oracle tuning + backup procedure 6. Meetings: Every Tuesday 4:30 ================================= 07.05.1999 1. 4:30-5:20 YuPing, Jake, Roman 2. YuPing downloaded and tested - XML parser (from Oracle) for Java input: XML output: DOM, SAX, XSL (SAX - Simple API for XML) XML generator still does not exist input: XML output: java source code - XML SQL Utility genertes XML from Tables loads XML into DB maps "elements" to "columns" 3. XSQL Servlets converts XML to DHTML (not downloaded and tested) 4. Request: add jake to "pet-ioe" send email to jake and yuping about apache+servlets 5. Architecture XML <-> Parser <-> Prog <-> DB YuPing: demo possible in 2 weeks ====================================== 07.13.1999 1. 4:30-5:20 YuPing, Jake, Roman 2. XML Workbench - Oracle 8i - WebDB - Orcale Application server + JWeb *** what JWeb is ? - Apache 1.3.6 + JServ 1.0 we could use Java Web Server - XML Parser for Java produses 3 interfaces: DOM source tree SAX XSL - XML SQL Utility (Unix commands and classes) - XSQL Servlet (IE 5.0) *** requires testing Input : *.xsql, data from DB Output: *.xml 3. OpenXML has lots of bugs - http://www.openxml.org - Parser: input XML, output HTML 4. Microsoft support for XML in IE 5.0 - Parser suports: DTD, XSL, XML 1.0, XML DOM 5. Oracle XML support - parser ver 1 - parser ver 2 (support for XML Transformation) parsing of XML documents through either DOM or SAX interfaces - XML Class generator for java creates Java classes for DTD (does not exist for version 2) 6. Architecture of Training System - Oracle 8, JavaWeb Server, JDBC *** check the structure 7. Problems with DAD for OAS *** reinstall Oracle Application Server ? DAD = DataBase Access Descriptor ========================================== 07.20.1999 1. 4:30-5:20 YuPing, Jake, Roman 2. The following demos has been prepared and discussed 1) Oracle JDBC thin driver Demo type: Java applet URL: http://mira.npac.syr.edu:1210/jdbc/111-applets/testjdbc.html thin driver requires less memory than oci8 but is also slower 2) Oracle JDBC driver oci8 Demo type: command Run: login as "oracle" cd /localb/oracle/app/oracle/product/8.1.5/ cd jdbc/demo/samples/oci8/basic-samples then type: java Employee oci8 driver is faster but needs more memory 3) XML parser for java v2 (updadte version on July 2th) Demo type: Command Run: login as "oracle" cd /localb/oracle/app/oracle/product/8.1.5/xml21/sample a) DOM interface: i) DTD in XML file: java DOMSample class.xml java DOMSample empl.xml ii) DTD out of XML file (family.dtd) java DOMSample family.xml b) SAX interface: i) DTD in XML file: java SAXSample class.xml java SAXSample empl.xml ii) DTD out of XML file (family.dtd) java SAXSample family.xml c) XSL Stylesheet (iden.xsl) i) DTD in XML file: java XSLSample iden.xsl class.xml java XSLSample iden.xsl empl.xml ii) DTD out of XML file (family.dtd) java XSLSample iden.xsl family.xml 4) XML SQL Utility for Java Only have client_side demo provided by Oracle, YuPing will create server_side demo later. Demo type: command Run: login as "oracle", source /localb/oracle/app/oracle/product/8.1.5/xmlsql/OracleXSU/unixenv.csh Comment: OracleXML are loaded into the database a) generate XML from table of database command format: java OracleXML getXML [-withDTD] [-user "scott/tiger"] \ "select * from emp" for example: java OracleXML getXML -user "scott/tiger" "select * from emp" Or you can try your own schema for any tables with at least one row. b) insert XML file into table of database command format: java OracleXML putXML [-user "scott/tiger"] XMLFile tableName Please try your own schema and map the columns of table with XML tags. For Example java OracleXML putXML -user "scott/tiger" \ -filename b.xml roman-table 5) XSQL Servlet Demo type: Browser, complete demo needs Internet Explorer 5.0 URL: http://mira.npac.syr.edu:1210/demo Please pay attention to .xsql file and dynamically generated raw XML file or HTML file. These demos are using the real database 3. Document repository - we want to store: DOC, PDF, ASCII, other with key-words, totle, author, abstract - LOB can be used for this purpose 4. We need to - interract with NCSA - install InterMedia - check LOB - sest Application Server (Jweb, DAD)o 5. How to put documents into the DB - from Web Interface {through Java Servlet} - insert XML {through SQL Utility: command(client), program( server) How to extract documents from the DB - from browser {XSQL servlet to display Raw XML DHTML - generate XML DOM Raw XML (with or without DTD) ======================================= 07.27.1999 1. 4:30-5:20 YuPing, Jake, Roman 2. The following demos has been prepared and discussed server-side demo examples using XML SQL utitlity for java. login as "oracle" on mira, go to /localb/oracle/usr/ioe/demo 1) Generate Raw XML file from DB table with DTD: java DbtoXml 2) Generate DOC tree and output all elements and attributes: java DbtoXmlDoc 3) insert XML into DB table: java XMLToDB loading formatted document inot DB table with BLOB column, including *.pdf, *.doc, *.ppt. 3. Oracle Application Server - does not work correctly - probably because I installed it in non DB mode - I must reinstall it - YuPing will test JWeb and DAD 4. Intermedia has been installed on mira Oracle interMedia Common Files 8.1.5.0.0 Oracle interMedia Image 8.1.5.0.0 Oracle8i interMedia Client Library and Demo 8.1.5.0.0 Oracle interMedia Audio 8.1.5.0.0 Oracle interMedia Video 8.1.5.0.0 Oracle interMedia Text 8.1.5.0.0 Oracle interMedia Locator Service 8.1.5.0.0 Oracle interMedia Client Option 8.1.5.0.0 Oracle interMedia 8.1.5.0.0 Oracle8i(tm) interMedia Text Manager 2.0.4.1.0 Integral to intermedia is the Clipboard abd WebAgent. These components are not available on Oracle8i distribution CDROM; the software available only for NT can be downloaded from: http://technet.oracle.com/software/download.htm This is probably the reason of difficulties querrying the database =================================================== 08.03.1999 1. 4:30-5:20 YuPing, Jake, Roman 2. Security - Kerberos + SecureID is very important for ASC/ARL - Training Management System require Kerberos - Oracle Advanced Security print manuals for YuZhu and Jake (done) 3. interMedia - progress with keyword searching and display XML, PDF, DOC 4. Copy of slides for YuZhu and Jake meeting (Dave + GCF) 3-5 Aug Mid year PET review 5. No progress with Oracle Application Server 6. WebServer design