• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Derived Attributes [SOLVED]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Derived Attributes [SOLVED]

  • Subject: Re: Derived Attributes [SOLVED]
  • From: Kieran Kelleher <email@hidden>
  • Date: Fri, 26 Feb 2010 18:42:09 -0500
Surprize, surprize, it turns out that you need some other characters in the _expression_ if you make a derived attribute and the _expression_ is simply another attribute name ..... for example to expose a PK as a readonly "uniqueID" attribute ( don't ask - I don't care about "PKs are a database artifact" theory ;-)  ... besides Read-Only is checked on the attr. anyway)

Even a simple SPACE before the _expression_ will make it work... otherwise WO fails to parse the derived _expression_ - sounds like a bug to me - but at least we know the workaround. If you don't like a space, just surround it with brackets ..... like this "(oid)" ... and that works too - great!

http://idisk.me.com/kelleherk/Public/Pictures/Skitch/spaceneeded-20100226-175822.jpg

-Kieran

PS. John, I did try your suggestion of entering columnName = "" in the plist directly first - that was not the solution to this particular problem.

On Feb 26, 2010, at 3:33 PM, John Huss wrote:

My model also has:

     columnName = "";

for my derived attributes - maybe that matters?

John

On Fri, Feb 26, 2010 at 1:51 PM, Kieran Kelleher <email@hidden> wrote:
Hi all, 

I tried adding a simple derived attribute to a model, as shown here:

http://idisk.me.com/kelleherk/Public/Pictures/Skitch/derived_attribute-20100226-125124.jpg

However EOF falls over as soon as I touch that entity with an error like the following. This is WO 5.3.3 btw.  Looking at the source in EOSQLExpression, it would seem that the attribute_definitionArray is null, because if it is null, then the method tries to get a column name and throws this exception when there is no column name.. The eomodel itself shows the attribute like this in the plist:

        {
            allowsNull = Y; 
            definition = oid; 
            externalType = INT; 
            name = uniqueID; 
            valueClassName = NSNumber; 
            valueType = i; 
        }



So now I put a few statements in didFinishLaunhcing to grab that EOAttribute and check in the debugger and I find that the _definitionArray is empty. That does not seem right, does it?

http://idisk.me.com/kelleherk/Public/Pictures/Skitch/emptydefinitionarray-20100226-131150.jpg
 
Any ideas why this would not work, or how to troubleshoot it if it should work?

I know Wonder uses programmatically created derived attributes for COUNT(*)  and aggregate functions, but is there anyone out there using model-defined derived attributes successfully?

