java访问sql server 2005的问题.
请教一个问题,现在有三个线程同时对一个表做删除和插入操作,数据库是sql server2005,每次都有个线程失败,错误信息是:
2008-10-9 10:39:28 com.potix.zk.ui.sys.ConfigParser parseClass:188
信息: Using com.potix.zk.ui.http.SerializableUiFactory for interface com.potix.z
k.ui.sys.UiFactory
java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]事务(进程 ID 53)与
另一个进程被死锁在 锁 资源上,并且已被选作死锁牺牲品。请重新运行该事务。
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Sour
ce)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Sour
ce)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown S
ource)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unkn
own Source)
at weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Sour
ce)
at weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Sour
ce)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source
)
at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source
)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStateme
nt.java:128)
at com.excel.ExcelUtil.delOldData(ExcelUtil.java:359)
at com.excel.CommExcelToDb.ToDb(CommExcelToDb.java:142)
at com.ai.biz.upload.servlet.DocUpload.postSavedProcess(DocUpload.java:3
73)
at com.ai.biz.upload.servlet.AbstractUpload.SaveFiles(AbstractUpload.jav
a:150)
at com.ai.biz.upload.servlet.AbstractUpload.doPost(AbstractUpload.java:8
6)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run
(StubSecurityHelper.java:225)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecuri
tyHelper.java:127)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.jav
a:283)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.jav
a:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:3211)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppS
ervletContext.java:1983)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletC
ontext.java:1890)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.j