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