Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Built-In Services | pub.jdbcAdapter:updateNotificationSchema
 
pub.jdbcAdapter:updateNotificationSchema
 
Configuring the UpdateNotificationSchema Service
Setting Input Fields
The pub.jdbcAdapter:updateNotificationSchema Java service changes the schema names configured in the following types of notifications: InsertNotification, DeleteNotification, UpdateNotification, OrderedNotification, and BasicNotification.
This service always validates the new schemas against the notification settings, and sets the state of the notification to the state it is in before it is updated, regardless of whether the update is successful.
The service does the following:
Step
Description
1
The service checks the current status of the notification.
2
If the notification is enabled, the service checks the forceDisable parameter. If forceDisable is false, the service reports the error. If forceDisable is true, the service disables the notification.
3
The service validates the schema against the notification's settings. The validation requires that the schema be in the same catalog that is configured with the notification and that the table, synonym, view, or alias, configured in the notification be in the schema. If the schema is not valid, the service throws an exception.
4
The service updates the notification property with the new schemas, and throws an exception if the input fields for the new schemas are not valid.
5
If the original notification state is enabled, the service enables the notification.
Note:
If an exception is thrown when the service attempts to re-enable a polling notification, you will receive the message "The schema is updated but the notification could not be enabled." This is because, by design, the metadata has already been updated. You might need to roll back to the previous state, as needed.
Input Parameters
nodeName
String. Required. Sets the name of the notification to be updated.
forceDisable
Boolean. Required. If the value of this field is set to true, the service disables the notification that is in the enabled state.
allSchemaChange
Record. Optional. Indicates that the update is to occur on every schema name in the notification.
allSchemaChange.useCurrentSchema
Boolean. Optional. It sets all schema names to <current schema>.
allSchemaChange.schemaName
String. Optional. Sets all schema names to the value of this field.
schemaChanges
Record List. Optional. Makes individual schema changes, replacing the schema identified by the existingSchema field with the new name set in the newSchema field.
schemaChanges.existingSchema
Record. Required. Identifies the schema name to change.
schemaChanges.existingSchema.useCurrentSchema
Boolean.Optional. Identifies the <current schema>.
schemaChanges.existingSchema.schemaName
String. Optional. Specifies an existing schema name for the schemaName field.
schemaChanges.newSchema
Record. Required. Identifies an existing schema name that will replace all occurrences of existing schemas identified in the existingSchema field.
schemaChanges.newSchema.useCurrentSchema
Boolean. Optional. Sets new schema names to <current schema>.
schemaChanges.newSchema.schemaName
String. Optional. Sets new schema names to this name.
Output Parameters
None.