iBatis View Web Service 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 View Web Service Wizard generates an iBatis SQL Map that performs SELECT statements on a selected View object. The SELECT statements have different search criteria depending on what you specify in the wizard.

Launching the Wizard

To launch the iBatis View Web Service Wizard from the Data Source Explorer, right-click a Views node and select Create an iBatis View Web Service.

iBatis View Web Service Wizard

The first screen of the wizard lets you specify the location and name of the iBatis SQL Map to generate.
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 allows 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 sets the Search criteria for the generated SQL statements.

Generated Code

After you enter all required information, 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 select this option from the iBatis View Web Service Wizard. The 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 iBatis SQL Map per package if you are using Web Services.