You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by "Hu, Yiguang" <Yi...@stercomm.com> on 2006/06/01 00:08:48 UTC

RE: Column 'APP_NAME' cannot accept a NULL value

Thanks a lot, Arron. That works. I ended up make the portlet-app id also
equals the web context. 

Yiguang
-----Original Message-----
From: Aaron Evans [mailto:aaronmevans@gmail.com] 
Sent: Wednesday, May 31, 2006 5:54 PM
To: Jetspeed Users List
Subject: Re: Column 'APP_NAME' cannot accept a NULL value

I think your PSML  you have to refer to the portlet name value from
the portlet.xml, not the ID.  (I always make them the same anyway).

On 5/31/06, Hu, Yiguang <Yi...@stercomm.com> wrote:
> Thanks David. I am sending both the portlet.xml and the psml file.
> (Notice I tried adding name attribute and it didn't work either).
> Yiguang
>
> <portlet-app id="ptmstrts" name="ptmstruts" version="4.0.5">^M
>   <portlet id="xPtmstruts">
>     <init-param>
>       <name>ServletContextProvider</name>
>
> <value>org.apache.jetspeed.portlet.ServletContextProviderImpl</value>
>     </init-param>
>     <init-param>
>       <name>ViewPage</name>
>       <value>/index.jsp</value>
>     </init-param>
>     <portlet-name>ptpstruts</portlet-name>^M
>     <display-name>ptmstruts</display-name>^M
>     <description>ptmstruts</description>^M
>
>
<portlet-class>org.apache.portals.bridges.struts.StrutsPortlet</portlet-
> class>^M
>     <expiration-cache>-1</expiration-cache>^M
>     <supports>^M
>       <mime-type>text/html</mime-type>^M
>       <portlet-mode>VIEW</portlet-mode>^M
>     </supports>^M
>     <portlet-info>^M
>       <title>ptmstruts</title>^M
>       <keywords>Struts</keywords>^M
>     </portlet-info>^M
>   </portlet>^M
> </portlet-app>^M
>
> <page id="ptmstruts">
>   <defaults
>      skin="orange"
>      layout-decorator="tigris"
>      portlet-decorator="pretty-single-portlet"
>   />
>   <title>ptmstruts</title>
>   <metadata name="title"
> xml:lang="zh">\345\256\240\347\211\251\345\272\227</metadata>
>
>   <fragment id="jp-x1" type="layout"
> name="jetspeed-layouts::VelocityOneColumn">
>     <fragment id="jp-xx2" type="portlet" name="ptmstrts::xPtmstruts"/>
>         <fragment id="jp-2" type="portlet"
> name="jpetstore::JPetstorePortlet"/>
>
>   </fragment>
>
>   <security-constraints>
>     <security-constraints-ref>users</security-constraints-ref>
>   </security-constraints>
> </page>
> -----Original Message-----
> From: David Sean Taylor [mailto:david@bluesunrise.com]
> Sent: Wednesday, May 31, 2006 4:13 PM
> To: Jetspeed Users List
> Subject: Re: Column 'APP_NAME' cannot accept a NULL value
>
> 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
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>

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


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


Re: Column 'APP_NAME' cannot accept a NULL value

Posted by Jose Luis Granda <jl...@gmail.com>.
Hi, I have the same problem. I follow SimplestPortlet Tutorial step by
step, but get it error. I read this gmail conversation and try to
solve, but don't works.

Please, help me.

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


Re: Column 'APP_NAME' cannot accept a NULL value

Posted by Aaron Evans <aa...@gmail.com>.
Oh right, that is the other thing as you have figured out.  So to be
clear, when you refer to a portlet in a PSML fragment, it is of the
form <web-app-context>::<portlet-name>.

The portlet app ID and portlet ID are *not* used AFAIK.

aaron

On 5/31/06, Hu, Yiguang <Yi...@stercomm.com> wrote:
> Thanks a lot, Arron. That works. I ended up make the portlet-app id also
> equals the web context.
>
> Yiguang
> -----Original Message-----
> From: Aaron Evans [mailto:aaronmevans@gmail.com]
> Sent: Wednesday, May 31, 2006 5:54 PM
> To: Jetspeed Users List
> Subject: Re: Column 'APP_NAME' cannot accept a NULL value
>
> I think your PSML  you have to refer to the portlet name value from
> the portlet.xml, not the ID.  (I always make them the same anyway).
>
> On 5/31/06, Hu, Yiguang <Yi...@stercomm.com> wrote:
> > Thanks David. I am sending both the portlet.xml and the psml file.
> > (Notice I tried adding name attribute and it didn't work either).
> > Yiguang
> >
> > <portlet-app id="ptmstrts" name="ptmstruts" version="4.0.5">^M
> >   <portlet id="xPtmstruts">
> >     <init-param>
> >       <name>ServletContextProvider</name>
> >
> > <value>org.apache.jetspeed.portlet.ServletContextProviderImpl</value>
> >     </init-param>
> >     <init-param>
> >       <name>ViewPage</name>
> >       <value>/index.jsp</value>
> >     </init-param>
> >     <portlet-name>ptpstruts</portlet-name>^M
> >     <display-name>ptmstruts</display-name>^M
> >     <description>ptmstruts</description>^M
> >
> >
> <portlet-class>org.apache.portals.bridges.struts.StrutsPortlet</portlet-
> > class>^M
> >     <expiration-cache>-1</expiration-cache>^M
> >     <supports>^M
> >       <mime-type>text/html</mime-type>^M
> >       <portlet-mode>VIEW</portlet-mode>^M
> >     </supports>^M
> >     <portlet-info>^M
> >       <title>ptmstruts</title>^M
> >       <keywords>Struts</keywords>^M
> >     </portlet-info>^M
> >   </portlet>^M
> > </portlet-app>^M
> >
> > <page id="ptmstruts">
> >   <defaults
> >      skin="orange"
> >      layout-decorator="tigris"
> >      portlet-decorator="pretty-single-portlet"
> >   />
> >   <title>ptmstruts</title>
> >   <metadata name="title"
> > xml:lang="zh">\345\256\240\347\211\251\345\272\227</metadata>
> >
> >   <fragment id="jp-x1" type="layout"
> > name="jetspeed-layouts::VelocityOneColumn">
> >     <fragment id="jp-xx2" type="portlet" name="ptmstrts::xPtmstruts"/>
> >         <fragment id="jp-2" type="portlet"
> > name="jpetstore::JPetstorePortlet"/>
> >
> >   </fragment>
> >
> >   <security-constraints>
> >     <security-constraints-ref>users</security-constraints-ref>
> >   </security-constraints>
> > </page>
> > -----Original Message-----
> > From: David Sean Taylor [mailto:david@bluesunrise.com]
> > Sent: Wednesday, May 31, 2006 4:13 PM
> > To: Jetspeed Users List
> > Subject: Re: Column 'APP_NAME' cannot accept a NULL value
> >
> > 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
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail: jetspeed-user-help@portals.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>

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