Database Table Mapping

Many Branch Transformation Toolkit applications access existing database tables to retrieve or update information. The Database Table Mapping service enables any application to connect to a specific database and use an existing table within the database. It implements a common application interface that integrates the different database access services provided by the toolkit, thus making application development simpler.

Because this service is for use with existing database tables, it has the following two characteristics that make it different from the other database services provided by the toolkit:

  1. There is no class to create the tables. However, the toolkit does provide the JDBCServicesAdministrator class to register and drop stored database procedures. A JDBCTable instance may later run theses procedures.
  2. An application using this service must properly set the primary key column value for any record to be inserted in the database table.

The concrete database access class JDBCTable provides the methods to access a database table. This class implements the TableService interface and extends the JDBCService class, which implements the interface DatabaseConnect, including all methods related to the database connection. The JDBCTable class can be subclassed if additional functionality is required. The current implementation, as its name indicates, uses the JDBC interface.