Skip Navigation Links | |
Exit Print View | |
![]() |
Developing OTDs for Oracle Java CAPS Database Adapters Java CAPS Documentation |
Generating ResultSet Nodes of a Stored Procedure
DB2 Database Configuration Information
DB2 Database Connectivity Information
DB2 Connect Database Connection Information
JDBC Database Connection Information
Informix Database Connection Information
Oracle Database Connection Information
SQL Server Database Connectivity Information
Sybase Database Connectivity Information
VSAM Database Connectivity Information
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, Stored Procedures, or Prepared 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. Each of the database adapters below provides additional support, such as the Sybase adapter which supports double-byte character set (DBCS). The DBCS is a set of characters in which each character is represented by 2 bytes. The Korean language requires double-byte character sets.
The following sections provide information and instructions on how to create a database OTD.
What You Need to Know
The following topics provide information you should know before creating an OTD for your database type.
What You Need to Do
The following topics provide instructions for creating and editing Database OTDs.