the length of the
<field-type-def type="id-ne" sql-type="VARCHAR(20)"
java-type="String"><validate method="isNotEmpty" /></field-type-def>
is defined in the field type for each dB.
it is best not to change this unless you know you db and how it would
effect other fields in the entity.
however this is not a bug
Yin T (JIRA) sent the following on 11/12/2007 10:43 AM:
> Cannot create a category for a catalog
> --------------------------------------
>
> Key: OFBIZ-1399
> URL: https://issues.apache.org/jira/browse/OFBIZ-1399
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: OpenSuse 10.3
> Eclipse3.3
> SVN trunk sources downloaded on Nov 12,2007
>
> java version "1.6.0_03"
> Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
> Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode)
>
>
> Reporter: Yin T
>
>
> goto https://localhost:8443/catalog/control/main
>
> click "Catalog" menuitem in application bar.
> create new catalog.
> associated new catalog with "OFBiz E-Commerce Store"
> create new product category
>
> Received the following error message on the page...
>
> The Following Errors Occurred:
>
> ERROR: Could not complete the Add Category To ProdCatalog
> [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog]
> process [problem creating the newEntity value: Error while inserting:
> [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12
> 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12
> 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12
> 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12
> 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12
> 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID,
> PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU
_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was
encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))]
>
>
