Re: ExistsInRelationshipQualifier

Hi Pierre,

Thanks for the reply. I was using the QualifierAdditions available at your blog, so I am sure that the line numbers don't match with Daniele's. Chuck sent me an updated version of that framework last night which didn't work and gives different line numbers than the error I reported yesterday. 

I will switch to the Houdah frameworks before I make a detailed report of the error. I have imported the projects into Eclipse from the Google SVN repository but there are a ton of errors showing up in Eclipse. Is that the correct procedure? Can you tell me which projects I need to install as frameworks to import into my project? Once I get that up and running, I'll report back. Thanks!

David

On 5-Dec-07, at 9:27 AM, Pierre Bernard wrote:

Hi David!

Seems like you are experiencing the same crash as Daniele.

Unfortunately the line numbers in the stack trace don't much with what I have in the Google Code repository.

Your stack trace shows a call to _aliasForRelatedAttributeRelationshipPath at line 99 of ExistsInRelationshipQualifierSupport. I find 2 such calls. One at line 119 and one at 123. Which one is it?
How come the lines don't match?

What do the joins between the tables look like? Single or compound foreign keys? Any flattened relationships?

Could you tell me what _expression_, subExpression, sourceAttribute and destinationAttribute look like at the moment of the crash?

Pierre

On Dec 5, 2007, at 2:51 AM, David Holt wrote:

Hello All,

I am finally getting the chance to use the QualifierAdditions from Pierre Bernard (thanks Pierre!). I am using the following code that generates a NullPointerException. Can anyone see what I have done wrong?

I am trying to show all Artifacts that have not been specified as "favourites".

public EOFetchSpecification getPubliclyDisplayed() {

EOQualifier q1 = new EOKeyValueQualifier( "userName", EOQualifier.QualifierOperatorEqual, applicationUser.userName());

ExistsInRelationshipQualifier q2 = new ExistsInRelationshipQualifier("applicationUsers", q1);

// the inverse

EONotQualifier notq2 = new EONotQualifier(q2);

// EOQualifier q3 = new EOAndQualifier( new NSArray( new Object[] { q1, notq2 } ) );

EOFetchSpecification fs = new EOFetchSpecification( "Artifact", notq2, null );  

return fs;

}

Stack trace:

java.lang.NullPointerException

File	Line#	Method	Package
EOSQLExpression.java	324	_aliasForRelationshipPath	com.webobjects.eoaccess
EOSQLExpression.java	259	_aliasForRelatedAttributeRelationshipPath	com.webobjects.eoaccess
ExistsInRelationshipQualifierSupport.java	99	sqlStringForSQLExpression	com.houdah.webobjects.eoaccess.qualifiers
EOQualifierSQLGeneration.java	151	_sqlStringForSQLExpression	com.webobjects.eoaccess
EOSQLExpression.java	1024	prepareSelectExpressionWithAttributes	com.webobjects.eoaccess
JDBCExpression.java	273	prepareSelectExpressionWithAttributes	com.webobjects.jdbcadaptor
EOSQLExpressionFactory.java	226	selectStatementForAttributes	com.webobjects.eoaccess
ERXSQLHelper.java	461	sqlExpressionForFetchSpecification	er.extensions
ERXSQLHelper.java	513	rowCountForFetchSpecification	er.extensions
ERXEOAccessUtilities.java	284	rowCountForFetchSpecification	er.extensions
ERXBatchingDisplayGroup.java	189	rowCount	er.extensions
ERXBatchingDisplayGroup.java	216	refetch	er.extensions
ERXBatchingDisplayGroup.java	276	fetch

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

This email sent to email@hidden

- - -

Houdah Software s. à r. l.

http://www.houdah.com

HoudahGeo: One-stop photo geocoding

HoudahSpot: Powerful Spotlight frontend