You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by guo weizhan <gu...@gmail.com> on 2008/02/21 09:05:50 UTC
Re: Error getting value from the database for display of field [contentName] on form [ListContent]
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 <gu...@gmail.com>:
>
> it's maybe not what your think, I test the description of Example
> component and it can work.
>
> 2008/1/31, BJ Freeman <bj...@free-man.net>:
> >
> > 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???
> > >
> >
> >
>
Re: Error getting value from the database for display of field [contentName] on form [ListContent]
Posted by guo weizhan <gu...@gmail.com>.
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 <gu...@gmail.com>:
>
> 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 <gu...@gmail.com>:
> >
> > it's maybe not what your think, I test the description of Example
> > component and it can work.
> >
> > 2008/1/31, BJ Freeman <bj...@free-man.net>:
> > >
> > > 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???
> > > >
> > >
> > >
> >
>
Re: Error getting value from the database for display of field [contentName]
on form [ListContent]
Posted by BJ Freeman <bj...@free-man.net>.
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 <gu...@gmail.com>:
>> it's maybe not what your think, I test the description of Example
>> component and it can work.
>>
>> 2008/1/31, BJ Freeman <bj...@free-man.net>:
>>> 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???
>>>>
>>>
>