问题描述
一个导出数据的功能把数据导出到excel中weblogic报
解决方案二:
#<2013-12-11上午09时36分46秒CST><Error><WebLogicServer><localhost><AdminServer><[ACTIVE]ExecuteThread:'8'forqueue:'weblogic.kernel.Default(self-tuning)'><<WLSKernel>><><><1386725806626><BEA-000337><[STUCK]ExecuteThread:'0'forqueue:'weblogic.kernel.Default(self-tuning)'hasbeenbusyfor"621"secondsworkingontherequest"weblogic.servlet.internal.ServletRequestImpl@1fbdc5a[GET/survey/manager/export.jsp?sid=21&questionnaireid=36&action=DEM0HTTP/1.1Accept:text/html,application/xhtml+xml,*/*Referer:http://192.168.248.107/survey/manager/countlist.jsp?sid=21&cid=0Accept-Language:zh-CNUser-Agent:Mozilla/5.0(compatible;MSIE9.0;WindowsNT6.1;Trident/5.0)Accept-Encoding:gzip,deflateCookie:WEBUSER_ID=webuser_id1372038678508r2219;Hm_lvt_c0f83d11c5318938a003c0a00dcded64=1385519329,1386040962,1386645361,1386668444;djytheatretype=%E8%88%9E%E8%B9%88_2012.10.21%2C%E8%88%9E%E8%B9%88_2013.11.02%2C%E6%AD%8C%E5%89%A7_2013.10.20%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%88%8F%E5%89%A7_2013.09.14%2C%E6%88%8F%E5%89%A7_2013.08.31%2C%E6%88%8F%E5%89%A7_2013.08.31%2C%E6%88%8F%E5%89%A7_2013.09.14%2C%E8%88%9E%E8%B9%88_2013.08.31%2C%E6%88%8F%E5%89%A7_2013.08.31%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.10.20%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E6%AD%8C%E5%89%A7_2013.09.08%2C%E9%9F%B3%E4%B9%90_2013.09.05%2C%E9%9F%B3%E4%B9%90_2013.08.31%2C%E9%9F%B3%E4%B9%90_2013.09.04%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E9%9F%B3%E4%B9%90_2013.09.18%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2012.04.08%2C%E6%AD%8C%E5%89%A7_2013.12.01%2C%E9%9F%B3%E4%B9%90_2013.09.30%2C%E9%9F%B3%E4%B9%90_2013.09.30%2C%E9%9F%B3%E4%B9%90_2013.09.30%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E9%9F%B3%E4%B9%90_2013.10.07%2C%E6%88%8F%E6%9B%B2_2013.10.07%2C_%2C%E9%9F%B3%E4%B9%90_2013.11.10%2C%E6%88%8F%E6%9B%B2_2014.03.12%2C%E6%88%8F%E6%9B%B2_2014.03.12%2C%E8%88%9E%E8%B9%88_2014.01.08%2C%E6%AD%8C%E5%89%A7_2014.03.17%2C%E6%88%8F%E5%89%A7_2014.02.03%2C%E9%9F%B3%E4%B9%90_2014.03.09%2C%E9%9F%B3%E4%B9%90_2014.01.09%2C%E8%88%9E%E8%B9%88_2014.02.04%2C%E6%AD%8C%E5%89%A7_2013.12.01%2C_2014.10.02%2C%E8%88%9E%E8%B9%88_2013.12.10%2C%E9%9F%B3%E4%B9%90_2014.03.05%2C%E9%9F%B3%E4%B9%90_2013.12.30%2C%E9%9F%B3%E4%B9%90_2013.12.30%2C%E8%88%9E%E8%B9%88_2013.12.27;looyu_id=9c9cea7ffe15c4ac10d621c1b6e95a5103_46802%3A92;JSESSIONID=cwn0Sn8CZrLp3T1LFBlRTY4DQGBcZnkkZCT4fPWvhdhPn2tkcQfY!-1639107784Connection:Keep-AliveProxy-Client-IP:192.168.23.109X-Forwarded-For:192.168.23.109X-WebLogic-KeepAliveSecs:30X-WebLogic-Force-JVMID:-1639107784]",whichismorethantheconfiguredtime(StuckThreadMaxTime)of"600"seconds.Stacktrace:java.net.SocketInputStream.socketRead0(NativeMethod)java.net.SocketInputStream.read(SocketInputStream.java:129)oracle.net.ns.Packet.receive(Packet.java:293)oracle.net.ns.DataPacket.receive(DataPacket.java:92)oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:174)oracle.net.ns.NetInputStream.read(NetInputStream.java:119)oracle.net.ns.NetInputStream.read(NetInputStream.java:94)oracle.net.ns.NetInputStream.read(NetInputStream.java:79)oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1040)oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1016)oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:589)oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9273)oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9373)oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:34)org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2204)org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2118)org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2374)org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:84)org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:951)org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:109)org.hibernate.impl.SessionImpl.list(SessionImpl.java:1086)org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)ehm.db.DataHelper.getQuery(DataHelper.java:237)ehm.db.DataHelper.getList(DataHelper.java:122)ehm.web.survey.app.Export.getAnswer(Export.java:102)ehm.web.survey.app.Export.getAnswer1(Export.java:317)ehm.web.survey.app.Export.getReportnew(Export.java:262)ehm.web.survey.app.Export.getPage(Export.java:72)jsp_servlet._survey._manager.__export._jspService(__export.java:76)weblogic.servlet.jsp.JspBase.service(JspBase.java:34)weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3683)weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)weblogic.work.ExecuteThread.run(ExecuteThread.java:173)>请大侠们指教该如何解决!
解决方案
解决方案三:
该回复于2013-12-11 22:03:00被版主删除
解决方案四:
请求超时?把数据量调小一下试试