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.