DDL Generation › How to Install DDL Using the JDBC Technical Design › Set Up the Build Tool

Set Up the Build Tool

On your Windows system, start the CA Gen Build Tool to define the following tokens to set up the Build Tool.

Follow these steps:

1. Open the profile in the Profile Manager.
2. Expand DBMS.
3. Select JDBC.
4. Set OPT.DBUSER and OPT.DBPSWD as appropriate to access the target database.
5. The values for the next three tokens vary by JDBC driver. To determine the values to be entered into the Build Tool, see the documentation for your JDBC driver.
   • Set OPT.DBCONNECT to the JDBC connection string for the target database. For example:

     jdbc:oracle:thin:@myhost:1521:database

   • Set LOC.JDBCDRIVERS to the driver manager class name to be loaded by the Build Tool before connecting to the JDBC DBMS for DDL installation. For example:

     oracle.jdbc.driver.OracleDriver

   • Set LOC.JDBCDRIVERSCLASSPATH to the disk, directory, and ZIP or JAR file name where the JDBC Driver is located. For example:

     c:\oracle\jdbc\lib\classes12.zip