The column types listed in this information center show the WebSphere Commerce database schema for DB2 for workstations. The following table provides equivalent column types for operating systems and databases supported by WebSphere Commerce.
Notes:
In the CATENTDESC table, the AUXDESCRIPTION2 field is VARGRAPHIC(3000) ALLOCATE() CCSID 13488.
As a result of inconsistent rates of success for when the Oracle JDBC driver handles information that is of the LONG data type, it is recommended that you avoid using the LONG data type whenever possible. The most commonly reported error in this situation is the "Stream has already been closed" error.
- If you must use this datatype, you can only have one column per database table that uses the LONG type. In addition, when constructing a select statement, do not put the LONG column as either the first or last element in the select. Another workaround for operations under a heavy load is to avoid mapping this particular column to a CMP field in an entity bean. Instead, use a session bean to perform retrieves and updates on this column.