You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Dima Gritsenko <di...@ekreative.com> on 2006/10/05 11:59:41 UTC
Error resolving fault for ObjectId
Hi, Sorry for messing up a thread, but had a glitch with subscription, thus renewing the tread again for the subject. To: Mike KienenbergerYes, Mike the record as there in the DB. Any other suggestions?Thank you. Dima. ---------------------------------------------------------------Did you verify that [Membership, customer_id=116080] exists in the
database at this moment in time?
On 9/16/06, Dima Gritsenko <di...@ekreative.com> wrote:
> Hi,
>
> We are having the following problem (mapping provided below):
>
> Access to the property "joinDate" of the Memebership object using jstl
> <fmt:formatDate value="${custEmail.emailCustomer.customerMembership.joinDate}"
type="both"/>
>
> Causes this exception:
> 2006-09-04 10:15:56 ApplicationDispatcher[/csr] Servlet.service() for servlet jsp threw
exception
> org.objectstyle.cayenne.FaultFailureException: [v.1.2 July 16 2006] Error resolving fault
for ObjectId: <ObjectId:Membership, customer_id=116080> and state (hollow). Possible
cause - matching row is missing from the database.
> at org.objectstyle.cayenne.access.DataContext.prepareForAccess(DataContext.java:1851)
> at org.objectstyle.cayenne.CayenneDataObject.readProperty(CayenneDataObject.java:238)
> at persistence.auto._Membership.getJoinDate(_Membership.java:59)
> at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at org.apache.taglibs.standard.lang.jstl.ArraySuffix.evaluate(ArraySuffix.java:278)
> at org.apache.taglibs.standard.lang.jstl.ComplexValue.evaluate(ComplexValue.java:107)
> at org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:204)
> at org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:163)
> at org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:101)
> at org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:129)
> at org.apache.taglibs.standard.lang.support.ExpressionEvaluatorManager.evaluate(ExpressionEvaluatorManager.java:75)
> at org.apache.taglibs.standard.tag.el.fmt.FormatDateTag.evaluateExpressions(FormatDateTag.java:134)
> at org.apache.taglibs.standard.tag.el.fmt.FormatDateTag.doStartTag(FormatDateTag.java:67)
> at org.apache.jsp.email.list_jsp._jspx_meth_fmt_formatDate_1(list_jsp.java:1289)
> at org.apache.jsp.email.list_jsp._jspx_meth_logic_notEmpty_2(list_jsp.java:1266)
> at org.apache.jsp.email.list_jsp._jspService(list_jsp.java:250)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)
> at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:590)
> at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:510)
> at org.apache.struts.tiles.TilesUtilStrutsModulesImpl.doInclude(TilesUtilStrutsModulesImpl.java:122)
> at org.apache.struts.tiles.TilesUtil.doInclude(TilesUtil.java:160)
> at org.apache.struts.taglib.tiles.InsertTag.doInclude(InsertTag.java:702)
> at org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:817)
> at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:466)
> at org.apache.jsp.layouts.email.layout_jsp._jspx_meth_tiles_insert_1(layout_jsp.java:327)
> at org.apache.jsp.layouts.email.layout_jsp._jspService(layout_jsp.java:196)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:704)
> at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)
> at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)
> at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
> at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1057)
> at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:267)
> at org.apache.struts.tiles.TilesRequestProcessor.processTilesDefinition(TilesRequestProcessor.java:248)
> at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:301)
> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420)
> at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:502)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
> at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
> at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
> at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
> at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
> at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
> at java.lang.Thread.run(Thread.java:595)
>
> This is similar to the problem described here: http://www.objectstyle.org/cayenne/lists/cayenne-user/2006/06/0147.html
> but ours is different since both customer_id fields are PKs.
>
> Mapping
> <db-entity name="tbl_membership" catalog="main">
> <db-attribute name="customer_id" type="INTEGER" isPrimaryKey="true" isMandatory="true"
length="10"/>
> <db-attribute name="order_id" type="INTEGER" isPrimaryKey="true" isMandatory="true"
length="10"/>
> <db-attribute name="join_date" type="TIMESTAMP" length="19"/>
> <db-attribute name="last_renewal_date" type="TIMESTAMP" length="19"/>
> <db-attribute name="membership_type" type="CHAR" length="50"/>
> <db-attribute name="cancellation_date" type="TIMESTAMP" length="19"/>
> <db-attribute name="cancellation_reason" type="CHAR" length="255"/>
> <db-attribute name="expiration_date" type="TIMESTAMP" length="19"/>
> <db-attribute name="cancellation_number" type="CHAR" length="50"/>
> </db-entity>
>
> <db-entity name="tbl_customer" catalog="main">
> <db-attribute name="CUSTOMER_ID" type="INTEGER" isPrimaryKey="true" isMandatory="true"
isGenerated="true" length="10"/>
> <db-attribute name="BRAND_ID" type="INTEGER" length="10"/>
> <db-attribute name="FIRST_NAME" type="VARCHAR" length="50"/>
> <db-attribute name="MIDDLE_NAME" type="VARCHAR" length="50"/>
> <db-attribute name="LAST_NAME" type="VARCHAR" length="50"/>
> <db-attribute name="LOGIN_NAME" type="VARCHAR" length="50"/>
> <db-attribute name="LOGIN_PASSWORD" type="VARCHAR" length="50"/>
> <db-attribute name="SESSIONS_COUNT" type="INTEGER" length="10"/>
> </db-entity>
>
> <db-relationship name="customerMembership" source="tbl_customer" target="tbl_membership"
toDependentPK="true" toMany="false">
> <db-attribute-pair source="CUSTOMER_ID" target="customer_id"/>
> </db-relationship>
> <db-relationship name="membershipCustomer" source="tbl_membership" target="tbl_customer"
toMany="false">
> <db-attribute-pair source="customer_id" target="CUSTOMER_ID"/>
> </db-relationship>
>
>
> Thank you.
> Dima.
Re: Error resolving fault for ObjectId
Posted by Dima Gritsenko <di...@ekreative.com>.
Thank you, Andrus,
We'll try this out, the problem though is that it only occurs several times
for lots of requests. Will monitor logs after we do a build.
Thanks.
Dima.
----- Original Message -----
From: "Andrus Adamchik" <an...@objectstyle.org>
To: <ca...@incubator.apache.org>
Sent: Friday, October 06, 2006 9:24 PM
Subject: Re: Error resolving fault for ObjectId
> Dima,
>
> looks like "customerMembership" relationship should be to-many.
>
> Andrus
>
> > <db-relationship name="customerMembership" source="tbl_customer"
> > target="tbl_membership" toDependentPK="true" toMany="false">
> > <db-attribute-pair source="CUSTOMER_ID" target="customer_id"/>
> > </db-relationship>
> > <db-relationship name="membershipCustomer"
> > source="tbl_membership" target="tbl_customer" toMany="false">
> > <db-attribute-pair source="customer_id" target="CUSTOMER_ID"/>
> > </db-relationship>
>
>
>
> On Oct 5, 2006, at 5:59 AM, Dima Gritsenko wrote:
>
> > Hi, Sorry for messing up a thread, but had a glitch with
> > subscription, thus renewing the tread again for the subject. To:
> > Mike KienenbergerYes, Mike the record as there in the DB. Any other
> > suggestions?Thank you. Dima.
> > ---------------------------------------------------------------Did
> > you verify that [Membership, customer_id=116080] exists in the
> > database at this moment in time?
> >
> > On 9/16/06, Dima Gritsenko <di...@ekreative.com> wrote:
> >> Hi,
> >>
> >> We are having the following problem (mapping provided below):
> >>
> >> Access to the property "joinDate" of the Memebership object using
> >> jstl
> >> <fmt:formatDate value="$
> >> {custEmail.emailCustomer.customerMembership.joinDate}"
> > type="both"/>
> >>
> >> Causes this exception:
> >> 2006-09-04 10:15:56 ApplicationDispatcher[/csr] Servlet.service()
> >> for servlet jsp threw
> > exception
> >> org.objectstyle.cayenne.FaultFailureException: [v.1.2 July 16
> >> 2006] Error resolving fault
> > for ObjectId: <ObjectId:Membership, customer_id=116080> and state
> > (hollow). Possible
> > cause - matching row is missing from the database.
> >> at org.objectstyle.cayenne.access.DataContext.prepareForAccess
> >> (DataContext.java:1851)
> >> at org.objectstyle.cayenne.CayenneDataObject.readProperty
> >> (CayenneDataObject.java:238)
> >> at persistence.auto._Membership.getJoinDate(_Membership.java:59)
>
> [..]
>
> >>
> >> This is similar to the problem described here: http://
> >> www.objectstyle.org/cayenne/lists/cayenne-user/2006/06/0147.html
> >> but ours is different since both customer_id fields are PKs.
> >>
> >> Mapping
> >> <db-entity name="tbl_membership" catalog="main">
> >> <db-attribute name="customer_id" type="INTEGER"
> >> isPrimaryKey="true" isMandatory="true"
> > length="10"/>
> >> <db-attribute name="order_id" type="INTEGER"
> >> isPrimaryKey="true" isMandatory="true"
> > length="10"/>
> >> <db-attribute name="join_date" type="TIMESTAMP" length="19"/>
> >> <db-attribute name="last_renewal_date" type="TIMESTAMP"
> >> length="19"/>
> >> <db-attribute name="membership_type" type="CHAR"
> >> length="50"/>
> >> <db-attribute name="cancellation_date" type="TIMESTAMP"
> >> length="19"/>
> >> <db-attribute name="cancellation_reason" type="CHAR"
> >> length="255"/>
> >> <db-attribute name="expiration_date" type="TIMESTAMP"
> >> length="19"/>
> >> <db-attribute name="cancellation_number" type="CHAR"
> >> length="50"/>
> >> </db-entity>
> >>
> >> <db-entity name="tbl_customer" catalog="main">
> >> <db-attribute name="CUSTOMER_ID" type="INTEGER"
> >> isPrimaryKey="true" isMandatory="true"
> > isGenerated="true" length="10"/>
> >> <db-attribute name="BRAND_ID" type="INTEGER" length="10"/>
> >> <db-attribute name="FIRST_NAME" type="VARCHAR" length="50"/>
> >> <db-attribute name="MIDDLE_NAME" type="VARCHAR" length="50"/>
> >> <db-attribute name="LAST_NAME" type="VARCHAR" length="50"/>
> >> <db-attribute name="LOGIN_NAME" type="VARCHAR" length="50"/>
> >> <db-attribute name="LOGIN_PASSWORD" type="VARCHAR"
> >> length="50"/>
> >> <db-attribute name="SESSIONS_COUNT" type="INTEGER"
> >> length="10"/>
> >> </db-entity>
> >>
> >> <db-relationship name="customerMembership"
> >> source="tbl_customer" target="tbl_membership"
> > toDependentPK="true" toMany="false">
> >> <db-attribute-pair source="CUSTOMER_ID"
> >> target="customer_id"/>
> >> </db-relationship>
> >> <db-relationship name="membershipCustomer"
> >> source="tbl_membership" target="tbl_customer"
> > toMany="false">
> >> <db-attribute-pair source="customer_id"
> >> target="CUSTOMER_ID"/>
> >> </db-relationship>
> >>
> >>
> >> Thank you.
> >> Dima.
>
>
Re: Error resolving fault for ObjectId
Posted by Andrus Adamchik <an...@objectstyle.org>.
Dima,
looks like "customerMembership" relationship should be to-many.
Andrus
> <db-relationship name="customerMembership" source="tbl_customer"
> target="tbl_membership" toDependentPK="true" toMany="false">
> <db-attribute-pair source="CUSTOMER_ID" target="customer_id"/>
> </db-relationship>
> <db-relationship name="membershipCustomer"
> source="tbl_membership" target="tbl_customer" toMany="false">
> <db-attribute-pair source="customer_id" target="CUSTOMER_ID"/>
> </db-relationship>
On Oct 5, 2006, at 5:59 AM, Dima Gritsenko wrote:
> Hi, Sorry for messing up a thread, but had a glitch with
> subscription, thus renewing the tread again for the subject. To:
> Mike KienenbergerYes, Mike the record as there in the DB. Any other
> suggestions?Thank you. Dima.
> ---------------------------------------------------------------Did
> you verify that [Membership, customer_id=116080] exists in the
> database at this moment in time?
>
> On 9/16/06, Dima Gritsenko <di...@ekreative.com> wrote:
>> Hi,
>>
>> We are having the following problem (mapping provided below):
>>
>> Access to the property "joinDate" of the Memebership object using
>> jstl
>> <fmt:formatDate value="$
>> {custEmail.emailCustomer.customerMembership.joinDate}"
> type="both"/>
>>
>> Causes this exception:
>> 2006-09-04 10:15:56 ApplicationDispatcher[/csr] Servlet.service()
>> for servlet jsp threw
> exception
>> org.objectstyle.cayenne.FaultFailureException: [v.1.2 July 16
>> 2006] Error resolving fault
> for ObjectId: <ObjectId:Membership, customer_id=116080> and state
> (hollow). Possible
> cause - matching row is missing from the database.
>> at org.objectstyle.cayenne.access.DataContext.prepareForAccess
>> (DataContext.java:1851)
>> at org.objectstyle.cayenne.CayenneDataObject.readProperty
>> (CayenneDataObject.java:238)
>> at persistence.auto._Membership.getJoinDate(_Membership.java:59)
[..]
>>
>> This is similar to the problem described here: http://
>> www.objectstyle.org/cayenne/lists/cayenne-user/2006/06/0147.html
>> but ours is different since both customer_id fields are PKs.
>>
>> Mapping
>> <db-entity name="tbl_membership" catalog="main">
>> <db-attribute name="customer_id" type="INTEGER"
>> isPrimaryKey="true" isMandatory="true"
> length="10"/>
>> <db-attribute name="order_id" type="INTEGER"
>> isPrimaryKey="true" isMandatory="true"
> length="10"/>
>> <db-attribute name="join_date" type="TIMESTAMP" length="19"/>
>> <db-attribute name="last_renewal_date" type="TIMESTAMP"
>> length="19"/>
>> <db-attribute name="membership_type" type="CHAR"
>> length="50"/>
>> <db-attribute name="cancellation_date" type="TIMESTAMP"
>> length="19"/>
>> <db-attribute name="cancellation_reason" type="CHAR"
>> length="255"/>
>> <db-attribute name="expiration_date" type="TIMESTAMP"
>> length="19"/>
>> <db-attribute name="cancellation_number" type="CHAR"
>> length="50"/>
>> </db-entity>
>>
>> <db-entity name="tbl_customer" catalog="main">
>> <db-attribute name="CUSTOMER_ID" type="INTEGER"
>> isPrimaryKey="true" isMandatory="true"
> isGenerated="true" length="10"/>
>> <db-attribute name="BRAND_ID" type="INTEGER" length="10"/>
>> <db-attribute name="FIRST_NAME" type="VARCHAR" length="50"/>
>> <db-attribute name="MIDDLE_NAME" type="VARCHAR" length="50"/>
>> <db-attribute name="LAST_NAME" type="VARCHAR" length="50"/>
>> <db-attribute name="LOGIN_NAME" type="VARCHAR" length="50"/>
>> <db-attribute name="LOGIN_PASSWORD" type="VARCHAR"
>> length="50"/>
>> <db-attribute name="SESSIONS_COUNT" type="INTEGER"
>> length="10"/>
>> </db-entity>
>>
>> <db-relationship name="customerMembership"
>> source="tbl_customer" target="tbl_membership"
> toDependentPK="true" toMany="false">
>> <db-attribute-pair source="CUSTOMER_ID"
>> target="customer_id"/>
>> </db-relationship>
>> <db-relationship name="membershipCustomer"
>> source="tbl_membership" target="tbl_customer"
> toMany="false">
>> <db-attribute-pair source="customer_id"
>> target="CUSTOMER_ID"/>
>> </db-relationship>
>>
>>
>> Thank you.
>> Dima.