Attribute properties

This section describes the properties that JDBCODA generates for each attribute. For more information about the attributes, see Business object attribute properties.

Name property

JDBCODA obtains the value of the attribute's name from the column name in the database table or view.

Data type property

When setting the type of an attribute, JDBCODA converts the data type of a column in the table or view to a corresponding IBM WebSphere Business Integration Adapter Business Object type. This conversion is done in two steps. First, the data type in the database is converted to a JDBC type. Then, the JDBC type is converted to an IBM WebSphere Business Integration Adapter Business Object type. The first conversion is done by the JDBC driver that you are using. Please refer to the JDBC specification (2.0 and above) for details on individual database type mapping to a JDBC type. Table 14 shows the conversion from the JDBC Type to the corresponding IBM WebSphere Business Integration Adapter Business Object type.

Table 12. Correspondence of data types
JDBC type WebSphere Business Integration Adapter business object type
BIT
   
BOOLEAN
   
CHAR
   
STRING
   
VARCHAR
   
STRING
   
LONGVARCHAR
   
STRING
   
INTEGER
   
INTEGER
   
NUMERIC
   
INTEGER
   
SMALLINT
   
INTEGER
   
TINYINT
   
INTEGER
   
BIGINT
   
INTEGER
   
DATE
   
DATE
   
TIME
   
DATE
   
TIMESTAMP
   
DATE
   
DECIMAL
   
STRING
   
DOUBLE
   
DOUBLE
   
FLOAT
   
DOUBLE
   
REAL
   
FLOAT
   
BINARY
   
STRING,
   

add

BYTEARRAY=TRUE
   

to

AppSpecificInfo
   
VARBINARY
   
STRING,
   

add

BYTEARRAY=TRUE
   

to

AppSpecificInfo
   

Note:
If a column's data type is not one of those shown in Table 12, JDBCODA skips the column and displays a message stating that the column cannot be processed.

Cardinality property

JDBCODA sets the cardinality of all simple attributes to 1.

MaxLength property

JDBCODA obtains the length of a string from the length specified for the varchar, char, or text data type.

IsKey property

If the column is a primary key in the table, JDBCODA marks it as a key attribute. However, if a view, instead of a table, is selected as the source node to generate Business Objects, JDBCODA does not mark the column as a key attribute. In this case, the key attribute needs to be set manually.

IsForeignKey property

JDBCODA does not set the IsForeignKey property. You can set it in Business Object Designer Express.

IsRequired property

If a field is designated not null in the table or view, JDBCODA marks it as a required attribute. However, JDBCODA does not mark the key field as required because there may be a sequence associated with it, or it may be an identity column.

AppSpecificInfo property

JDBCODA includes two parameters for the AppSpecificInfo property at the attribute level. The syntax of the specified parameters are:

CN=ColumnName
   

where ColumnName is the name of the column in the database table or view associated with the specific attribute.

BYTEARRAY=true|false
   

JDBCODA recognizes columns with binary data and creates an attribute of type String with an AppSpecificInfo property of BYTEARRAY=true.

Note:
You can set additional AppSpecificInfo parameters in Business Object Designer Express. For information about these parameters, see Application-specific information at the attribute level.

Copyright IBM Corp. 1997, 2003