Handling database exceptions in a graphical data map
Add a Failure transform to your graphical data map to handle exceptions that might be raised as a result of a database transform.
About this task
If you want the map to handle exceptions that are returned from the database server when the SQL operation is run, instead of such exceptions stopping the map and being reported, you can add a Failure transform to the transform group. The Failure transform is an optional transform in each of the database transform groups, and can be added or removed as required. If an exception is raised by the configured database server, and you have not configured a corresponding Failure transform, the map operation is stopped.
To add a Failure transform to a graphical data map by using the Graphical Data Mapping editor, complete the following steps:
Procedure
Results
You have added and configured a Failure transform into your graphical data map. If you want the failure to cause the execution of the map to stop when the database transform receives an SQL exception, remove the Failure from the transform.
What to do next
- Set up a JDBC connection to the database that you want to access. For more information, see Enabling JDBC connections to the databases.