Use the Query property editor to specify the value of the query property
for a Select bean.
Pages
Use the Connection page of the Query property editor to create a connection
alias for a Select bean or to select an existing connection alias.
Fields
- Database Access Class names a database access class. The
format of the database access class is
packagename.classname, where packagename is
the name of the package that contains the database access class, and
classname, is the name of the class. Select from the list, the
database access class that you want to use for the connection alias.
- Connections names the connection aliases that are in the
selected database access class. Select from the list, the connection
alias that you want to use for the Select bean.
- URL is a read-only field that shows the URL specified in the
definition of the selected connection alias.
Push buttons
- New defines a new database access class and adds it to the
Database Access Class list.
- Add defines a connection alias and adds it to the Connections
list.
- Edit edits the definition of a connection alias in the
Connections list.
- Remove removes a connection alias from the Connections
list.
Use the SQL page of the Query property editor to create an SQL
specification for a Select bean or to select an existing SQL
specification.
Fields
- Database Access Class names a database access class. The
format of the database access class is
packagename.classname, where packagename is
the name of the package that contains the database access class, and
classname, is the name of the class. Select from the list, the
database access class that you want to use for the SQL specification.
- SQL names the SQL specifications that are in the selected
database access class. Select from the list, the SQL specification that
you want to use for the Select bean.
- SQL Statement is a read-only field that shows the SQL statement
for the selected SQL specification
Push buttons
- New defines a new database access class and adds it to the
Database Access Class list.
- Add defines an SQL specification and adds it to the SQL
list.
- Edit edits an SQL specification.
- Remove removes an SQL specification from the SQL list.
Specifying a Connection Alias
Making an SQL Specification
