Use the sqlj.setUDTextName( ) procedure to define the mapping between a user-defined data type and a Java class.
sqlj.SetUDTextName: |--sqlj.SetUDTextName-------------------------------------------> .-----------------. V | >--(--data_type--,----+-------------+-+--class_id--)------------| '-package_id,-'
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| class_id | Java class that contains the Java data type | Qualified name package_id.class_id must not exceed 255 bytes | Language-specific rules for Java identifiers |
| data_type | User-defined type for which to create a mapping | Name must not exceed 255 bytes | Identifier |
| package_id | Name of package that contains the class_id Java class | Same length restrictions as class_id | Language-specific rules for Java identifiers |
You must have registered the user-defined data type in the CREATE DISTINCT TYPE, CREATE OPAQUE TYPE, or CREATE ROW TYPE statement.
To look up the Java class for a user-defined data type, the database server searches in the jar-file path, which the sqlj.alter_java_path( ) procedure has specified. For more information on the jar-file path, see sqlj.alter_java_path.
On the client side, the driver looks into the CLASSPATH path on the client environment before it asks the database server for the name of the Java class.
The setUDTextName procedure is an extension to the SQLJ:SQL Routines using the Java Programming Language specification.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]