紧急求助,weblogic报错“超出系统资源”,不明原因,击溃服务器——在线等!
报错信息如下,涉及到从excel读取数据的每个方法的结尾都在finally中写了关闭resultset,statement和connection的语句。
在我本机测试没有发现过问题,但是发布到服务器上最近连续出现好几次,而且还击溃服务器两次,开始并没有发生过错误,重启服务器以后有时也能正常运行,错误好象是偶然的。
紧急求助,在线等,谢谢各位达淫!
java.sql.SQLException: [Microsoft][ODBC Excel Driver] 超出系统资源。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JJJ)Ljava.sql.SQLException;
(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(SJJJ)V(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JLjava.lang.String;)V(JdbcOdb
c.java:3028)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Ljava.lang.String;Ljava.u
til.Properties;I)V(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Ljava.lang.String;Ljava.util.Pro
perties;)Ljava.sql.Connection;(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Pro
perties;Ljava.lang.ClassLoader;)Ljava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;)Ljava.sql.Con
nection;(Unknown Source)
at ppsys.proplan.server.BusiScheduleBean.setPrjView()I(BusiScheduleBean.
java:138)
at ppsys.proplan.server.BusiScheduleBean.insertFileContent(Ljava.lang.St
ring;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Lja
va.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)[I(BusiSch
eduleBean.java:90)
at ppsys.proplan.server.BusiSchedule_s7mlw0_EOImpl.insertFileContent(Lja
va.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.
String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)
[I(BusiSchedule_s7mlw0_EOImpl.java:506)
at ppsys.proplan.server.BusiSchedule_s7mlw0_EOImpl_WLSkel.invoke(I[Ljava
.lang.Object;Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive()Lweblogic.rmi.spi.In
boundResponse;(ServerRequest.java:166)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Lweblogic.rmi.exten
sions.server.RemoteReference;Lweblogic.rmi.extensions.server.RuntimeMethodDescri
ptor;[Ljava.lang.Object;Ljava.lang.reflect.Method;)Ljava.lang.Object;(ReplicaAwa
reRemoteRef.java:284)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Ljava.rmi.Remote;Lw
eblogic.rmi.extensions.server.RuntimeMethodDescriptor;[Ljava.lang.Object;Ljava.l
ang.reflect.Method;)Ljava.lang.Object;(ReplicaAwareRemoteRef.java:244)
at ppsys.proplan.server.BusiSchedule_s7mlw0_EOImpl_811_WLStub.insertFile
Content(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;
Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.la
ng.String;)[I(Unknown Source)
at jsp_servlet._proplan.__pguploadscheduleop._jspService(Ljavax.servlet.
http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(__pguploadsch
eduleop.java:191)
at weblogic.servlet.jsp.JspBase.service(Ljavax.servlet.ServletRequest;Lj
avax.servlet.ServletResponse;)V(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servle
t.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.Filte
rChainImpl;)V(Optimized Method)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servle
t.ServletRequest;Ljavax.servlet.ServletResponse;)V(ServletStubImpl.java:305)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationActio
n.run()Ljava.lang.Object;(WebAppServletContext.java:6310)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Lweblogic.se
curity.subject.AbstractSubject;Ljava.security.PrivilegedAction;)Ljava.lang.Objec
t;(Optimized Method)
at weblogic.security.service.SecurityManager.runAs(Lweblogic.security.ac
l.internal.AuthenticatedSubject;Lweblogic.security.acl.internal.AuthenticatedSub
ject;Ljava.security.PrivilegedAction;)Ljava.lang.Object;(SecurityManager.java:11
8)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(Lweblogi
c.servlet.internal.ServletRequestImpl;Lweblogic.servlet.internal.ServletResponse
Impl;)V(WebAppServletContext.java:3622)
at weblogic.servlet.internal.ServletRequestImpl.execute(Lweblogic.kernel
.ExecuteThread;)V(ServletRequestImpl.java:2569)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest
;)V(Optimized Method)
at weblogic.kernel.ExecuteThread.run()V(ExecuteThread.java:170)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Sourc
e)
java.sql.SQLException: [Microsoft][ODBC Excel Driver] 超出系统资源。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JJJ)Ljava.sql.SQLException;
(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(SJJJ)V(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JLjava.lang.String;)V(JdbcOdb
c.java:3028)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Ljava.lang.String;Ljava.u
til.Properties;I)V(JdbcOdbcConnection.java:323)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Ljava.lang.String;Ljava.util.Pro
perties;)Ljava.sql.Connection;(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Pro
perties;Ljava.lang.ClassLoader;)Ljava.sql.Connection;(Unknown Source)
at java.sql.DriverManager.getConnection(Ljava.lang.String;)Ljava.sql.Con
nection;(Unknown Source)
at ppsys.proplan.server.BusiScheduleBean.setPrjSchedule()I(BusiScheduleB
ean.java:221)
at ppsys.proplan.server.BusiScheduleBean.insertFileContent(Ljava.lang.St
ring;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Lja
va.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)[I(BusiSch
eduleBean.java:91)
at ppsys.proplan.server.BusiSchedule_s7mlw0_EOImpl.insertFileContent(Lja
va.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.
String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;)
[I(BusiSchedule_s7mlw0_EOImpl.java:506)
at ppsys.proplan.server.BusiSchedule_s7mlw0_EOImpl_WLSkel.invoke(I[Ljava
.lang.Object;Ljava.lang.Object;)Ljava.lang.Object;(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive()Lweblogic.rmi.spi.In
boundResponse;(ServerRequest.java:166)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Lweblogic.rmi.exten
sions.server.RemoteReference;Lweblogic.rmi.extensions.server.RuntimeMethodDescri
ptor;[Ljava.lang.Object;Ljava.lang.reflect.Method;)Ljava.lang.Object;(ReplicaAwa
reRemoteRef.java:284)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(Ljava.rmi.Remote;Lw
eblogic.rmi.extensions.server.RuntimeMethodDescriptor;[Ljava.lang.Object;Ljava.l
ang.reflect.Method;)Ljava.lang.Object;(ReplicaAwareRemoteRef.java:244)
at ppsys.proplan.server.BusiSchedule_s7mlw0_EOImpl_811_WLStub.insertFile
Content(Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;
Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.lang.String;Ljava.la
ng.String;)[I(Unknown Source)
at jsp_servlet._proplan.__pguploadscheduleop._jspService(Ljavax.servlet.
http.HttpServletRequest;Ljavax.servlet.http.HttpServletResponse;)V(__pguploadsch
eduleop.java:191)
at weblogic.servlet.jsp.JspBase.service(Ljavax.servlet.ServletRequest;Lj
avax.servlet.ServletResponse;)V(JspBase.java:33)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Ljavax.servle
t.ServletRequest;Ljavax.servlet.ServletResponse;Lweblogic.servlet.internal.Filte
rChainImpl;)V(Optimized Method)