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??? >
