Column 'APP_NAME' cannot accept a NULL value

["Hu, Yiguang" <Yi...@stercomm.com>]

I am seeing these these when click a psml link: I copied the petstore
portlet.xml and changed the app id. It seems complain some attribute
APP_NAME not defined. But my portlet.xml is pretty much just like one in
the jpetstore. Which attribute is missing for this problem?

Thanks

 

Failed to retrieve Portlet Definition for ptmstruts::xPtmstrutsFailed to
retrieve Portlet Definition for
ptmstruts::xPtmstrutsjava.lang.IllegalArgumentException: Cannot pass a
null PortletDefinition to a PortletEntity.Failed to retrieve Portlet
Definition for ptmstruts::xPtmstrutsFailed to retrieve Portlet
Definition for ptmstruts::xPtmstruts

 

The Jetspeed log:

 

Caused by: java.io.IOException: Failed to store portlet
entity:org.springframework.dao.DataIntegrityViolationException: (OJB
operation): data integrity violated by SQL ''; nested exception is
org.apache.derby.impl.jdbc.EmbedSQLException: Column 'APP_NAME'  cannot
accept a NULL value.

        at
org.apache.jetspeed.components.portletentity.PersistenceBrokerPortletEnt
ityAccess.storePreferenceSet(PersistenceBrokerPortletEntityAccess.java:3
55)

        at
org.apache.jetspeed.components.portletentity.PortletEntityImpl.store(Por
tletEntityImpl.java:253)

        at
org.apache.jetspeed.components.portletentity.PortletEntityImpl.store(Por
tletEntityImpl.java:241)

        at
org.apache.jetspeed.components.portletentity.PersistenceBrokerPortletEnt
ityAccess.storePortletEntity(PersistenceBrokerPortletEntityAccess.java:3
22)

        ... 105 more

Caused by: org.springframework.dao.DataIntegrityViolationException: (OJB
operation): data integrity violated by SQL ''; nested exception is
org.apache.derby.impl.jdbc.EmbedSQLException: Column 'APP_NAME'  cannot
accept a NULL value.

        at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translat
e(SQLStateSQLExceptionTranslator.java:93)

        at
org.springframework.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAc
cessor.java:107)

        at
org.springframework.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAcc
essor.java:89)

        at
org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(Persistenc
eBrokerTemplate.java:170)

        at
org.springframework.orm.ojb.PersistenceBrokerTemplate.store(PersistenceB
rokerTemplate.java:265)

        at
org.apache.jetspeed.components.portletentity.PersistenceBrokerPortletEnt
ityAccess.storePreferenceSet(PersistenceBrokerPortletEntityAccess.java:3
45)

Re: Column 'APP_NAME' cannot accept a NULL value

[David Sean Taylor <da...@bluesunrise.com>]

Hu, Yiguang wrote:
> I am seeing these these when click a psml link: I copied the petstore
> portlet.xml and changed the app id. It seems complain some attribute
> APP_NAME not defined. But my portlet.xml is pretty much just like one in
> the jpetstore. Which attribute is missing for this problem?
> 
> Thanks
> 
>  
> 
> Failed to retrieve Portlet Definition for ptmstruts::xPtmstrutsFailed to
> retrieve Portlet Definition for
> ptmstruts::xPtmstrutsjava.lang.IllegalArgumentException: Cannot pass a
> null PortletDefinition to a PortletEntity.Failed to retrieve Portlet
> Definition for ptmstruts::xPtmstrutsFailed to retrieve Portlet
> Definition for ptmstruts::xPtmstruts
> 
>  
> 
> The Jetspeed log:
> 
>  
> 
> Caused by: java.io.IOException: Failed to store portlet
> entity:org.springframework.dao.DataIntegrityViolationException: (OJB
> operation): data integrity violated by SQL ''; nested exception is
> org.apache.derby.impl.jdbc.EmbedSQLException: Column 'APP_NAME'  cannot
> accept a NULL value.


sounds like your APP_NAME column is NULL
send us your portlet.xml and i'll have a look


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org