JDBC Connect User's Guide

APPENDIX A

JDBC Glossary

Connection Pool    A set of database connections managed by the application server for the various applications it manages.

Custom Result Mapping   The Custom Result Mapping dialog provides a similar alias ability for repeating rows in SQL result sets as the Declare Group and Repeat for Group actions do for repeating elements in a document.

Declare Group/Repeat Tab    This tab of the Custom Results Mapping dialog is used to create groups of result set records on one or more result set columns, create a Group Alias to use as a Context for Detail Rows, and create a Group Alias to use as a Context for Map Targets (creating Group Headers).

Detail Rows Tab    This tab of the Custom Results Mapping dialog allows you to create a mapping alias tied to either a document Context or a Group/Repeat alias Context. Use of the Detail Rows tab is optional.

DOM   A Document Object Model (DOM) is an XML document constructed as an object in a software program's memory. It provides standard methods for manipulating the object. In Composer, DOM is often synonymous with XML Document. DOMs are represented as hierarchical trees with a single root node.

DOM Context   The name of a DOM (Input, Output, Temp, etc.), or the name of a Repeat alias previously defined in the component. (The alias itself represents a DOM context, representing the nodepath hierarchy upstream of a given element.)

Execute SQL Action   Same as SQL Statement Action.

JDBC   A Sun trademark for the Java API for accessing relational database data. It is commonly assumed to mean Java Database Connectivity.

Map Target Tab    This tab of the Custom Results Mapping dialog is used to create target element names for each result set column and specify a target Context for each result set column.

Native Environment Pane    A pane in the JDBC Component Editor that simulates an actual SQL environment when you issue a query.

Query/Result Mapping Pane   (Same as the Native Environment Pane.) A pane in the JDBC Component Editor that includes three tabs: the SQL Statement tab, the Result Mapping tab, and the Results Text tab.

Result Mapping Tab   A tab in the Query/Result Mapping Pane that allows you to map the result of your database query to an XML document.

Result Text Tab    A tab in the Query/Result Mapping Pane that displays the actual data that was returned following the execution of the database query.

Row Target   The receiving element in a mapping operation is called the row target. It represents a specific position in the DOM tree of an XML file.

SQL Statement Action    Most commonly used to query an existing database and then map the result to an XML document.

SQL Statement Tab    A tab in the Query/Result Mapping Pane that allows you to write or build SQL commands.

SQLCODE   A global ECMAScript variable created by the execution of SQL statements. Contains a status code generated by the database engine.

SQLSTATE   A global ECMAScript variable created by the execution of SQL statements. Contains information generated by the database engine.

UPDATECOUNT   A global ECMAScript variable created by the execution of SQL statements. Contains a count of the number of rows changed by the database engine.



Copyright © 2004 Novell, Inc. All rights reserved. Copyright © 1997, 1998, 1999, 2000, 2001, 2002, 2003 SilverStream Software, LLC. All rights reserved.  more ...