How do I use Query Tables?

How do I use Query Tables?

The query name is used to map the finder methods when entity beans are defined or deployed. To add tables from the Available tables list, click the >> button. To delete tables from the Selected tables list, click the << button.

How do I specify Output Fields?

When you click Next after selecting the tables, a screen is displayed for specifying the output fields.

Select the mode as either Distinct or All, and modify the Variable Name using the editable field. Click Next.

How do I use Search Criteria?

The Specify search criteria panel is used to create a search criterion for a query.

Note: This is the first screen in the Query Wizard when it is invoked using Bean Wizard. The table and resource to be used is already selected.

Click Prev to modify the following settings:

• Field 1: Specifies the database field name
• Field 2: Provides the following options as the second argument:
  • Field: Specifies the database field
  • Subquery: Selecting subquery activates a drop-down list using which you can select a subquery
  • Literal: Specifies a literal expression in the query
  • Parameter: Specifies a user-defined value in the query
• Operator: Provides a drop-down list with options such as:
  • Comparison: Includes all the comparative operators
  • Range: Includes BETWEEN and NOT BETWEEN
  • Pattern: Includes LIKE and NOT LIKE
  • List: Includes IN and NOT IN
  • Value: Includes IS NULL and IS NOT NULL

Specify an operator and add the defined search criterion to the WHERE clause table by clicking Add. When you add more than one clause, the first column in the displays an and/or toggle text. Click this text to join all the clauses.

To delete a search criterion, click Delete.

If the query contains a parameter that is provided at run time, the Query Results tab will not display the results.

How do I use Output Fields and Sorted Query Results?

This panel displays the options for selecting the output fields and the sorting order for the query results.

This screen provides the following options:

• All: Displays all the occurrences in the output if database rows are returned several times by various search criteria
• Distinct: Displays only one database row in the output
• Sort Result By: Specifies the field on which to sort. Click a field name from the list and click the right arrow button to add it to the Field name table. The ascending/descending toggle sets the sort order.

How do I view generated Queries?

Click Finish to generate the query.

How do I modify SQL Queries?

Return to the screen where you defined the query by clicking Prev and modify the query as required.

Related Topics:

• How do I write SQL Queries for EJBs?
• How do I manage Database Connectivity?
• How do I use Query Tables?
• How do I use Query Viewer?
• How do I compile EJB QL Queries?

© Pramati Technologies 2007	Runs on Pramati Server | Feedback | Legal