WebSphere Adapter for JDBC
You use the enterprise service discovery wizard in the WebSphere® Adapter for JDBC to discover objects in a database and to generate business objects from the selected objects. Enterprise service discovery support also generates the service artifacts that enable the adapter to run as a Service Component Architecture (SCA) component.
You can use the enterprise service discovery wizard to generate business objects from three types of objects in a database. The first type of object includes tables and views, while the second type includes stored procedures and synonyms/nicknames. The third type of object is the query business object, generated from a user-specified select statement.
For the first and second types of objects in the database, enterprise service discovery enables you to discover the objects by generating a list of all the schemas in the database. Within each schema are lists of tables, views, stored procedures, and synonyms/nicknames that you can select, and for which you request the enterprise service discovery wizard to generate the corresponding business objects. The wizard analyzes the metadata of the selected objects and generates attributes in the business objects. The attributes are generated based on the columns of the selected database objects.
For the third type of object, the query business object, you specify one select statement. You need to specify the business object name, and the types and dummy values of all the parameters in the where clause. Enterprise service discovery runs this user-specified select statement and analyzes the metadata of the returned result set to obtain the list of columns and their types. After obtaining this information, enterprise service discovery generates one query business object for this user-specified select statement.
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)