|
 | In all parameters dad stand for one of the DAD defined in the parameter global.alias |
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.dbusername/dad.dbpassword
|
Any valid string for username and password
|
empty string
|
Database username and password, left in blank if you choose dynamic login. Do not use dynamic login with global,
per_package or custom authentication, see below for details.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.connectString
|
Any valid JDBC url string
|
jdbc:oracle:thin:@localhost:1521:ORCL
|
Database connect string, in jdbc syntax.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.errorLevel
|
0,1,2
|
0
|
How DB Prism returns the errors:
0 - returns 404 error code - Not Found, may be redirect by the Web Server to another page.
1 - no error reporting redirects to errorPage url parameter, see below.
2 - maximum error reporting package+proc+(args,values).
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.errorPage
|
A valid URL
|
http://localhost/error.html
|
url to redirect if error level is 1.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.dynamicLoginRealm
|
Any valid String
|
DAD name
|
String that the browser shows to the users when ask for username and password.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.compat
|
A compatibility mode
|
7x
|
A valid compatibility mode defined in the parameter global.compatlist.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.producerarg
|
pass/ignore
|
pass
|
Ignore or not the argument producer.
Useful with Cocoon framework
pass - normally operation OWS (Default)
ignore - With Cocoon, it normaly needs extra args in Servlet engine to redirect
to different producers see cocoon.properties file for details of producer argument.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.dbcharset
|
A valid java string for charset
|
iso-8859-1
|
Database charset, used for converting result from the database side in the servlet engine.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.clientcharset
|
A valid java string for charset
|
iso-8859-1
|
Charset used by Servlet engine to enable non-ascii input
JServ or JSDK needs this - they don't detect parameters charset.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.StateLess
|
true/false
|
false
|
If false, DB Prism calls dbms_session.reset_package procedure before a client procedure
to guarantee reset all packages variables and global states (OWS 3.0)
In Oracle Lite support you has to write StateFull code in com.prism.polite.DBMS_Session class
If true, DB Prism don't calls to Reset Session, and then, global variables of packages, for example, persists
across differents http calls, this no guarantee same connection objects to the same client
for this purpose use Transactions and leave this parameter with the default value.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.documentTable
|
[schema.]table_name
|
owa_public.wpg_document
|
This table is used by the upload/download functionality to store the content.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.docAccessPath
|
A valid string in the url path
|
docs
|
This path is used by the DB Prism gateway interface to check if the document will be downloaded
by the Document Access Procedure.
For example an url like this http://server:port/servlets/plsql/docs/xx/yy/file.ext identified
docs as document access path, the instead of calls file.ext as
stored procedure, calls to the document access procedure which decode the url
and return the correct content to the client.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.docAccessProcedure
|
A valid stored procedure [[schema.]package.]procedure
|
owa_public.wpg_testdoc.process_download
|
This procedure is called by the DB Prism gateway in order to set up the file to be download
This procedure is called without argument, they must be decode the url information and return
the document to be download by using the toolkit procedures.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.defaultPage
|
A valid stored procedure [[schema.]package.]procedure
|
wwwIndex.html
|
Defines which procedure is called if a subdirectory is found.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.alwaysCallDefaultPage
|
true/false
|
false
|
Ignore package procedure in the url call, calls always to the defaultPage.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.customAuthentication
|
none/global/perPackage/custom
|
none
|
This parameters replaces the old style custom authentication seted by
OWA_CUSTOM or OWA initialize procedures
|
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.toolkit
|
3x/4x
|
3x
|
Htp toolkit used, 3x => WAS 3.x, 4x => OAS 4.x, Web DB or IAS 1.0
See Toolkits section for detail.
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.exclusion_list
|
space delimited list of procedures or packages
|
sys. owa dbms_ htp.
|
Prevent that malicious user may directly access oracle database server
information or write cross-site script attack.
Look at
this security alert
for more information.
Unlike mod_plsql it do not requires wildcars (*) and is space delimited.
The default values prevent to any user execute packages owned by sys.,
owa toolkit, dbms_ and htp. packages.
|
|
| Oracle 7.x version (PLSQL support only) |
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.type_owner
|
a valid database user (schema)
|
owa_public
|
type_owner is the user which has installed the toolkit
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.type_name
|
a valid package name
|
owa_util
|
type_name is the package which defines the PLSQL table type used for passing multi-valuaded parameters
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.type_subname
|
a valid PLSQL type name
|
ident_arr
|
type_subname is the PLSQL table type defined to pass multivalued infomation
|
|
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.case
|
lower/upper/case
|
lower
|
Case sensity, with Java Stored procedure support in Oracle Lite Databases
this parameter control if the package.procedure is converted to upper, lower or as is
|
|
| Oracle 9.2.0+ PLSQL or Java |
| Name
|
Values
|
Default Value
|
Explanation
|
| dad.debugHost/dad.debugPort
|
hostname,port
|
no default value
|
Enable remote debugging support for PLSQL or Java Stored procedures using
JPDA functionality of JDeveloper 9.0.3+. If debugHost is empty
disable debugging functionality.
Users who want to use this functionality requires DEBUG CONNECT SESSION
and DEBUG ANY PROCEDURE database grants.
debugHost/debugPort must be the same as the options of
Project->Project Settings...->Debugger-Remote->Listen for JPDA
|
|
|
