Database Access Descriptor Configuration (DAD) 转载

Database Access Descriptor

The DADis 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 DADconfiguration 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 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.