Sun Microsystems eWay JDBC/ODBC Adapter - Manual (Page 41)

JDBC/ODBC eWay Adapter User’s Guide 41 Sun Microsystems, Inc.
Chapter 4
Using the JDBC/ODBC eWay Database
Wizard
This chapter describes how to use the JDBC eWay Database Wizard to build OTDs.
What’s In This Chapter:
ƒ About the Database OTD Wizard on page 41
ƒ Creating a New JDBC OTD on page 41
ƒ Steps to Edit an Existing JDBC OTD on page 56
4.1
About the Database OTD Wizard
The Database OTD Wizard generates OTDs by connecting to external data sources and
creating corresponding Object Type Definitions. The OTD Wizard can create OTDs
based on any combination of Tables and Stored Procedures or Prepared SQL
Statements.
Field nodes are added to the OTD based on the Tables in the external data source. Java
method and parameter nodes are added to provide the appropriate JDBC functionality.
For more information about the Java methods, refer to your JDBC developer’s
reference.
The OTD Wizard allows the addition and removal of columns/nodes in an OTD.
Nodes with the same name and type as existing nodes are allowed by the wizard, but
should not be created, and will result in generic code generation errors upon activation
of the OTD.
Note: Database OTDs are not messagable. For more information on messagable OTDs, see
the eGate Integrator User’s Guide.
4.2
Creating a New JDBC OTD
The following steps are required to create a new OTD for the JDBC Adapter.
ƒ Select Wizard Type on page 42