iBatis (MyBatis) Stored Procedure Wizard - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

The iBatis (MyBatis) Stored Procedure Wizard wraps a stored procedure into an iBatis or MyBatis SQL Map. The generated SQL map can be used to create a Web Service or to create a Java application that uses the iBatis or MyBatis framework.

Launching the Wizard

You launch the iBatis (MyBatis) Stored Procedure Wizard from the Data Source Explorer by right-clicking on a Stored Procedures node and selecting Teradata > Create iBatis (MyBatis) SQL Map.

Stored Procedure Selection

After you launch the iBatis (MyBatis) Stored Procedure Wizard, the Stored Procedure Selection wizard dialog opens. The dialog enables you to select the database and stored procedure to wrap.

Creating an iBatis SQL Mapping XML File

The Create iBatis SQL Mapping XML File dialog lets you define the location, name of the iBatis SQL mapping file, and the mapping name for the selected stored procedure. The default is to append the mapping to an existing file.

Domain Objects Source Location

The Domain Objects Source Location dialog lets you define the location and package name of the domain object used as the result map for an iBatis SQL mapping.

Edit Classes

The Edit Classes dialog lets you rename and edit the properties for the classes that are created by the wizard.
The dialog shows the parameter classes and any result set classes derived from the stored procedure. You can rename any default class names to names that make sense for your application.

Generated Code

After you enter all required information in the wizard, click Finish to generate the SQL Map.

iBatis (MyBatis) DAO with Web Services Wizard

The iBatis (MyBatis) DAO with Web Services Wizard launches if you selected from the option from the iBatis Stored Procedure Wizard. The iBatis (MyBatis) DAO with Web Services Wizard creates a DAO and a Web Service derived from the generated iBatis SQL Map.