Lately I have been playing around with Oracle's HTML DB.This is a rapid development environment for small applicaiton that is entirely web based.Unlike J2EE, the web application actually runs as PL/SQL in the database, although you can load the OHS on a separate server.
Basically a fast and surprisingly easy way to create a mod_plsql application.
One cool aspect of HTML DB is that it can be integrated into the application server midtier instances and take advantage of the AS10g Web Cache.
Integrating HTML DB into the application server is relitivaly straight forward since the heavy lifting is performed in the database. HTML DB is located on the companion disk of the Oracle 10g database.It can also be installed in a 9iR2 database.On the midtier instance execute the Oracle Universal Installer (runInstaller) and installonly HTML DB in a separate home directory.The installer will ask for connection data for the database.Again most of the install goes into the database.
1.Copy the $ORACLE_HOME (HTML DB) /marvel/images to the same directory in the midtier ORACLE_HOME.
2.Copy the $ORACLE_HOME (HTML DB) /Apache/modplsql/conf/marvel.conf to the same location in the midtier ORACLE_HOME.
We are finished with the HTML DB ORACLE_HOME and you can delete it.Rememb_erhtmlDB resides in the database.
3.In the midtier edit the marvel.conf file.Change the Alias /i/ to the directory you copied the images to.
4.Edit the midtier oracle_apache.conf and add the line below to include the marvel.conf file.
include "//Apache/modplsql/comf/marvel.conf"
5.Now run dcmctl to update the new configuration in the Metadata Repository.
dcmctl updateConfig -ct ohs
6.Restart OHS.
Your done.HTML DB in now integrated in the application server.
On Clustered midtiers, the configuration will propagate but the file changes, marvel.conf and the images will not.
