java连oracle异常，请帮忙看下，谢谢！

lixinxingjava 2011-02-22 09:21:48

业务是这样的，有外部系统调用我们系统进行CRUD操作，但是在查询某个SQL的时候有时会报错，但大部分是正确的，代码就是在connection.creatStatment() 处报的异常(就是下面的AutoSQLExecutor.java:1153)，在后面也进行了关闭操作，日志堆栈如下：

[2011-02-09 03:55:33.691] [FINE] [portal] [AutoSQLExecutor.java:1148] [ ] [SQL: select description,countryCode,areaCode from AreaNumber]
[2011-02-09 03:55:33.735] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [districtID = null]
[2011-02-09 03:55:33.736] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [bearMode = null]
[2011-02-09 03:55:33.737] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [endAddrStr = null]
[2011-02-09 03:55:33.738] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [endIPAddr = null]
[2011-02-09 03:55:33.739] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [netMask = null]
[2011-02-09 03:55:33.739] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [startAddrStr = null]
[2011-02-09 03:55:33.740] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [startIPAddr = null]
[2011-02-09 03:55:33.741] [FINE] [portal] [AutoSQLExecutor.java:1148] [ ] [SQL: select

districtID,bearMode,endAddrStr,endIPAddr,netMask,startAddrStr,startIPAddr from iprangepartition]
[2011-02-09 03:55:33.758] [WARNING] [portal] [AutoSQLExecutor.java:1170] [ ] [query error: java.sql.SQLException: Io exception: Broken pipe.
(SQL: select districtID,bearMode,endAddrStr,endIPAddr,netMask,startAddrStr,startIPAddr from iprangepartition)]
[2011-02-09 03:55:33.762] [WARNING] [portal] [AutoSQLExecutor.java:1173] [ ] [java.sql.SQLException: Io exception: Broken pipe 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:333)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:389)
at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:772)
at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:712)
at org.jboss.resource.adapter.jdbc.WrappedConnection.createStatement(WrappedConnection.java:122)
at com.lxx.portal.util.database.AutoSQLExecutor.query(AutoSQLExecutor.java:1153)
at com.lxx.portal.util.database.DBMgr.query(DBMgr.java:452)
at com.lxx.portal.wsi.service.BaseServiceImpl.loadIPRanges(BaseServiceImpl.java:74)
at com.lxx.portal.wsi.service.BaseServiceImpl.<init>(BaseServiceImpl.java:45)
at com.lxx.portal.wsi.axis.AxisServlet.doPost(AxisServlet.java:795)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at com.lxx.portal.wsi.axis.AxisServletBase.service(AxisServletBase.java:282)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)
]
[2011-02-09 03:55:33.864] [FINE] [portal] [AutoSQLExecutor.java:1148] [ ] [SQL: select districtID,areaName from AreaInfo where districtID like '%10000000%'

]
[2011-02-09 03:55:36.521] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [districtID = null]
[2011-02-09 03:55:36.522] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [bearMode = null]
[2011-02-09 03:55:36.522] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [endAddrStr = null]
[2011-02-09 03:55:36.523] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [endIPAddr = null]
[2011-02-09 03:55:36.524] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [netMask = null]
[2011-02-09 03:55:36.525] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [startAddrStr = null]
[2011-02-09 03:55:36.526] [INFO] [portal] [BasicPortalInfo.java:257] [ ] [startIPAddr = null]

...全文