yfzsj
发贴: 6
积分: 0
|
于 2010-04-26 13:56
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO
CREATE trigger count_user on LTCms_E_Question_logs
after insert
as set nocount on begin
if exists(select 0 from inserted) begin delete from LTCms_E_user_count insert into LTCms_E_user_count(questionid,companyid,userid,usercount,itemid,itemName)
select l.questionid,l.companyid,l.userid,count(l.itemid) usercount,l.itemid,i.itemName from LTCms_E_Question_logs l join dbo.LTCms_E_Question_items i on l.itemid = i.id group by l.questionid,l.companyid,l.departmentid,l.itemid,i.itemName,l.userid end end GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
以上是我建的触发器,但是hibernate就无法正常工作了,郁闷 如果少了以下这句: set nocount on 会报不同的错误
现在的错误是 com.microsoft.sqlserver.jdbc.SQLServerException: 已生成用于更新的结果集。 com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source) com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source) com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source) com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source) com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source) org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73) org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33) org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158) org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638) org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) org.hibernate.event.def.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:186) org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:123) org.hibernate.event.def.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:53) org.hibernate.impl.SessionImpl.fireMerge(SessionImpl.java:677) org.hibernate.impl.SessionImpl.merge(SessionImpl.java:661) org.hibernate.impl.SessionImpl.merge(SessionImpl.java:665) com.lztx.cms.service.systembase.BaseDaoSupport.merge(BaseDaoSupport.java:103) com.lztx.cms.plugin.cmb.action.CMBServiceAction.serviceDoAction(CMBServiceAction.java:156) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.lztx.cms.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:45)
|