 |
|
Oracle Tips by Burleson |
Database
Access Descriptor
The DAD is a set of
instructions for Oracle HTTP Server and the mod_plsqlextension module. Together, they will use the information in the DAD
for connections to the database.
Please note that the HTML DB documentation refers
to a file named marvel.conf in many places. For the purposes of this
book, any time the documentation mentions editing the marvel.conf,
this reference will apply to the dads.conf file.
The name of the configuration file is dads.confand is
located in the following directory:
Windows:
ORACLE_HOME\Apache\modplsql\conf
Linux:
ORACLE_HOME/Apache/modplsql/conf
The following is an example of a dads.conf file:
Alias /i/
"c:\oracle\product\10.2.0\ohs\Apache\Apache\images/"
<Location /pls/hdb20>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername HTMLDB_PUBLIC_USER
PlsqlDatabasePassword htmldb
PlsqlDatabaseConnectString localhost:1522:hdb20
ServiceNameFormat
PlsqlAuthenticationMode Basic
PlsqlDefaultPage htmldb
PlsqlDocumentTablename
wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure
wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
</Location>
When configuring the DAD on Linux, the
only change to the DAD in the above example is for the location of the
images virtual directory as shown here.
Alias /i/
"/u01/app/oracle/product/10.2.0/ohs/Apache/Apache/images/"
A few of the items in the DAD configuration
are explained in Table 2.3 below, but it is a good idea to read the dads.README file located in the same directory as the dads.conf
configuration file. It will explain all the configuration parameters
in greater detail.
|
PARAMETER |
DESCRIPTION |
|
Alias
|
This is set to /i/ and references the
location where you installed the images earlier in this chapter.
When HTML is rendered to your browser this is the virtual
directory for the location of images, cascading style sheets, java
scripts, etc. |
|
<Location /pls/hdb20> |
This is the name of the virtual path that
will be used to access your HTML DB web application. |
|
PlsqlDatabaseConnectString |
This is in the format of
server.domain:port:sid. Here we used the name httpserver, but if
you have a local database you can use localhost for the
server.domain part. Then provide the port number the database is
listening on and service name (sid). If your database is on a
server you may need your Remote DBA to provide you with the necessary
information. |
|
PlsqlDatabaseUsername
|
This is the username that will be used by the
mod_plsqlextension module for connecting to the database.
Every connection, regardless of the login id and password provided
will be connected to the database with this username. |
|
PlsqlDatabasePassword
|
This should be set to the same password as
was provided during the installation of HTML DB. It is the
password given to the schema owners of the HTML DB objects and
HTMLDB_PUBLIC_USER. |
Table 2.3:
Example DAD configuration parameters and their descriptions
REMEMBER: After configuring the DAD, the HTTP
Server process must be restarted as described in Chapter 1.
The above book excerpt is from:
Easy
HTML-DB Oracle Application Express
Create
Dynamic Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent
Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|
