there may be two issues here. 1) does the rendering use the entity value or the field def as the primary len for a display field. this is definately something to discuss here. 2) Most db work with ofbiz and the 20 char length is not a problem. So this leaves DB problem at the driver level. This is not a ofbiz problem and should be covered in the db2 support groups.
guo weizhan sent the following on 2/21/2008 12:05 AM: > any body can help this? > > the findContent page thrown this exception if the contentName is more then > 20 but the edit page is fine.... > > 2008/1/31, guo weizhan <[EMAIL PROTECTED]>: >> it's maybe not what your think, I test the description of Example >> component and it can work. >> >> 2008/1/31, BJ Freeman <[EMAIL PROTECTED]>: >>> check with the db2 folks, it may be a limit of the db. >>> if so besure to change you fieldtype.xml so you don't have any fields >>> longer than 20. >>> this will probably mean you can't use the demo data. >>> >>> guo weizhan sent the following on 1/31/2008 1:11 AM: >>>> Hi All, I found the problem when I got the data from content table( >>> DB2 as >>>> the database), if thrown this exception: >>>> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen >>>> [component://common/widget/CommonScreens.xml#GlobalDecorator]: >>>> java.lang.IllegalArgumentException: Error getting value from the >>> database >>>> for display of field [contentName] on form [ListContent]: >>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while >>> executing >>>> the following:SELECT CONTENT_TYPE_ID, OWNER_CONTENT_ID, >>>> DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, >>>> TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, >>> PRIVILEGE_ENUM_ID, >>>> SERVICE_NAME, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, >>>> CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, >>>> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, >>> LAST_MODIFIED_BY_USER_LOGIN, >>>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, >>> CREATED_TX_STAMP >>>> FROM OFBIZ.CONTENT WHERE CONTENT_ID=? (DB2 SQL error: SQLCODE: -302, >>>> SQLSTATE: 22001, SQLERRMC: null) (Error getting value from the >>> database for >>>> display of field [contentName] on form [ListContent]: >>>> org.ofbiz.entity.GenericDataSourceException: SQL Exception while >>> executing >>>> the following:SELECT CONTENT_TYPE_ID, OWNER_CONTENT_ID, >>>> DECORATOR_CONTENT_ID, INSTANCE_OF_CONTENT_ID, DATA_RESOURCE_ID, >>>> TEMPLATE_DATA_RESOURCE_ID, DATA_SOURCE_ID, STATUS_ID, >>> PRIVILEGE_ENUM_ID, >>>> SERVICE_NAME, CONTENT_NAME, DESCRIPTION, LOCALE_STRING, MIME_TYPE_ID, >>>> CHARACTER_SET_ID, CHILD_LEAF_COUNT, CHILD_BRANCH_COUNT, CREATED_DATE, >>>> CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, >>> LAST_MODIFIED_BY_USER_LOGIN, >>>> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, >>> CREATED_TX_STAMP >>>> FROM OFBIZ.CONTENT WHERE CONTENT_ID=? (DB2 SQL error: SQLCODE: -302, >>>> SQLSTATE: 22001, SQLERRMC: null)) >>>> >>>> I digg in this and found the reason: It'll thrown this exeception if >>> the >>>> length of contentName is more then 20, it work fine if not. >>>> >>>> Why??? >>>> >>> >
