Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

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.

$ORACLE_HOME/xdk/admin/XSQLConfig.xml

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).

http://yourserver:7777/emp1.xsql

To view the results of the stylesheet transformation use the second XSQL document.

http://yourserver:7777/emp2.xsql

For more information see:

Hope this helps. Regards Tim...

Back to the Top.