I`ve forgotten to read the JavaDoc. sorry. Thank you for pointing out a solution. Thank you Chuck.
2016-05-12 18:34 GMT-03:00 Chuck Hill <ch...@gevityinc.com>: > Hi Luiz, > > > > This is in the JavaDoc for this method: > > * Updates rows described by the qualifier. Note that the values and > the qualifier need to be on an attribute > > * and *not on a relationship level. I.e. you need to give > relationshipForeignKey = pk of object instead of * > > * * relatedObject = object*. The newValues dictionaries also holds > foreign keys, not objects. > > > > > > Chuck > > > > *From: *<webobjects-dev-bounces+chill=gevityinc....@lists.apple.com> on > behalf of Luiz Alfredo Carrara Bertusso <luizalfred...@gmail.com> > *Date: *Thursday, May 12, 2016 at 1:52 PM > *To: *"webobjects-dev@lists.apple.com" <webobjects-dev@lists.apple.com> > *Subject: *Exception Updating Rows When Qualifier Has Relationship > > > > Hello, I`ve been trying to use the method updateRowsDescribedByQualifier > of ERXEOAccessUtilities class but I`m facing a problem. > > The method updateRowsDescribedByQualifier requires the following > parameters: an EOEditingContext, a String that represents an entity name, a > qualifier and a NSDictionary of target fields to be updated. > > The problem I`m facing is that in my qualifier I`m using a relationship, > the qualifier is Activity.OWNER.is(user);, in this case OWNER is the > relationship between Activity and User. > > As exception I`m getting the following stack trace: > > > > *java.lang.IllegalStateException: sqlStringForKeyValueQualifier: attempt > to generate SQL for er.extensions.qualifiers.ERXKeyValueQualifier (owner = > (User)'<User pk:"5">') failed because attribute identified by key 'owner' > was not reachable from from entity 'Activity'* > > *at > com.webobjects.eoaccess.EOSQLExpression.sqlStringForKeyValueQualifier(EOSQLExpression.java:1632)* > > *at > com.webobjects.eoaccess.EOQualifierSQLGeneration$_KeyValueQualifierSupport.sqlStringForSQLExpression(EOQualifierSQLGeneration.java:463)* > > *at > er.extensions.ERXExtensions$KeyValueQualifierSQLGenerationSupport.sqlStringForSQLExpression(ERXExtensions.java:346)* > > *at > com.webobjects.eoaccess.EOQualifierSQLGeneration$Support._sqlStringForSQLExpression(EOQualifierSQLGeneration.java:165)* > > *at > com.webobjects.eoaccess.EOSQLExpression.prepareUpdateExpressionWithRow(EOSQLExpression.java:885)* > > *at > com.webobjects.eoaccess.EOSQLExpressionFactory.updateStatementForRow(EOSQLExpressionFactory.java:155)* > > *at > com.webobjects.jdbcadaptor.JDBCChannel.updateValuesInRowsDescribedByQualifier(JDBCChannel.java:175)* > > *at > er.extensions.eof.ERXEOAccessUtilities$2.doPerform(ERXEOAccessUtilities.java:1640)* > > *at > er.extensions.eof.ERXEOAccessUtilities$ChannelAction.perform(ERXEOAccessUtilities.java:1586)* > > *at > er.extensions.eof.ERXEOAccessUtilities.updateRowsDescribedByQualifier(ERXEOAccessUtilities.java:1643)* > > > > Could someone help me to understand a way to solve this? > > > > Thanks. >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
