Configuration

The Oracle data source is configured along with other data sources in the Portal Manager.

Oracle general configuration options

  • Host Name: Specify the name of the oracle database server to connect to. This is the name of the machine.
  • Port: Specify the port to connect to. Oracle installs the database service to port 1521 by default.
  • User ID: Specify the user ID to use when connecting to the server.
  • Password: Specify the password for the User ID.
  • Query Timeout: Specify the number of seconds that the portal will wait for a request to be serviced by the Server Instance before giving up and returning an error. If set to zero, the portal will wait forever.
  • Schema: Specify the schema to use when accessing objects such as stored procedures, tables and views.
  • Use Default Values as Initial Values: When you select this check box, new records created in collections associated with this data source will have their properties pre-populated with their default values as configured for the table in the database. The values used are taken from the DATA_DEFAULT column of the ALL_TAB_COLUMNS view.

    Only column defaults that can be converted to the data type of the column are used. If the column default includes a SQL expression, the default will be considered null and the application will be responsible for setting the initial value.

  • Min Pool Size: Specify the minimum pool size. The default value is zero.
  • Max Pool Size: Specify the maximum pool size. The default value is 100.