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