java.lang.IllegalStateException: sqlStringForAttribute: attempt to generate SQL for attribute 'uniqueID' on entity 'CTMessage' with undefined column name. You must define a column name for this attribute before attempting a database operation.
  at com.webobjects.eoaccess.EOSQLExpression.sqlStringForAttribute(EOSQLExpression.java:2064)
  at com.webobjects.jdbcadaptor.JDBCExpression.addSelectListAttribute(JDBCExpression.java:362)
  at com.webobjects.eoaccess.EOSQLExpression.prepareSelectExpressionWithAttributes(EOSQLExpression.java:1006)
  at com.webobjects.jdbcadaptor.JDBCExpression.prepareSelectExpressionWithAttributes(JDBCExpression.java:273)
  at com.webobjects.eoaccess.EOSQLExpressionFactory.selectStatementForAttributes(EOSQLExpressionFactory.java:226)
  at er.extensions.jdbc.ERXSQLHelper.sqlExpressionForFetchSpecification(ERXSQLHelper.java:635)
  at er.extensions.jdbc.ERXSQLHelper.sqlExpressionForFetchSpecification(ERXSQLHelper.java:569)
  at er.extensions.jdbc.ERXSQLHelper.rowCountForFetchSpecification(ERXSQLHelper.java:1110)
  at er.extensions.eof.ERXEOAccessUtilities.rowCountForFetchSpecification(ERXEOAccessUtilities.java:458)
  at er.extensions.batching.ERXBatchingDisplayGroup.rowCount(ERXBatchingDisplayGroup.java:292)
  at er.extensions.batching.ERXBatchingDisplayGroup.refetch(ERXBatchingDisplayGroup.java:362)
  at er.extensions.batching.ERXBatchingDisplayGroup.fetch(ERXBatchingDisplayGroup.java:438)
  at wk.eofextensions.WKEOUtils.displayGroupWithFetchSpecification(WKEOUtils.java:1061)
  at wk.cheetah.wocomponents.MessagesPage.dg(MessagesPage.java:52)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:592)
  at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:684)
  at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1160)
  at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1268)
  at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1539)
  at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:498)
  at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212)
  at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1600)
  at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:46)
  at com.webobjects.appserver.WOComponent.valueForBinding(WOComponent.java:735)
  at er.extensions.batching.ERXFlickrBatchNavigation.displayGroup(ERXFlickrBatchNavigation.java:82)
  at er.extensions.batching.ERXFlickrBatchNavigation.batchCount(ERXFlickrBatchNavigation.java:285)
  at er.extensions.batching.ERXFlickrBatchNavigation.hasMultiplePages(ERXFlickrBatchNavigation.java:94)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:592)
  at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor$1.methodValue(NSKeyValueCoding.java:684)
  at com.webobjects.foundation.NSKeyValueCoding$_MethodBinding.valueInObject(NSKeyValueCoding.java:1160)
  at com.webobjects.foundation.NSKeyValueCoding$DefaultImplementation.valueForKey(NSKeyValueCoding.java:1268)
  at com.webobjects.appserver.WOComponent.valueForKey(WOComponent.java:1539)
  at com.webobjects.foundation.NSKeyValueCoding$Utility.valueForKey(NSKeyValueCoding.java:498)
  at com.webobjects.foundation.NSKeyValueCodingAdditions$DefaultImplementation.valueForKeyPath(NSKeyValueCodingAdditions.java:212)
  at com.webobjects.appserver.WOComponent.valueForKeyPath(WOComponent.java:1600)
  at com.webobjects.appserver._private.WOKeyValueAssociation.valueInComponent(WOKeyValueAssociation.java:46)
  at com.webobjects.appserver.WOAssociation.booleanValueInComponent(WOAssociation.java:278)
  at er.extensions.components.conditionals.ERXWOConditional.conditionInComponent(ERXWOConditional.java:47)
  at er.extensions.components.conditionals.ERXWOConditional.meetsConditionInComponent(ERXWOConditional.java:52)
  at er.extensions.components.conditionals.ERXWOConditional.appendToResponse(ERXWOConditional.java:120)
  at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:121)
  at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:130)
  at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:992)
  at er.extensions.components.ERXComponent.appendToResponse(ERXComponent.java:107)
  at com.webobjects.appserver._private.WOComponentReference.appendToResponse(WOComponentReference.java:111)
  at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:121)
  at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:130)
  at com.webobjects.appserver._private.WOComponentContent.appendToResponse(WOComponentContent.java:43)
  at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:121)
  at com.webobjects.appserver._private.WOGenericContainer.appendToResponse(WOGenericContainer.java:32)
  at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:121)
  at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:130)
  at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:992)
  at er.extensions.components.ERXComponent.appendToResponse(ERXComponent.java:107)
  at wk.webobjects.appserver.WKAbstractComponent.appendToResponse(WKAbstractComponent.java:487)
  at wk.cheetah.wocomponents.PageWrapper.appendToResponse(PageWrapper.java:247)
  at com.webobjects.appserver._private.WOComponentReference.appendToResponse(WOComponentReference.java:111)
  at com.webobjects.appserver._private.WODynamicGroup.appendChildrenToResponse(WODynamicGroup.java:121)
  at com.webobjects.appserver._private.WODynamicGroup.appendToResponse(WODynamicGroup.java:130)
  at com.webobjects.appserver.WOComponent.appendToResponse(WOComponent.java:992)
  at er.extensions.components.ERXComponent.appendToResponse(ERXComponent.java:107)
  at wk.webobjects.appserver.WKAbstractComponent.appendToResponse(WKAbstractComponent.java:487)
  at com.webobjects.appserver.WOSession.appendToResponse(WOSession.java:1200)
  at er.extensions.appserver.ERXSession.appendToResponse(ERXSession.java:540)
  at wk.webobjects.appserver.WKSession.appendToResponse(WKSession.java:211)
  at wk.cheetah.Session.appendToResponse(Session.java:442)
  at com.webobjects.appserver.WOApplication.appendToResponse(WOApplication.java:1418)
  at er.extensions.appserver.ERXApplication.appendToResponse(ERXApplication.java:1817)
  at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedPage(WOComponentRequestHandler.java:230)
  at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedSession(WOComponentRequestHandler.java:287)
  at com.webobjects.appserver._private.WOComponentRequestHandler._dispatchWithPreparedApplication(WOComponentRequestHandler.java:322)
  at com.webobjects.appserver._private.WOComponentRequestHandler._handleRequest(WOComponentRequestHandler.java:358)
  at com.webobjects.appserver._private.WOComponentRequestHandler.handleRequest(WOComponentRequestHandler.java:435)
  at com.webobjects.appserver.WOApplication.dispatchRequest(WOApplication.java:1306)
  at er.extensions.appserver.ERXApplication.dispatchRequestImmediately(ERXApplication.java:1915)
  at er.extensions.appserver.ERXApplication.dispatchRequest(ERXApplication.java:1880)
  at wk.webobjects.appserver.WKApplication.dispatchRequest(WKApplication.java:276)
  at com.webobjects.appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:173)
  at com.webobjects.appserver._private.WOWorkerThread.run(WOWorkerThread.java:254)
  at java.lang.Thread.run(Thread.java:613)

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: Derived Attributes [SOLVED]
      • From: Chuck Hill <email@hidden>
References: 
 >Derived Attributes (From: Kieran Kelleher <email@hidden>)

  • Prev by Date: Re: Eclipse: Generate Getters and Setters
  • Next by Date: Re: Derived Attributes [SOLVED]
  • Previous by thread: Derived Attributes
  • Next by thread: Re: Derived Attributes [SOLVED]
  • Index(es):
    • Date
    • Thread