RE: updateValuesInRowDescribedByQualifier - Exception
RE: updateValuesInRowDescribedByQualifier - Exception
- Subject: RE: updateValuesInRowDescribedByQualifier - Exception
- From: "Rui Dias" <email@hidden>
- Date: Thu, 22 May 2003 23:46:27 +0200
Hi Seejo,
i agre with your point, but the problem is that when you execute one update,
the table as an update trigger associated, we use this trigger to be able to
syncronize tables, and the problem is that not only one row would be afected
but 3, any ideas how i can change the number of rows affected.
Thanks in Advance
Best regards
Rui
-----Original Message-----
From: Seejo Pylappan [mailto:email@hidden]
Sent: Monday, May 19, 2003 2:05 PM
To: Rui Dias
Cc: email@hidden
Subject: Re: updateValuesInRowDescribedByQualifier - Exception
This is because the qualifier you created selected 3 rows in the
database when it should select only one. Double check the qualifier to
make sure that it selects only one row in the database to update
(perhaps a data integrity issue?). Turn on the adaptor debugging so
that you can see the SQL generated and then see the erroneous SQL.
On Saturday, May 17, 2003, at 09:30 AM, Rui Dias wrote:
> updateValuesInRowDescribedByQualifier
> Hi All,
>
> We need to implement several triggers in a database in order to have
> some
> consistencies in our funcional database model, but we where not able
> to do
> any updates and inserts in a table update trigger. When we try to
> change any
> data in an entity that has a update inside the trigger we obtain a
> "Write
> error in DB" message.
>
> In the application log file we have the message:
> -------
> ERR 2003-05-15 19:02:03,934
> Handle exception:
> com.webobjects.eoaccess.EOGeneralAdaptorException:
> updateValuesInRowDescribedByQualifier --
> com.webobjects.jdbcadaptor.JDBCChannel: method updated 3 rows, it is
> only
> permitted to update 1 row
> -------
>
>
> any ideas why would be appreciate,
>
> thanks in Advance
>
> Best Regards
>
> Rui
> _______________________________________________
> webobjects-dev mailing list | email@hidden
> Help/Unsubscribe/Archives:
> http://www.lists.apple.com/mailman/listinfo/webobjects-dev
> Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.