it seems cause by:
<display-entity entity-name="Content" description="${contentName}"
key-field-name="contentId">
<sub-hyperlink target="editContent?contentId=${contentId}"
description="[${contentId}]" link-style="buttontext"/>
</display-entity>
in the ContentForms.xml, how this work? why the length of contentName is
more than 20 will cause this exeception?
2008/2/21, guo weizhan <[EMAIL PROTECTED]>:
>
> 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???
> > > >
> > >
> > >
> >
>
