[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-user
Subject:    Torque and MS SQL SERVER Triggers
From:       "Julio Cesar De Salvo" <jdesalvo () itechnology ! com ! ar>
Date:       2004-03-30 18:11:00
Message-ID: 001001c41682$5bb5fef0$1200a8c0 () nibbler
[Download RAW message or body]


Hi, I 've a trigger that fires when a certain column is updated.
But it seems that torque does allows only one row to be updated with a
query, because when the trigger is fired I get this error.
 
javax.servlet.ServletException: java.sql.SQLException: There were 2 rows
updated with this records key value.
 
org.apache.struts.action.RequestProcessor.processException(RequestProces
sor.java:545)
 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:486)
 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause 
org.apache.torque.TorqueException: java.sql.SQLException: There were 2
rows updated with this records key value.
 
org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:236)
 
org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:903)
        org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1940)
 
org.itechnology.om.BaseClientePeer.doUpdate(BaseClientePeer.java:495)
 
org.itechnology.om.BaseClientePeer.doUpdate(BaseClientePeer.java:619)
        org.itechnology.om.BaseCliente.save(BaseCliente.java:1588)
        org.itechnology.om.BaseCliente.save(BaseCliente.java:1547)
        org.itechnology.om.BaseCliente.save(BaseCliente.java:1527)
 
org.itechnology.actions.SaveClienteAction.execute(SaveClienteAction.java
:162)
 
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
 
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
 
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
 
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
 
If I remove the trigger everything works fine. Any hints??
 
Thanks.


[prev in list] [next in list] [prev in thread] [next in thread]