XSQL Servlet and XSQL Pages
The XSQL Servlet allows dynamic generation of XML documents via XSQL pages. This article lists the bare minimum to get XSQL pages working. It is assumed that the pages are being run through the HTTP server bundled with the database.
First you must setup a database connection nickname in the XSQLConfig.xml file to use in your XSQL pages. By default this file is is the following location.
The connection details are near the bottom of the file in the
<connectiondefs> section. Adjust the following entry to use the correct JDBC driver settings.
<connection name="demo"> <username>scott</username> <password>tiger</password> <dburl>jdbc:oracle:thin:@server01:1521:MYSID</dburl> <driver>oracle.jdbc.driver.OracleDriver</driver> <autocommit>true</autocommit> </connection>
Next restart the http server.
su - root $ORACLE_HOME/Apache/Apache/bin/apachectl restart
Next save the following files in the document root directory (by default $ORACLE_HOME/Apache/Apache/htdocs).
Once this is complete the XSQL documents can be accessed via a browser. To view the basic XML output simple enter the following URL in your browser (adjusted accordingly).
To view the results of the stylesheet transformation use the second XSQL document.
For more information see:
Hope this helps. Regards Tim...