+

Search Tips   |   Advanced Search

 

dbquery tag JavaServer Pages syntax (deprecated)

 

Use the <tsx:dbquery> tag to establish a connection to a database, submit database queries, and return the results set.

Support for tsx tags in the JavaServer Pages engine are deprecated in WAS V6.0. Instead of using the tsx tags, you should use equivalent tags from the JavaServer Pages Standard Tag Library (JSTL).

The <tsx:dbquery> tag does the following:

  1. References a <tsx:dbconnect> tag in the same JavaServer Pages file and uses the information the tag provides to determine the database URL and driver. You can also obtain the user ID and password from the <tsx:dbconnect> tag if those values are provided in the <tsx:dbconnect> tag.

  2. Establishes a new connection

  3. Retrieves and caches data in the results object.

  4. Closes the connection and releases the connection resource.

This section describes the syntax of the <tsx:dbquery> tag.

<%-- SELECT commands and (optional) JSP syntax can be placed within the tsx:dbquery. --%>
<%-- Any other syntax, including HTML comments, are not valid. --%>
<tsx:dbquery id="query_id" connection="connection_id" limit="value" >
</tsx:dbquery>

where:




 

Related concepts


JavaServer Pages

 

Related tasks


Use installed optional packages
Manage shared libraries

 

Related Reference


Web applications: Resources for learning

 

Reference topic