Oracle XSQL

By:

Thomas, Michael D

Material type: Text

TextPublication details: wileyDescription: PaperbackISBN:

0471271209

Subject(s):

Oracle XSQL

Holdings
Item type	Current library	Call number	Copy number	Status	Date due	Barcode
Standard Loan	Thurles Library Main Collection	005.758 THO (Browse shelf(Opens below))	1	Available		R13435KRCT

Enhanced descriptions from Syndetics:

Presents a complete approach to building XML Web applications and Web services with XSQL, Oracle Text, SQL, XSLT, and Java from data found in Oracle databases Offers expert tips on how to enhance XSQL with servlets and Java Server Pages (JSP) Provides a detailed comparison of XSQL and XQuery Companion Web site contains the code examples in the book as well as useful links where readers can download the Oracle XDK

POR 4875/Inv 141825 Micromail

Table of contents provided by Syndetics

About the Author (p. xix)
Chapter 1 Introducing Oracle XSQL (p. 1)
What XSQL Solves (p. 2)
The Problems of Web Application Development (p. 2)
XSQL as a Keystone Technology (p. 5)
XSQL and Other Oracle Technologies (p. 11)
Oracle Text (p. 12)
XML Support (p. 12)
Oracle JDeveloper (p. 13)
Introduction to XML (p. 13)
The Role of XML (p. 13)
Well-Formed versus Valid Documents (p. 15)
Document Structure (p. 15)
Processing Instructions (p. 17)
Attributes (p. 17)
Syntax Nitty-Gritty (p. 18)
Namespaces (p. 21)
Schemas (p. 21)
Moving On (p. 22)
Chapter 2 Getting Started with XSQL (p. 23)
Basic Installation (p. 24)
Installation Anatomy (p. 24)
Scratch XSQL Installation (p. 26)
Configuring Java (p. 29)
Installing in Existing Environments (p. 30)
Web and Application Server Integration (p. 30)
Configuring the Database (p. 32)
Configuring the Database Connection (p. 33)
Moving On (p. 33)
Chapter 3 Hello, XSQL! (p. 35)
Loading the XSQL Samples (p. 35)
Creating a Demo User and Table (p. 37)
Setting Connection Definitions (p. 38)
Your First XSQL Page (p. 38)
Your First XSLT Stylesheet (p. 39)
XSQLConfig .xml (p. 41)
XSQLConfig Element (p. 41)
Servlet Element (p. 41)
Processor Element (p. 42)
Http Element (p. 44)
Connectiondefs Element (p. 44)
Actiondefs Element (p. 45)
Serializerdefs Element (p. 45)
Security Issues (p. 46)
Known Issues (p. 46)
Thinking about XSQL Security (p. 50)
Moving On (p. 52)
Chapter 4 XSQL Architecture (p. 53)
Overview (p. 53)
Java Parts (p. 54)
Java Virtual Machine (p. 55)
Driver (p. 56)
Servlet Engine (p. 56)
JSP Runtime (p. 57)
Faces Of XSQL (p. 58)
XSQL Command Line Utility (p. 58)
XSQLRequest Class (p. 59)
XSQL Servlet (p. 60)
XSQL Page Processor (p. 60)
Oracle XML Modules (p. 63)
XML Parser (p. 63)
XML SQL (p. 64)
XSLT Processor (p. 64)
Core XSQL Components (p. 65)
XSQL Pages (p. 65)
Actions (p. 66)
Action Handlers (p. 66)
Serializers (p. 67)
Moving On (p. 68)
Chapter 5 Writing XSQL Pages (p. 69)
Querying the Database (p. 69)
Multiple xsql:query Actions (p. 73)
xsql:query Details (p. 77)
xsql:no-rows-query (p. 77)
Canonical Schema (p. 77)
Formatting Dates (p. 80)
Other Built-in Actions (p. 82)
xsql:dml (p. 82)
xsql:ref-cursor-function (p. 83)
xsql:include-owa (p. 83)
xsql:include-request-params (p. 84)
xsql:include-param (p. 85)
xsql:include-xml (p. 85)
xsql:set-page-param (p. 85)
xsql:set-session-param (p. 86)
xsql:set-cookie (p. 87)
xsql:set-stylesheet-param (p. 88)
xsql:action (p. 89)
xsql:include-xsql (p. 89)
xsql:insert-request (p. 90)
xsql:update-request (p. 91)
xsql:delate-request (p. 92)
xsql:insert-param (p. 93)
Linking to XSLT Stylesheets (p. 94)
Processing Instruction Details (p. 95)
Choosing Stylesheets Based on Client Type (p. 96)
Moving On (p. 96)
Chapter 6 XSQL Parameters (p. 97)
Referencing Parameters (p. 98)
Parameter XML Representation (p. 100)
Parameter Types (p. 102)
Request Parameters (p. 102)
Page-Private Parameters (p. 104)
Session Parameters (p. 104)
Cookies (p. 106)
Setting Default Parameters (p. 108)
Using Bind Variables (p. 109)
Resolving Conflicting Parameter Names (p. 110)
Stylesheets and Parameters (p. 111)
Moving On (p. 113)
Chapter 7 Database Modifications with XSQL (p. 115)
Inputting HTML Forms (p. 115)
Form Parameters and the Canonical Schema (p. 116)
Using xsql:insert-request (p. 119)
Using xsql:update-request (p. 120)
Using xsql:delete-request (p. 121)
Modifying with xsql:dml (p. 122)
Handling XML Documents (p. 123)
Handling Posted XML (p. 124)
Handling XML Parameters (p. 128)
Inserting XML as XML (p. 129)
Moving On (p. 130)
Chapter 8 Oracle SQL (p. 131)
SQL Syntax (p. 131)
Case Sensitivity (p. 131)
Lexical Conventions (p. 132)
Data Types (p. 132)
Operators (p. 137)
SQL Expressions (p. 137)
Describing Tables (p. 139)
Select Queries (p. 139)
Target Clause (p. 140)
Elements Clause (p. 143)
Where Clause (p. 148)
Order By Clause (p. 158)
Working with Sets (p. 159)
The Imaginary Dual Table (p. 160)
Managing Tables (p. 161)
Creating Tables (p. 161)
Altering Tables (p. 164)
Dropping Tables (p. 166)
Adding and Modifying Data (p. 167)
Transactions (p. 167)
Sequences (p. 168)
Insert Statements (p. 170)
Update Statements (p. 171)
Delete and Truncate Statements (p. 172)
Views (p. 172)
Creating and Altering Views (p. 172)
Using Views (p. 174)
Constraints (p. 175)
Types of Constraints (p. 175)
Using Constraints (p. 177)
Date Formatting (p. 178)
XSQL Dates versus Oracle Dates (p. 178)
Date-Format Elements (p. 180)
SQL Functions (p. 182)
Using Aggregate Functions (p. 183)
General-Purpose Numeric Functions (p. 192)
Logarithmic and Trigonometric Functions (p. 197)
Character Functions (p. 198)
Date Functions (p. 211)
Conversion Functions (p. 219)
Miscellaneous Functions (p. 223)
Moving On (p. 224)
Chapter 9 PL/SQL (p. 225)
Hello, PL/SQL! (p. 225)
Structure (p. 228)
Declaring Variables (p. 228)
Scalar Variable Declarations (p. 229)
Record Declarations (p. 231)
Cursors (p. 232)
Array Structures (p. 232)
PL/SQL Blocks and the Execution Section (p. 234)
SQL Statements in PL/SQL (p. 235)
Control Structures (p. 237)
Conditional Control Structures (p. 237)
Iterative Control Structures (p. 239)
Sequential Control Structures (p. 240)
Cursors (p. 241)
Packages (p. 244)
Procedures and Functions (p. 245)
Exceptions (p. 247)
Triggers (p. 248)
Reference Cursors (p. 250)
PL/SQL and XSQL (p. 251)
Moving On (p. 251)
Chapter 10 Using Oracle Text (p. 253)
Simple Keyword Searching (p. 254)
Stemming, Fuzzy, Wildcard, and Soundex Searching (p. 255)
Searching within XML Documents (p. 256)
Other Features (p. 259)
Moving On (p. 259)
Chapter 11 Retrieving XML (p. 261)
What's So Hard? (p. 261)
Creating XML with xsql:include-owa (p. 263)
Generating XML from PL/SQL (p. 265)
XMLType (p. 267)
Moving On (p. 271)
Chapter 12 XSLT (p. 273)
Getting Started with XSLT (p. 274)
The Place of XSLT (p. 274)
Push and Pull (p. 275)
XHTML and Stylesheet Creation (p. 277)
XHTML Defined (p. 278)
A Simple XHTML Transformation (p. 282)
Tips and Tricks of Migrating HTML (p. 285)
Moving On (p. 286)
Chapter 13 XSLT In-Depth (p. 287)
Root Element (p. 288)
xsl:stylesheet Syntax (p. 288)
Examples (p. 290)
Controlling the Output (p. 291)
xsl:output Syntax (p. 291)
Examples (p. 292)
Templates (p. 293)
xsl:template Syntax (p. 294)
xsl:apply-templates Syntax (p. 296)
xsl:call-template (p. 297)
Examples (p. 298)
Value Selection (p. 301)
xsl:value-of Syntax (p. 302)
Examples (p. 303)
Iteration (p. 304)
xsl:for-each Syntax (p. 305)
Examples (p. 306)
Conditional Logic (p. 307)
boolean Expressions (p. 308)
xsl:if Syntax (p. 308)
xsl:choose, xsl:when, and xsl:otherwise Syntax (p. 309)
Examples (p. 311)
Working with XML Entities and Text (p. 314)
xsl:element, xsl:attribute, and xsl:attribute-set Syntax (p. 315)
xsl:attribute Syntax (p. 316)
xsl:attribute-set Syntax (p. 318)
Element Creation Examples (p. 318)
xsl:text Syntax (p. 320)
xsl:comment Syntax (p. 321)
xsl:copy Syntax (p. 322)
xsl:copy-of Syntax (p. 324)
xsl:namespace-alias Syntax (p. 325)
xsl:processing-instruction Syntax (p. 326)
Numbering Elements (p. 327)
xsl:number (p. 328)
xsl:decimal-format Syntax (p. 330)
Variables and Parameters (p. 331)
xsl:variable Syntax (p. 331)
Variable Examples (p. 332)
xsl:param Syntax (p. 335)
xsl:with-param Syntax (p. 336)
Parameter Examples (p. 337)
Reusing Stylesheets (p. 339)
xsl:include and xsl:import Syntax (p. 340)
xsl:apply-imports (p. 340)
Sorting (p. 340)
xsl:sort Syntax (p. 340)
Examples (p. 341)
Whitespace Handling (p. 342)
Miscelleneous Elements (p. 342)
xsl:key Syntax (p. 342)
xsl:message (p. 343)
xsl:fallback (p. 343)
XPath (p. 344)
Expressions and Data Types (p. 344)
Location Paths (p. 345)
Axes (p. 346)
XPath and XSLT Functions (p. 353)
XSLT Specific Functions (p. 353)
Node-Set Functions (p. 356)
String Functions (p. 359)
boolean Functions (p. 363)
Number Functions (p. 364)
Moving On (p. 366)
Chapter 14 Building XSQL Web Applications (p. 367)
Application Architecture (p. 368)
The Simple XSQL Architecture (p. 369)
Process for Developing Your Architecture (p. 370)
Extension Options (p. 375)
Extending the Interface with JavaScript and CSS (p. 378)
Extension at the Database Level (p. 379)
A Sample Application (p. 380)
The Requirements (p. 380)
Application Interface Design (p. 381)
Database Requirements (p. 385)
Database Design (p. 387)
Database Implementation (p. 391)
Writing the SQL (p. 392)
Integrating XSQL with XSLT (p. 397)
Making the XSQL Pages (p. 397)
Writing the Stylesheets (p. 401)
Passing Parameters (p. 415)
Passing Using SQL (p. 415)
Setting Stylesheet Parameters (p. 417)
Using Other XSQL Parameters (p. 418)
Stateless Paging (p. 421)
Challenges of Pagination (p. 422)
Pure XSQL Stateless Paging (p. 422)
XSQL Data Editor (p. 428)
Editor Architecture (p. 428)
XSQL Development (p. 430)
Developing the XSQL Interface (p. 431)
Javascript and XSQL Development (p. 435)
JavaScript and XSLT Integration (p. 435)
Javascript and XSQL Data (p. 437)
Error Handling (p. 438)
XSQL Errors (p. 439)
An XSQL Error Template (p. 440)
Ways to Handle Errors (p. 441)
Moving On (p. 442)
Chapter 15 Command Line Utility (p. 443)
Using the Command Line Utility (p. 443)
Text Example (p. 445)
Script Writing (p. 446)
Creating Static Web Pages (p. 448)
Moving On (p. 449)
Chapter 16 Web Services with XSQL (p. 451)
Architecture (p. 452)
A Simple Web Services Consumer (p. 456)
XML-to-XML Transformations (p. 461)
XML Handling Actions (p. 467)
Moving On (p. 468)
Chapter 17 XSQL Beyond Web Browsing (p. 469)
A Sample Program (p. 470)
Guide to the XSQL Classes (p. 473)
Using XSQL from within Servlets (p. 474)
XML Parsing: DOM versus SAX (p. 475)
Oracle DOM API (p. 476)
Moving On (p. 477)
Chapter 18 Custom Action Handlers (p. 479)
Getting Started (p. 479)
Hello, Action Handler! (p. 480)
Adding XML to the Datagram (p. 482)
Comparing Action Handler and Servlet Development (p. 484)
Action Handler APIs (p. 485)
XSQLActionHandler Interface (p. 485)
XSQLActionHandlerImpl Base Class (p. 487)
XSQLPageRequest (p. 491)
Accessing Servlet Functionality (p. 492)
Database Interaction (p. 493)
Using Built-in Action Handlers (p. 494)
JDBC Connections (p. 500)
Using the XSU classes (p. 502)
Adding XMLType Objects (p. 503)
Parameters and Input (p. 504)
Accessing XSQL Data (p. 505)
Substituting Parameter Values (p. 507)
Setting Page Parameters (p. 510)
Inter-action Handler Communication (p. 513)
Moving On (p. 515)
Chapter 19 Serializers (p. 517)
Serializer Overview (p. 517)
The Place of Serializers (p. 518)
Using Serializers (p. 519)
Creating PDFs with Apache FOP (p. 520)
FOP Architecture (p. 520)
Using the XSQL FOP serializer (p. 522)
Creating Custom Serializers (p. 526)
Text Serializers (p. 527)
Binary Serializers (p. 530)
Serializing BLOBs (p. 534)
Creating JPEGs with Java AWT (p. 537)
Moving On (p. 546)
Appendix A Resources (p. 547)
Code Examples from This Book (p. 547)
Oracle Technet (p. 547)
Oracle Database Resources (p. 548)
SQL Manual for Oracle 9i (p. 548)
PL/SQL Reference (p. 548)
Oracle XML DB (p. 548)
Oracle XML Developer's Kit (p. 548)
XSLT Resources (p. 549)
Java Resources (p. 549)
Appendix B Related Standards (p. 551)
XSL-FO (p. 551)
Scalable Vector Graphics (SVG) (p. 552)
SQLJ and Java-Stored Procedures (p. 552)
Index (p. 553)

Author notes provided by Syndetics

MICHAEL D. THOMAS is a software engineer focusing on XML and Java. In 1998, he received the Outstanding Technical Achievement Award from IBM for his Internet integration work using Java, HTTP, XML, and other technologies to create one of the earliest Web services applications. Thomas is also the author of Java Programming for the Internet.