📄 adxml.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 3.2 transitional//en.us"><HTML lang="en.us"><HEAD><META NAME="Generator" CONTENT="Quadralay WebWorks Publisher 5.0.4"><META NAME="Page" CONTENT="DefaultSingle"><META NAME="Title" CONTENT=" Oracle9i XML Developer's Kits Guide - XDK"><TITLE> Oracle9i XML Developer's Kits Guide - XDK</TITLE> <LINK REL="home" HREF="../../products.htm" TITLE="Library"><LINK REL="toc" HREF="toc.htm" TITLE="Contents"><LINK REL="index" HREF="index.htm" TITLE="Index"><LINK REL="copyright" HREF="../dcommon/html/cpyr.htm" TITLE="Copyright"><LINK REL="up" HREF="toc.htm" TITLE="Up"><LINK REL="next" HREF="index.htm" TITLE="Next"><LINK REL="previous" HREF="adxdb.htm" TITLE="Previous"></HEAD> <BODY BGCOLOR="#ffffff"><A NAME="top"></A><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR> <TD ALIGN="LEFT" VALIGN="TOP"><FONT COLOR="#330099" FACE="Helvetica, Arial, sans-serif"><B>Oracle9<i>i</i> Database Generic Documentation Addendum<BR>Release 2 (9.2)</B><BR>Part Number A97283-01</FONT></B></TD><td valign="BOTTOM" align="RIGHT" width="144"><table cellspacing="0" cellpadding="0" width="50%"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE><HR><P><A HREF="adxdb.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A><A HREF="index.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A> <DIV CLASS="IND"><!-- End Header --><A NAME="1656"></A><!--TOC=Title-"1656"--><H1 CLASS="Title"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">13<BR> Oracle9<EM CLASS="Italic">i</EM> XML Developer's Kits Guide - XDK</FONT></H1><!--/TOC=Title--><A NAME="1036438"></A><P CLASS="BP">This chapter lists additions and corrections to <EM CLASS="Italic">Oracle9i XML Developer's Kits Guide - XDK</EM>, Release 2 (9.2).</P><A NAME="1036481"></A><P CLASS="BP">This chapter contains the following topics:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1036440"></A><A HREF="adxml.htm#1036265">XML-SQL Utility (XSU)</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="1036441"></A><A HREF="adxml.htm#1036316">XSU Dependencies and Installation</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="1036474"></A><A HREF="adxml.htm#1036342">XMLGEN API Has Been Deprecated</a><P></UL><A NAME="1036265"></A><!--TOC=h1-"1036265"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> XML-SQL Utility (XSU)</FONT></H2><!--/TOC=h1--><A NAME="1036368"></A><P CLASS="BP">In Chapter 8, "XML SQL Utility (XSU)", Example 3 should be replaced as it is unnecessarily complex. You must first call XSU, then position the first element's cursor. Also, there is no need for a scrollable cursor. XSU processes all rows following the current row in the resultset. If you position the cursor at the first row of the resultset, then XSU starts with row #2. To position the cursor before the first row use the <CODE>beforeFirst()</CODE> method. XSU scrolls the resultset on its own so you do not have to worry about breaking.</P><A NAME="1036588"></A><P CLASS="BP">The following example should replace the existing Example 3. It shows how you can use the XSU for Java API to generate an XML page: </P> <PRE CLASS="CE"><A NAME="1036272"></A>------------------ b.java ------------- <A NAME="1036273"></A>import oracle.sql.*; <A NAME="1036274"></A>import oracle.jdbc.driver.*; <A NAME="1036276"></A>import oracle.xml.sql.*; <A NAME="1036277"></A>import oracle.xml.sql.query.*; <A NAME="1036278"></A>import oracle.xml.sql.dataset.*; <A NAME="1036279"></A>import oracle.xml.sql.docgen.*; <A NAME="1036280"></A><A NAME="1036281"></A>import java.sql.*; <A NAME="1036282"></A>import java.io.*; <A NAME="1036283"></A><A NAME="1036284"></A>public class b <A NAME="1036285"></A>{ <A NAME="1036286"></A> public static void main(String[] args) throws Exception <A NAME="1036287"></A> { <A NAME="1036288"></A><A NAME="1036289"></A>@ DriverManager.registerDriver(new <A NAME="1036290"></A>oracle.jdbc.driver.OracleDriver()); <A NAME="1036291"></A><A NAME="1036292"></A> Connection conn = <A NAME="1036293"></A> DriverManager.getConnection("jdbc:oracle:oci8:scott/tiger@"); <A NAME="1036294"></A><A NAME="1036295"></A> Statement stmt = <A NAME="1036296"></A>conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, <A NAME="1036297"></A> ResultSet.CONCUR_READ_ONLY); <A NAME="1036298"></A><A NAME="1036299"></A> String sCmd = "SELECT ENAME FROM SCOTT.EMP"; <A NAME="1036300"></A> ResultSet rs = stmt.executeQuery(sCmd); <A NAME="1036301"></A><A NAME="1036302"></A> OracleXMLQuery xmlQry = new OracleXMLQuery(conn, rs); <A NAME="1036303"></A> xmlQry.keepObjectOpen(true); <A NAME="1036304"></A> //xmlQry.setRowIdAttrName(""); <A NAME="1036305"></A> xmlQry.setRowsetTag("ROWSET"); <A NAME="1036306"></A> xmlQry.setRowTag("ROW"); <A NAME="1036307"></A> xmlQry.setMaxRows(20); <A NAME="1036308"></A><A NAME="1036309"></A> //rs.beforeFirst(); <A NAME="1036310"></A> String sXML = xmlQry.getXMLString(); <A NAME="1036311"></A> System.out.println(sXML); <A NAME="1036312"></A> } <A NAME="1036313"></A>} <A NAME="1036314"></A> </PRE> <A NAME="1036316"></A><!--TOC=h1-"1036316"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> XSU Dependencies and Installation </FONT></H2><!--/TOC=h1--><A NAME="1036317"></A><!--TOC=h2-"1036317"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Dependencies </FONT></H3><!--/TOC=h2--><A NAME="1036318"></A><P CLASS="BP">XML SQL Utility (XSU) depends on the following components: </P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1036320"></A>Database connectivity -- JDBC drivers. XSU can work with any JDBC driver but it is optimized for Oracle JDBC drivers. Oracle does not make any guarantee or provide support for the XSU running against non-Oracle databases. <P><LI CLASS="LB1" TYPE="DISC"><A NAME="1036322"></A>Oracle XML Parser, Version2 -- <CODE>xmlparserv2.jar</CODE>. <CODE>xmlparserv2.jar</CODE> is included in the Oracle9<EM CLASS="Italic">i</EM> installations. <CODE>xmlparserv2.jar</CODE> is also part of the XDK for java archive downloadable from Oracle Technology Network (OTN) Web site. <P><LI CLASS="LB1" TYPE="DISC"><A NAME="1036324"></A>XSU also depends on the classes included in <CODE>xdb.jar</CODE> and <CODE>servlet.jar</CODE>. These are present in Oracle9<EM CLASS="Italic">i</EM> installations. These are also included in the XDK for java archive downloadable from OTN. <P></UL><A NAME="1036327"></A><!--TOC=h2-"1036327"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Installing the XSU </FONT></H3><!--/TOC=h2--><A NAME="1036328"></A><P CLASS="BP">XML SQL Utility (XSU) ships with the Oracle9<EM CLASS="Italic">i </EM>software CD, and is also part of XDK for Java available from OTN. XSU is comprised of the following two files: </P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1036330"></A><CODE>$ORACLE_HOME/lib/xsu12.jar</CODE>: This contains the Java classes that constitute XSU. xsu12 requires a minimum of JDK1.2.x and JDBC2.x. <P><LI CLASS="LB1" TYPE="DISC"><A NAME="1036331"></A><CODE>$ORACLE_HOME/rdbms/admin/dbmsxsu.sql:</CODE> This is the SQL script that builds the XSU PL/SQL API. Load <CODE>xsu12.jar</CODE> into the database before executing <CODE>dbmsxsu.sql</CODE>. <P></UL><A NAME="1036334"></A><P CLASS="BP">By default Oracle9<EM CLASS="Italic">i</EM> Installer installs XSU on your hard drive at the locations specified in the previous paragraph. It also loads XSU into the database. If XSU is not installed during the initial Oracle installation, it can be installed later. You can either use Oracle Installer to install the XSU and its dependent components, or you can download the latest XDK for Java from OTN. </P><A NAME="1036337"></A><P CLASS="BP">To load the XSU into the database you must perform one the following steps, depending on how you installed XSU: </P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1036338"></A>Oracle Installer installation: change to your <CODE>ORACLE_HOME</CODE> directory, then to <CODE>rdbms/admin</CODE>. Run <CODE>initxml.sql</CODE>.<P><LI CLASS="LB1" TYPE="DISC"><A NAME="1036339"></A>OTN download installation: change to the <CODE>bin</CODE> directory of the downloaded/expanded XDK archive. Run the <CODE>xdkload</CODE> script. If you are using Windows run <CODE>xdkload.bat</CODE>. <P></UL><A NAME="1036342"></A><!--TOC=h1-"1036342"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> XMLGEN API Has Been Deprecated </FONT></H2><!--/TOC=h1--><A NAME="1036343"></A><P CLASS="BP">Before the first XSU production release, that is, before Oracle8<EM CLASS="Italic">i</EM> Release 3 (8.1.7), XSU for PL/SQL API was named "XMLGEN". This must not be confused with a) the XML generation SQL function <CODE>SYS_XMLGEN</CODE>, b) the XML generation PL/SQL supplied package <CODE>DBMS_XMLGEN</CODE>, or c) <CODE>XMLGen()</CODE> the SQLX standard function. Note that when XSU was first offered as a production release in Oracle8<EM CLASS="Italic">i</EM> Release 3 (8.1.7), the "<CODE>XMLGEN</CODE>" package was deprecated. In other words, "<CODE>XMLGEN</CODE>" was never offered as part of Oracle8<EM CLASS="Italic">i</EM> Release 3 (8.1.7) production code although it continued to be shipped with the Oracle software. It was never documented! </P><A NAME="1036348"></A><P CLASS="BP">"<CODE>XMLGEN</CODE>" replacements are <CODE>DBMS_XMLQuery</CODE>, used for XML generation, and <CODE>DBMS_XMLSave</CODE> used for DML and data manipulation. Oracle9<EM CLASS="Italic">i</EM> Release 2 (9.2) and higher no longer include "<CODE>XMLGEN</CODE>" with the Oracle software. </P><A NAME="1036351"></A><P CLASS="BP">Although for this release, the "<CODE>XMLGEN</CODE>" "deprecated" package can still be downloaded from OTN as part of the XSU download, which in turn is part of the XDK download, you are recommended to migrate to the latest production packages <CODE>DBMS_XMLQuery</CODE> and <CODE>DBMS_XMLSave</CODE>. Migration is simple as the method names are identical. The difference is that the new XSU for PL/SQL API contains more methods. Note that all take the context handle as the first argument. </P><A NAME="1036354"></A><P CLASS="BP"></P><!-- Start Footer --></DIV><DIV CLASS="OUTD"><HR><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR><TD VALIGN="BOTTOM" WIDTH="33%"><TABLE CELLSPACING="0" CELLPADDING="0"><TR><TD ALIGN="CENTER"><A HREF="adxdb.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD><TD ALIGN="CENTER"><A HREF="index.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD> </TR></TABLE></TD><TD ALIGN="CENTER" WIDTH="34%"><font size="-2">Copyright © 2002 Oracle Corporation.</font><BR><FONT SIZE="-2">All Rights Reserved.</FONT></TD><TD VALIGN="BOTTOM" ALIGN="RIGHT" WIDTH="33%"> <TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="144"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE> </DIV></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -