Setting up the database

About this task
You need the following tables for the Cash Drawer Management sample application:

All of these tables are in a database called BTF by default. You must create each table using the provided scripts.

The following diagram shows the relationship between the tables:

Diagram showing the tables relationships

By default, any of the scripts that create the tables for the Bank Teller Sample first creates the database to contain the tables. The default name of the database is BTF. The scripts is specific to Windows® operating system, and database management system, such as DB2® or Oracle.

To create all the tables required by the Cash Drawer Management sample application, follow these steps:

  1. Make sure the database drivers JAR files are available in the classpath. If you use DB2, the database drivers JAR files are db2jcc.jar, db2jcc_license_cisuz.jar and db2jcc_license_cu.jar.
  2. Locate the table script in <toolkit_root>/lib/dbtools/Windows/ directory. DB2 and Oracle are supported.
  3. Start your database management system.
  4. Execute the script file at a command prompt.
  5. Verify that the scripts have generated the following tables in your DBMS.
    Table 1. Created Tables
    Component Created Tables
    Cash Drawer Management

    BTF.CDMCASHDRAWER

    BTF.CDMCASHTRAY

    BTF.CDMTOTAL

    BTF.CDMBIN

    BTF.CDMBATCH

    BTF.CDMDENOMINATION