mod_PL/SQL provides a Web page for configuring Database Access Descriptors (DADs). A DAD is a set of values that specify how mod_PL/SQL connects to a database server to fulfill an HTTP request.
|
Global Settings |
|
|
Default Database Access Descriptor (DAD) |
Specify a path that points to the default DAD. If the end user enters a URL without specifying the DAD name, the home page for the default DAD will be displayed.
Default = none You can change the DAD name by typing a new one in this field.
|
|
Extensions to be Uploaded as BLOB |
Specify default extensions for files to be uploaded as BLOB. The values in these fields apply if no values are specified in the Data Access Descriptor Settings: Extensions to Uploaded as BLOB fields below
WebDB 2.X Note You must leave this field blank for existing WebDB 2.x Web sites.
|
|
Extensions to be Uploaded as LONGRAW
|
Specify default extensions for files to be uploaded as LONGRAW, for example jpg or jpeg. The values in these field apply if no values are specified in the Data Access Descriptor Settings: Extensions to Uploaded as LONGRAW fields below
WebDB 2.X Note For existing WebDB 2.x Web sites, you must set this field to an asterisk (*). |
|
Administrators |
Specifies who can view the admin pages. By default, this is set to ALL which means anyone can view the admin pages. This should be changed to a comma separated list of users to enforce security on the admin pages, for example scott, mike where scott and mike are local database user names.
Note This setting is accessible through the configuration file only, not through mod_PL/SQL Web page.
|
|
Admin path |
Specifies the URL path element that identifies an admin page. This should normally be left unchanged as /admin_/.
Note This setting is accessible through the configuration file only, not through mod_PL/SQL Web page.
|
|
Custom Authentication |
Specifies whether to enable custom authentication. If specified, the application authenticates users in its own level and not within the database level. This parameter can be set to one of the following values :
- Blank or None (Default)
- Global
- Custom
- PerPackage
|
|
Database Access Descriptor Settings |
|
|
Database Access Descriptor Name |
Displays the name forthis DAD. The name is set at installation time or during creation of new web sites. You can change the name by typing a new one in this field.
|
|
Oracle User Name |
Displays the Oracle database account user name. The user name is typically set at installation or during creation of new web sites. You can change it by typing a new name in this entry field.
|
|
Oracle Password |
Displays the Oracle database account password. The password is typically set at installation, but you change it by typing a new password in this entry field.
Notes The Oracle User Name and Password are the default user name and password for logging in to a Web site or page. If you leave the Oracle User Name and Oracle Password entry fields blank, the user will be prompted to enter a user name and password when first logging in.
|
|
Oracle Connect String |
Enter a SQL*Net alias if you are using a remote database. Leave this field blank if the database is local.
|
|
Maximum Number of Worker Threads |
Enter the size of the connection pool. This is the maximum number of database connections kept open at one time for this DAD. If request for another connection comes in after the maximum number is reached, one of the connection is closed to serve this request.
Tip You'll need to adjust this number depending on your server, its capacity, and the number of connected users. As a rule of thumb, set this number at between 5 and 10 at a medium sized installation (approximately 200 users).
Notes
- This field is ignored when the Unix Oracle HTTP Server (powered by Apache) server is used with mod_PL/SQL. In a Unix configuration, each server process keeps one database connection pooled for one DAD. Thus, the maximum number of Oracle HTTP Server (powered by Apache) processes currently alive is the maximum size of the connection pool for each DAD. If the number of processes grows, the pool size grows, and mod_PL/SQL creates new connection. When a process dies, connection are closed. The maximum number of serverprocesses can be configured through Oracle HTTP Server (powered by Apache) Configuration files.
- When NT Oracle HTTP Server (powered by Apache) Server is used with mod_PL/SQL, configuration files govern the maximum number of threads that will simultaneously be serving requests. The Maximum Number of Open Threads field governs maximum number of connection that can be kept open. Therefore, to ensure correct behavior on NT, specify a value that is equal to maximum number threads specified in server configuration files. Specifying a value for Maximum Number of Open Threads that is greater than that specified in the server configuration file doesn't affect performance and is same as these numbers being equal. If this number is smaller, some requests may be rejected if threads are idle to serve but maximum connection limit has already been reached.
|
|
Keep Database Connection Open Between Requests?
|
Choose whether, after processing one URL request, the database connection should be kept open to process future requests. In most configurations, specify Yes for maximum performance.
|
|
Default (Home) Page |
Enter the PL/SQL procedure that will be invoked when none is specified as part of the URL itself. For example, if you specify a default home page of myapp.home and an end user enters this URL in a browser:
http://myapp.myserver.com:2000/pls/myapp/
will automatically update the URL to:
http://myapp.myserver.com:2000/pls/
myapp/myapp.home
|
|
Document Table |
Enter the name of the database table into which files uploaded to a web site created with will be stored. The default value in this entry field is based on the name of the schema in which you created the site.
|
|
Document Access Path |
Enter a path in the URL installation that is used to indicate a document is being referenced. In the following URL, for example:
http://myapp.myserver.com:2000/pls/my_site/
docs/folder1/presentation.htm
docs is the document access path.
|
|
Document Access Procedure |
Enter the procedure that will be used to upload and download documents.
|
|
Extensions to be Uploaded as BLOB
|
Specify extensions for files to be uploaded as BLOB.
WebDB 2.X Note You must leave this field blank if the DAD is for an existing WebDB 2.x Web site.
|
|
Extensions to be Uploaded as LONGRAW
|
Specify extensions for files to be uploaded as LONGRAW. |
|
Path Alias |
To be used by PL/SQL applications for path aliasing.
WebDB 2.X Note You must leave this field blank if the DAD is for an existing WebDB 2.x Web site.
|
|
Path Alias Procedure |
To be used by PL/SQL applications for path aliasing.
WebDB 2.X Note You must leave this field blank if the DAD is for an existing WebDB 2.x Web site.
|
|
Enable Single Sign On Authentication |
Specify the authentication mechanism used by gateway. Choose Yes to authenticate through the Single Sign On mechanism.
You must choose No for applications that do not support SingleSignAuthetication.
WebDB 2.X Note and 3.0 beta You must choose No if the DAD is for an existing WebDB 2.x Web site.
|
|
Custom Authentication |
Specifies whether to enable custom authentication. If specified, the application authenticates users in its own level and not within the database level. This parameter can be set to one of the following values :
- Blank or None (Default)
- Global
- Custom
- PerPackage
|
