Error getting value from the database for display of field [contentName] on form [ListContent]

[guo weizhan]

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

[BJ Freeman]

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

[guo weizhan]

it's maybe not what your think, I test the description of Example component
and  it can work.

2008/1/31, BJ Freeman <[hidden email]>:

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

[guo weizhan]

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 <[hidden email]>:

>
> it's maybe not what your think, I test the description of Example
> component and  it can work.
>
> 2008/1/31, BJ Freeman <[hidden email]>:
> >
> > 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???
> > >
> >
> >
>

[guo weizhan]

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 <[hidden email]>:

>
> 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 <[hidden email]>:
> >
> > it's maybe not what your think, I test the description of Example
> > component and  it can work.
> >
> > 2008/1/31, BJ Freeman <[hidden email]>:
> > >
> > > 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???
> > > >
> > >
> > >
> >
>

[BJ Freeman]

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 <[hidden email]>:
>> it's maybe not what your think, I test the description of Example
>> component and  it can work.
>>
>> 2008/1/31, BJ Freeman <[hidden email]>:
>>> 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???
>>>>
>>>
>