Synonym Support for Oracle Database
To enable synonym support for an Oracle database,
you must specify
connectionproperties={includeSynonyms=true}
in the
Other
Properties field for the adapter connection. For information about
configuring connections, see
Configuring Adapter for JDBC Connections.
The following table lists the adapter services and notifications that support synonyms.
| Adapter Services | Adapter Notifications |
|---|---|
| SelectSQL | Basic Notification |
| DeleteSQL | Delete Notification |
| InsertSQL | Insert Notification |
| UpdateSQL | Ordered Notification |
| StoredProcedure | Stored Procedure Notification |
| Update Notification |
Consider the following limitations when using synonyms with adapter services:
- If you want to use synonyms for stored procedures, you cannot use the StoredProcedureWithSignature adapter service. Use the StoredProcedure service instead.
- The SelectSQL, DeleteSQL, InsertSQL, and Update SQL services support synonyms only for database tables and views.
For information about configuring adapter services, see Overview of Adapter Services. For information about configuring adapter notifications, see Overview of Adapter Notifications.