iBatis (MyBatis) Macro 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) Macro Wizard wraps a macro into an iBatis 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) Macro Wizard from the Data Source Explorer by right-clicking a Macros node and selecting Teradata > Create iBatis(MyBatis) SQL Map.


Macro Selection

After you launch the iBatis (MyBatis) Macro Wizard, the Macro Selection Wizard dialog opens. The dialog enables you to select the database and macro for the Java Bean Wrapper Class.


Creating an iBatis SQL Mapping XML File

The Create iBatis SQL Mapping XML File dialog lets you define the location, name of the SQL mapping file, and the mapping name for the selected macro. 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 SQL mapping.


Edit Classes

The Edit Classes dialog lets you rename and edit the properties for the iBatis Bean classes that are created by the wizard.


The dialog shows the parameter classes and any result set classes derived from the macro. 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 this option from the iBatis (MyBatis) Macro Wizard. The iBatis (MyBatis) DAO with Web Services Wizard creates a DAO and a Web Service from the generated SQL XML Map using the criteria you select in the iBatis DAO Definition Page.