Have been hearing a lot of stuff on htmldb on how easy it is to develop web-based applications. For a novice like me in web technologies, I really wanted to try it out. So have got it installed on my laptop now. The basic steps that I followed:

  • Installed 10gR2 and created a “v10gR2” db
  • Installed HTTP server from the 10gR2 companinon CD
  • Installed HTMLDB 2.0 for win32 by downloading it from here.

All three installs didn’t give me any problems. The only area where I got confused was in configuring htmldb 2.0. The installation guide of htmldb2.0 made reference to a file called marvel.conf – which I never found in any of the directories where HTTP Server was installed. Also the guide was on using 10gR1 HTTP Server, whereas I was using the R2 HTTP Server.

Still, I was able to configure it on 10gR2 HTTP Server.

Summary of the changes done:

  • copied the images dir from htmldb 2.0 zip file to $ORA_COMP_HOME\Apache\Apache\icons directory
  • Added an alias /i/ in $ORA_COMP_HOME\Apache\Apache\conf\httpd.conf file pointing it to the copied images directory.
  • Added two MIME types to support SQL Workshop:

    AddType text/xml xbl
    AddType text/x-component htc

  • Added a DAD (Database Access Descriptor) to $ORA_COMP_HOME\Apache\modplsql\conf\dads.conf file.

After the above changes, a restart of Apache and my htmldb page was accessible through http://myHostNameGoesHere:7777/pls/htmldb

Now its time to play around with it and these articles on OTN should take me forward.

Leave a Reply