Show description

The XSQL servlet is written in Java, and the JDBC driver is necessary to access the database. ■■ Oracle database. For your purposes, consider this an Oracle 9i database. However, Oracle XSQL isn’t limited to only 9i. 3. Database compatibility is determined by JDBC compatibility. Thus, non-Oracle JDBC-compliant databases can also be integrated with XSQL. This book will focus on XSQL integration with Oracle 9i and how to take advantage of the rich technology available only from Oracle. ” Except for the Web browser, all of these components are installed by default.

When the parser encounters the CDATA declaration, it skips all characters inside of it. [CDATA[ select * from emp where sal < 50000 ]]> CDATA entities are useful any time that you have sections that shouldn’t be processed because they also take a load of the processor. Comments No programming language is complete without comments. The syntax for comments in XML is as follows. It is identical to HTML comments. —- An XML Comment —> Introducing Oracle XSQL Namespaces As discussed earlier, XML allows you to create your own languages.

You use a different action, called . Instead of specifying a select statement, you issue a statement that will modify the data. As you’ll see in Chapter 14, you can use it in conjunction with forms to create editors. XSQL also provides you with built-in ways to call stored procedures. You may be looking at this and thinking, “Simple! . but maybe a little too simple . . ” Of course, the simple architecture isn’t going to be good enough for all problems. But that doesn’t mean that you can’t use XSQL to solve harder problems that involve multiple queries or complex validation before putting data into the database.