十万火急!!!插入CLOB大对象时出错!!!

Question

在插入CLOB大对象时会出现"关闭链接的错误"然后下面是一堆由于关闭链接引起的错误异常!!
请高手赐教啊!!!

Answer 1

这是出现的错误:(求助高手的帮助,插入CLOB大对象时出现这种错误.帮忙解决啊!!!java.sql.SQLException: 关闭的连接
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
        at oracle.jdbc.driver.OracleConnection.rollback(OracleConnection.java:14
22)
        at weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_OracleConnect
ion.rollback(Unknown Source)
        at com.mtkj.dao.Dao.rollback(Dao.java:151)
        at com.mtkj.dao.news.NewsDao.insertNews(NewsDao.java:66)
        at com.mtkj.ejb.news.MitNewsBean.insertNews(MitNewsBean.java:37)
        at com.mtkj.ejb.news.MitNews_ifcia8_ELOImpl.insertNews(MitNews_ifcia8_EL
OImpl.java:99)
        at com.mtkj.struts.news.InsertNewsAction.executeAction(InsertNewsAction.
java:56)
        at com.mtkj.struts.BaseAction.execute(BaseAction.java:36)
        at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:484)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148
2)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)        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(ServletStubIm
pl.java:402)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:305)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:6350)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:317)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
118)
        at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3635)
        at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2585)
        at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
java.sql.SQLException: Io 异常: Connection reset
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
        at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:367
5)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1996)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:114
1)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:2149)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:2032)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2894)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:608)
        at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStateme
nt.java:94)
        at com.mtkj.dao.news.NewsDao.insertNews(NewsDao.java:64)
        at com.mtkj.ejb.news.MitNewsBean.insertNews(MitNewsBean.java:37)
        at com.mtkj.ejb.news.MitNews_ifcia8_ELOImpl.insertNews(MitNews_ifcia8_EL
OImpl.java:99)
        at com.mtkj.struts.news.InsertNewsAction.executeAction(InsertNewsAction.
java:56)
        at com.mtkj.struts.BaseAction.execute(BaseAction.java:36)
        at org.apache.struts.action.RequestProcessor.processActionPerform(Reques
tProcessor.java:484)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja
va:274)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148
2)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)        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(ServletStubIm
pl.java:402)
        at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:305)
        at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run(WebAppServletContext.java:6350)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authenticate
dSubject.java:317)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:
118)
        at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:3635)
        at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2585)
        at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
        at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)

Answer 2

需要将club字段值先设置为空的clob ,既 empty_clob() ,然后再更新.