Global Resource Properties

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.
Basic settings
Item name Required / Optional Use of Variables Description Remarks
Name Required Not available Enter the name of the connection setting.  
Type Required Not available Select the type of database to connect.
  • Cannot select the database out of the operation database on editing.
Required settings
Item name Required / Optional Use of Variables Description Remarks
Driver class name Required Only environment variables are available. Enter the JDBC driver class name.
  • Please contact the vendor of the database for the class name of the JDBC driver to be used.
URL Required Only environment variables are available. Enter the URL to connect to the database.
  • Please contact the vendor of the database for URL syntax.
User name Optional Only environment variables are available. Enter the user name.
  
Password Optional Only environment variables are available. Enter the password.
  
Execute transaction processing Optional Not available Select whether to perform transaction processing.
  • [Checked]: (default)
    Perform transaction processing.
  • [Not Checked]:
    Transaction processing is not performed.
Refer "Transaction" for more information. 		 

Property Action
Item name Description Remarks
Connection Test Checks the connection to the database.  
Connection Settings
Item Required/Optional Use of Variables Description Remarks
Client information property list Optional
-
 Specify the additional information of the client.
  • For more details on client information property, inquire the database vendor.
Client information property list / Name Required Only environment variables are available Enter the name of the client information property.  
Client information property list / Value Optional Only environment variables are available Enter the value of the client information property.  
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'.

Security

Security settings can be managed in Control Panel within the 'Global Resource Settings'.