Global Resource Properties

For any information on the Global Resource property settings for Amazon RDS for Oracle adapter, see here.

Connection Settings

Connection settings for a Global Resource can be managed in the property setting dialog for each adapter, in the 'Global Resource Settings' within the Control Panel, or from WebConsole.

Common settings for each adapter

Basic settings
Item name Required / Optional Use of Variables Description Remarks
Name Required Not available Enter the name of the connection setting.  
Required settings
Item name Required / Optional Use of Variables Description Remarks
Hostname Required Only environment variables are available. Enter the host name of database.
  • Disabled if [Enter the URL directly] is checked.
Port number Optional Only environment variables are available. Enter the port number of database.
The default number is "1521".
  • Disabled if [Enter the URL directly] is checked.
SID Required Only environment variables are available. Enter the database SID.
  • Disabled if [Enter the URL directly] is checked.
URL Required Only environment variables are available. Enter the URL.
The URL format of Oracle is "jdbc:oracle:thin:@<hostname>:<port number>:<SID>".
  • Enabled if [Enter the URL directly] is checked.
Enter the URL directly Required   Select whether to directly enter the URL of the Oracle database to connect.
  • [Checked]:
    Enter the URL directly.
  • [Not Checked]: (default)
    The URL is generated based on the settings of [Hostname], [Port number], and [SID].
 
User name Required Only environment variables are available. Enter the user name.  
Password Optional Only environment variables are available. Enter the password.  
Property Action
Item name Description Remarks
Connection Test Checks the connection to the database.  
Display Settings
Item name Required / Optional Use of Variables Description Remarks
Specify the number of tables in the list Optional Not available Select whether to limit the number of tables listed or not.
  • [Checked]:(default)
    limit the number of tables names listed.
  • [Not Checked]:
    Table names listed are not limited. Fetches all of the table names available.
 
Number of tables Optional Available Enter a number of tables listed.
  • Enabled when [Specify the number of tables in the list] is checked.
  • Defaults to 500 if omitted.Defaults to 500 if omitted, or if the value specified is invalid.
Specify the number of procedures in the list Optional Not available available Select whether to limit the number of procedures or not.
  • [Checked]:(default)
    limit the number of procedures listed.
  • [Not Checked]:
    Procedure names listed are not limited. Fetches all of the procedure names.
 
Number of procedures Optional Available limit the number of the procedures listed.
  • Enabled when [Specify the number of procedures in the list] is checked.
  • Defaults to 500 if omitted. Defaults to 500 if omitted, or if the value specified is invalid.

Components pool settings

Component pool settings can be managed in Control Panel within the 'Global Resource Settings' or from WebConsole.

Security

Security can only be set from "Global Resource Settings" or from WebConsole.