Re: Many to Many Grief
Re: Many to Many Grief
- Subject: Re: Many to Many Grief
- From: Sacha Mallais <email@hidden>
- Date: Tue, 5 Apr 2005 17:46:53 -0700
On Apr 5, 2005, at 5:08 pm, Greg wrote:
Hi,
I have an Entity name ProUser and another call ProService. ProService
is a list of services that the user can select that they offer via
checkboxes. I used the Create Many to many menu option in EOModeller
to create the relationship which flattens it into ProUser. I created a
component that I wanted to have a list of all the checkboxes so that
the user can select which ones they want. I used a WOCheckBoxList and
hooked everything up and it throws an Exception (see below). I thought
this might have been me misusing the WOCheckBoxList component so I
changed it to a CheckBoxMatrix with a maxColumns of 1 to effectively
give the same display behaviour, but the SAME exception occurs, so I'm
at a loss as to why.
I had a search through the archives and looked for previous problems
and made sure that I was following the commandments of EOF (you know
the ones I recite when go to bed at night and when I wake up in the
morning :-)). I was trying to see if I can actually turn on debugging
of the raw rows returned from the db, but couldn't seem to find
anything in NSLog's javadoc.
Does anyone have any suggestions on trying to figure what is a miss?
2005-04-06 09:59:42,126 WARN ShoeBox[-:50212 2] NSLog
(ERXNSLogLog4jBridge.java:41) -
<com.webobjects.appserver._private.WOComponentRequestHandler>:
Exception occurred while handling request:
java.lang.NullPointerException
[2005-04-06 09:59:42 EST] <WorkerThread1>
java.lang.NullPointerException
at
com.webobjects.foundation._NSStringUtilities.concat(_NSStringUtilities.
java:213)
at
com.webobjects.eoaccess.EOSQLExpression._aliasForRelatedAttributeRelati
onshipPath(EOSQLExpression.java:264)
at
com.webobjects.eoaccess.EOSQLExpression.joinExpression(EOSQLExpression.
java:1169)
at
com.webobjects.eoaccess.EOSQLExpression.prepareSelectExpressionWithAttr
ibutes(EOSQLExpression.java:1033)
at
com.webobjects.jdbcadaptor.JDBCExpression.prepareSelectExpressionWithAt
tributes(JDBCExpression.java:273)
at
com.webobjects.eoaccess.EOSQLExpressionFactory.selectStatementForAttrib
utes(EOSQLExpressionFactory.java:219)
at
com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.jav
a:178)
It looks like the problem is with a missing external name for the
correlation table. When you created the m2m, did you go in and update
the column and table names? This is one I often miss, though if you
have EOModeler do a consistency check, it will catch this.
sacha
--
Sacha Michel Mallais - 400 lb. chimp
Global Village Consulting Inc.: http://www.global-village.net/
Choke on that, causality! -- the Professor, "Futurama"
_______________________________________________
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