WebSphere Adapter for JDBC

Discovery of system capabilities

For business object generation based on tables, views, stored procedures, and synonyms/nicknames, enterprise services discovery analyzes the database to identify the schemas. Then the wizard creates a list of all the objects from the database and shows it as a tree structure. You can select any discovered database object to generate a business object. You can also generate query business objects from user-specified select statements.

The schemas are displayed as the top-level nodes in the tree. The schema nodes are not selectable for generation. Under each schema are nodes labeled Tables, Views, Stored Procedures, and Synonyms/Nicknames. These nodes are not selectable for generation. The objects listed under these nodes are the names of the tables, views, stored procedures, and synonyms/nicknames for the particular schema. These nodes are marked as selectable for generation. If no tables, views, stored procedures, or synonyms exist for a particular schema, none are listed.

Filter schemas, node types, and database objects

Before the tree is generated and displayed, you can specify filter properties if you want to narrow the list of schemas displayed in the tree or node types displayed under each schema; otherwise, all schemas and node types are displayed. The SchemaNameFilter property is used to filter schemas, and the Types property is used to filter node types. In addition, you can use the properties DefineASI, QueryBO, and QueryBOCount during object selection. "Filter and node properties" in the "Reference" section describes these properties.

You can select a tables, views, stored procedures, or synonyms/nicknames node, then click Filter, and the enterprise service discovery wizard queries for an ObjectNameFilter. You can use the ObjectNameFilter property to filter the list of database objects to display. "Filter and node properties" in the "Reference" section describes the ObjectNameFilter property.

Generate query business objects from user-specified select statements

To generate query business objects from user-specified select statements, select the QueryBO property and set the QueryBOCount to the maximum number of query business objects that can be generated at one time. Then when you run the query to display the tree, you see a new top-level "Query Statements" node along with some schema top-level nodes. Query Statements is not selectable for generation. When you expand this node, then nodes with labels such as "Select Statement 1" and "Select Statement 2" are displayed up to the QueryBOCount number of nodes. These nodes are selectable for generation of query business objects.


Terms of use |

Last updated: Tue 12 Dec 2006 03:32:38

(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)