• 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: back to ERXBatchingDisplayGroup instead of ERXDisplayGroup
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: back to ERXBatchingDisplayGroup instead of ERXDisplayGroup


  • Subject: Re: back to ERXBatchingDisplayGroup instead of ERXDisplayGroup
  • From: Chuck Hill <email@hidden>
  • Date: Tue, 4 May 2010 11:23:38 -0700


On May 4, 2010, at 11:08 AM, Baiss Eric Magnusson wrote:

On May 3, 2010, at 6:18 PM, Chuck Hill wrote:

	public ERXBatchingDisplayGroup<Transaction> curTrans;
	curTrans.queryBindings().setObjectForKey( … );
	try  {
		curTrans.setObjectArray( theOwner.transactions() );
		curTrans.qualifyDataSource();

That looks... odd. Especially this part:
curTrans.setObjectArray( theOwner.transactions() ) I'd expect to set ERXBatchingDisplayGroup up for Transaction and use a
qualifier like "owner = $owner

This really stops me, owner is an object reference to a huge class, I don't understand the generation of anything like owner=$owner in sql, unless EOModeler does some magic substitution of the primary key for the owner equality.

EOF does this (of course, why should you worry about keys?), not EOModeler.



I tried to do so as a test, but I can't get it to generate a meaningful error, just throws a message relating to <$endMonth> the last variable of the list


<owner = $owner and date >= $startMonth and date < $endMonth>
************************
Exception
at java.lang.Thread.run(Thread.java:637) Caused by: com.webobjects.foundation.NSForwardException [java.lang.IllegalStateException] sqlStringForKeyValueQualifier: attempt to generate SQL for com.webobjects.eocontrol.EOKeyValueQualifier (date < $endMonth) failed because the qualifier variable '$endMonth' is unbound.:CurrentSit throw an Exception trying to fetch the transactions.


at Components.CurrentSit.<init>(CurrentSit.java:73) ... 45 more Caused by: java.lang.IllegalStateException: sqlStringForKeyValueQualifier: attempt to generate SQL for com.webobjects.eocontrol.EOKeyValueQualifier (date < $endMonth) failed because the qualifier variable '$endMonth' is unbound.

at com.webobjects.jdbcadaptor.FrontbasePlugIn $ FrontbaseExpression .sqlStringForKeyValueQualifier(FrontbasePlugIn.java:1351)

Not enough parameters for the fetch spec? Spelling or case error?


Chuck


************************

I'm pursuing this because of a gap in understanding I may have.

Before this last years rewrite there were many, many fetch specs, like
	loginId = $loginId and accountId = $accountId

i.e. the old code always explicitly stored/accessed the primary key id of the related object, and in the related object made the primary key accessible as a class member.
I try to undo as I go along this code, there's a lot of it.
***********************
Interesting, I've not used <new EODatabaseDataSource> object, or the other routines, like you do below.


Still studying, thanks.

and date >= $startMonth and date < $endMonth" Passing in theOwner.transactions() is likely to remove a lot of the benefit.

I don't use model (or wherever you are getting this from) display groups, so I don't know what do tell you. In code it would look something like this:

dataSource = new EODatabaseDataSource(editingContext(), entityName());

dataSource .fetchSpecification ().setPrefetchingRelationshipKeyPaths (prefetchingRelationshipKeyPaths());
dataSource .fetchSpecification ().setRefreshesRefetchedObjects( refreshesRefetchedObjects() );
dataSource.fetchSpecification().setIsDeep( true );
dataSource().fetchSpecification().setQualifier(qualifier());
displayGroup.setDataSource(dataSource);


I am guessing you mean an exception not a crash.
Yes, Exception, sorry.

----
Baiss Eric Magnusson
Cascade Web Design






-- Chuck Hill Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects








_______________________________________________
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


References: 
 >back to ERXBatchingDisplayGroup instead of ERXDisplayGroup (From: Baiss Eric Magnusson <email@hidden>)
 >Re: back to ERXBatchingDisplayGroup instead of ERXDisplayGroup (From: Chuck Hill <email@hidden>)
 >Re: back to ERXBatchingDisplayGroup instead of ERXDisplayGroup (From: Baiss Eric Magnusson <email@hidden>)

  • Prev by Date: Re: qualifierWithQualifierFormat ???
  • Next by Date: Re: qualifierWithQualifierFormat ???
  • Previous by thread: Re: back to ERXBatchingDisplayGroup instead of ERXDisplayGroup
  • Next by thread: WODirectConnectEnabled false resource paths problem
  • Index(es):
    • Date
    • Thread