By JeffG-Oracle on Dec 03, 2013
How does one do modifications to the Integration Interface from the database? Is there a java class that can be used for this?
Looking to avoid logging into the Business Modeller to perform these modifications?
1) The interface tables in the database are a set of tables starting with "Transfer_", while transfer_query is the main one. There are separate tables for series, levels, filter etc.
2) I do not believe there is a Java class for this.
3) A Java servelet is triggered when an Integration interface is modified through business modeler so that an application server bounce is not required. This servelet is specific to integration interfaces only.
4) Any update to the "transfer_xxx" table(s) would need application server bounce.
As per my knowledge, logging into Business modeler and modifying is the recommended option, mainly where multiple tables in the database get updated.