WO and SQL-SERVER Triggers
WO and SQL-SERVER Triggers
- Subject: WO and SQL-SERVER Triggers
- From: "Riaz Lalehzari" <email@hidden>
- Date: Mon, 15 Sep 2003 01:39:30 +0000
Hello,
Has anyone successfully used WO's standard way of updating fields in a table
which has an update and insert trigger set on it in the SQL-Server?
myobj.setName("sdfsdf")
ec.saveChanges();
In the DB the WO program has access to both the table it is trying to
update(eg SiteUsers) and the table which is called in sql-server by the
trigger(eg. AdminUsers).
A fake example would be an 'update' trigger on the 'SiteUsers' table, which
would find all 'AdminUsers' that have the same name as the person you
updated in the 'SiteUsers' table and add one ot their age.
Currently, if there is people in the AdminUsers table with the same name,
then any updates from the site to the SiteUsers table will work fine and the
trigger will work, BUT if there is no matching names in the AdminUsers table
(the 'WHERE' condition in my triggers sql makes it that no fields are
updated), then there is an error and I can't even update the SiteUsers
table.
"Error: com.webobjects.eoaccess.EOGeneralAdaptorException:
updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in
database
Reason: updateValuesInRowDescribedByQualifier --
com.webobjects.jdbcadaptor.JDBCChannel method failed to update row in
database "
The sql I use for the trigger is fine because I am using it for other
programs, it's only WO that has issues with it.
Riaz
_________________________________________________________________
Get less junk mail with ninemsn Premium. Click here
http://ninemsn.com.au/premium/landing.asp
_______________________________________________
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.