 |
 |
 |
 |
This section lists some notes and recommendations on how to use each database provider.
Before opening a connection with a database provider, one needs to specify the connection parameters. These parameters, even though some are shared by many database providers, are specific to each provider and the gda-sql or the gda-list-config tools can be used to obtain a complete list.
The following arguments are used to connect to an Oracle database:
Table 1.
| Argument name | Description | Required |
|---|---|---|
| DB_NAME | Service name: global database name entered during database creation (it combines a database name with a domain name), can be left empty to connect to the default database. | No |
| HOST | Database server: host on which the database server is running | Yes |
| PORT | Port: database server port (leave this field empty for the default 1521 port) | No |
| SCHEMA | Schema: Name of the schema to use. If not specified, the schema defaults to that of the connected user. | No |
Note however all the arguments above can be replaced by a single TNSNAME argument (see
the "Oracle Database Net Services Administrator's Guide" for more information about defining
connection identifiers).
Also refer to the Oracle's provider's limitations.