错误信息如下Q?/span>
过最大长度限?/span>
处理Q?/span>
只能插入666个中文字W?/span>
或者更新到最新的oracle驱动?/span>
]]>
jdbc在操?/span>oracle量数据的时候用ResultSet获取所有的q回数据出现内存溢出
处理Q?br />
出错的原因是ResultSet用的是可滚动l果集，正常情况?/span>ResultSet是指针指向数据库的数据，本n是不存储数据库的数据的，默认情况下就是提交?/span>sql能查询处上亿条的数据也是不消耗内存的Q但是如果用的是可滚动结果集?/span>ResultSet情况׃一样了Q?/span>ORACLE ?/span>不支持可滚动l果集的Q那么我们用JDBC得到一个可滚动的结果集是?/span>JDBC自己支持的，也就是说l果集是要存攑֜内存中的Q所以在量数据的情况下也就是要消耗大量内存的Q因此造成内存溢出也就是正常的了，所以如果是量数据的话׃要用可滚动结果集可以了?/span>
]]>
com.ibm.websphere.ce.cm.StaleConnectionException: [ibm][db2][jcc][t4][2030][11211]
到了通信错误。所使用的通信协议Q?/span>TCP/IP?/span>"n所使用的通信 APIQ?/span>SOCKETS?/span>
到错误的位|：Reply.fill()?/span>"n用于错误的通信功能Q?/span>InputStream.read()?/span>
特定于协议的错误代码数据不?/span>* ?/span> 0。消息：null"n
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)"n
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:67)"n at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstructorAccessorImpl.java:45)"n
at java.lang.reflect.Constructor.newInstance(Constructor.java:522)"n
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper
(GenericDataStoreHelper.java:523)"n
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:578)"n
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:909)"n
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:898)"n
at com.newland.bi.util.db.DBUtil.executeQuery(Unknown Source)"n
at com.newland.bi.util.db.DBUtil.executeSql(Unknown Source)"n
at com.newland.bi.dao.jdbc.DaoImpl.executeQuery(DaoImpl.java:64)"n
at com.newland.bi.service.report.exp.dao.ReportExpDao.getExpList(ReportExpDao.java:72)"n
at com.newland.bi.service.report.exp.manage.ReportExpMgt.runExport(ReportExpMgt.java:91)"n
at com.newland.bi.service.report.exp.servlet.ReportExp1Servlet$1.run(ReportExp1Servlet.java:97)"n
at java.util.TimerThread.mainLoop(Timer.java:537)"n at java.util.TimerThread.run(Timer.java:487)"n
处理Q?br />
出错的原因可能是防火墙问?/span>,?/span>websphere应用服务器和数据库服务器之间是否存在防火?/span>
防火墙是否会讄多久没活动的q接p动断开?/span>,如果是这L话就会有问题,因ؓwebsphere上面的数据库q接池可能有一D|间没q接而被防火墙断掉了
但对于连接池本nҎ׃知道该连接是否还可用,所?/span>web应用从连接池获取的连接可能就是已l断开的了,所以就可能会出现日C的错误问?br />
]]>
Caused by: java.lang.ClassNotFoundException: org.apache.axis.soap.MessageFactoryImpl
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at javax.xml.soap.MessageFactory.newInstance(MessageFactory.java:50)
... 10 more
处理Q?/span>
原因是调用了axis?/span> soap.MessageFactoryImpl,cxf应该用的?/span>sun?br /> 在注册安全拦截器之前执行下面代码可以了
System.setProperty("javax.xml.soap.MessageFactory", "com.sun.xml.messaging.saaj.soap.ver1_1.SOAPMessageFactory1_1Impl");
]]>
1.下蝲面
open(action执行面,'iframeName','');<a id="tempB" style="display:none" href="#" onclick=""> </a><iframe width=0 height=0 id="hideIframe" name="hideIframe"></iframe>
<script>
var n=0;
function go(url){
n==0?new function() { frames("hideIframe").location=url,n=1
}:null; document.all("hideIframe").readyState!="complete"?setTimeout(go,10):so(); function so() { frames("hideIframe").document.execCommand("SaveAs"),n=0 }; } var tempB = document.getElementById("tempB"); <% if(path.toLowerCase().indexOf(".txt")>=0){ %> tempB.attachEvent('onclick',function(){go('<%=request.getContextPath()+"/tempfile/1.txt">');}); <% }else{ %> tempB.attachEvent('onclick',function(){open('<%=request.getContextPath()+"/tempfile/1.xls">','','');}); <% } %>
tempB.click();</script>]]>
]]>
然后再{向某个页?q样可能D~码格式冲突,Dq
可以先给resonse讄下编码格?然后在write
HttpServletResponse httpServletResponse = (HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();
httpServletResponse.setContentType("text/html; charset=gb2312");
httpServletResponse.setCharacterEncoding("gb2312");
httpServletResponse.getWriter().write("");
q样应该可以解决了
]]>