Re: ExistsInRelationshipQualifier

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