db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julio Cesar De Salvo" <jdesa...@itechnology.com.ar>
Subject Torque and MS SQL SERVER Triggers
Date Tue, 30 Mar 2004 18:11:00 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message