iBatis CRUD Wizard - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
The iBatis CRUD Wizard generates an iBatis SQL Map that performs CRUD operations on a database table. CRUD is an acronym defined by the following functions of persistent storage:
  • Create - Inserts a row into a Database Table
  • Read - Selects information from a Database Table
  • Update - Updates a row for a Database Table
  • Delete - Removes a row from a Database Table

Launching the Wizard

To launch the iBatis CRUD Wizard from the Data Source Explorer, right-click a Tables node and select Create a CRUD iBatis SQL Map.

iBatis CRUD Wizard

The first screen of the Wizard lets you specify the location and name of the iBatis SQL Map to generate. It also specifies the options for the CRUD operations used in the iBatis SQL Map.
The Domain Object Class Specification dialog lets you specify the location and name of the Domain Object class to generate. It also specifies the options for the creation of the Domain Object.
The Domain Object Members Specification dialog allows you to modify the domain object members that represent the columns of the selected table. The first column displays the member names which you can modify. The second column shows the SQL type of the member. The third column shows the Java data type of the SQL type of the original column the Java member represents. The fourth column of the table sets search criteria for Read, Update and Delete CRUD operations.

Generated Code

After you enter all required information in the wizard, click Finish. The wizard generates the iBatis SQL Map.

iBatis DAO with Web Services Wizard

The iBatis DAO with Web Services Wizard is launched if you selected this option in the iBatis CRUD Wizard. This wizard creates a DAO and a Web Service derived from the generated iBatis SQL Map.
As a best practice, create only one Web Service per Project. Teradata recommends that you use only one CRUD iBatis SQL Map per package if you are using Web Services.