Oracle大阪分公司,急!各位大板主我看看!问题所在!

在执行Weblogic应用时遇到数据库错误,具体为Oracle JDBC驱动抛出SQLException,指出在尝试插入数据到表QSDB.PK_QS_JL_SBZB时违反了唯一约束。错误源于com.creationstar.bjtax.qsgl包下的DAO和Processor类。问题可能在于尝试插入的数据已存在,导致唯一键约束失败。

weblogic错误日至:

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2349)

at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1757)

at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1915)

at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)

at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)

at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:68)

at com.creationstar.bjtax.qsgl.BizLogic.dao.SbzbDAO.insert(SbzbDAO.java:101)

at com.creationstar.bjtax.qsgl.BizLogic.processor.SbGrProcessor.doInsert(SbGrProcessor.java:135)

at com.creationstar.bjtax.qsgl.BizLogic.processor.SbGrProcessor.process(SbGrProcessor.java:61)

at com.creationstar.bjtax.qsgl.BizLogic.ejb.QsglSessionBean.process(QsglSessionBean.java:61)

at com.creationstar.bjtax.qsgl.BizLogic.ejb.QsglSessionBean_aqfaow_EOImpl.process(QsglSessionBean_aqfaow_EOImpl.java:46)

at com.creationstar.bjtax.qsgl.BizLogic.ejb.QsglSessionBean_aqfaow_EOImpl_WLSkel.invoke(Unknown Source)

at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:166)

at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:284)

at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:244)

at com.creationstar.bjtax.qsgl.BizLogic.ejb.QsglSessionBean_aqfaow_EOImpl_812_WLStub.process(Unknown Source)

at com.creationstar.bjtax.qsgl.proxy.QsglProxy.process(QsglProxy.java:94)

at com.creationstar.bjtax.qsgl.VisionLogic.action.AddSbgrAction.doSave(AddSbgrAction.java:166)

at sun.reflect.GeneratedMethodAccessor14738.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.creationstar.bjtax.qsgl.VisionLogic.action.Base.BaseAction.perform(BaseAction.java:192)

at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1787)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1586)

at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:971)

at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:402)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)

at com.ttsoft.common.web.filter.OperationPermissionFilter.doFilter(OperationPermissionFilter.java:83)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)

at com.ttsoft.common.web.filter.BusinessPermissionFilter.doFilter(BusinessPermissionFilter.java:203)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)

at com.ttsoft.common.web.filter.LoginFilter.doFilter(LoginFilter.java:241)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6356)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)

at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3635)

at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2585)

at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)

at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)

java.sql.SQLException: ORA-00001: unique constraint (QSDB.PK_QS_JL_SBZB) violated

[本帖最后由 gy1982329 于 2009-6-10 11:46 编辑]

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值