Creating a Custom Type Map

You may need to employ a custom type map if you are using a Oracle8i Lite or a standards-based SQL type (SQL92), and are connecting to databases that uses enhanced data types.

To create a custom type map:

1. From the File menu, choose New.

2. In the Object Gallery, click Class, and then OK.

3. In the Class Wizard, name the type map class.

4. Accept the default values for the remaining fields and click OK.

   (The Extends field should contain java.lang.Object, the Public and Generate constructor checkboxes should be selected.)

5. Add the following import statements:

   import oracle.jbo.common.JboTypeMap;
   import java.sql.*;

6. Click OK to generate your skeleton class.

7. Add code to map your Java types to SQL types. A sample type map class is provided.