WEBLOGIC连接池老是被重建，找了很多地方还是没有发现根本原因，请大家发表下各自的看法吧...

最新推荐文章于 2022-07-07 17:02:08 发布

CJW521

最新推荐文章于 2022-07-07 17:02:08 发布

阅读量307

点赞数

分类专栏： Struts、Spring、Ajax、Ibatis 文章标签： Weblogic SQL Java .net JDBC

Struts、Spring、Ajax、Ibatis 专栏收录该内容

7 篇文章 0 订阅

订阅专栏


####<2008-10-29 下午05时50分17秒 CST> <Info> <JDBC> <xjd16> <bstServer> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "xjbst1" closed.> 
####<2008-10-29 下午05时50分17秒 CST> <Info> <JDBC> <xjd16> <bstServer> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "xjbst1" closed.> 
####<2008-10-29 下午05时50分17秒 CST> <Info> <JDBC> <xjd16> <bstServer> <Thread-9> <<WLS Kernel>> <> <BEA-001128> <Connection for pool "xjbst1" closed.> 
####<2008-10-29 下午05时55分57秒 CST> <Error> <HTTP> <xjd16> <bstServer> <ExecuteThread: '37' for queue: 'weblogic.kernel.Default'> <<WLS Kernel>> <> <BEA-101017> <[ServletContext(id=36779662,name=besttone,context-path=/besttone)] Root cause of ServletException.
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT RES.ROWNUMS,RES.ENTERPRISENAME,RES.TEL,RES.SECTIONNAME,RES.INTRODUCT FROM(SELECT ROWNUM ROWNUMS, ENTERPRISENAME,REG_TELEPHONE TEL,SEC.SECTION_NAME SECTIONNAME,REG_BUSINTRODUCT INTRODUCT FROM T_REGEISTBUSINESS REG,(SELECT SECTION_ID,SECTION_NAME FROM XJ_SECTION_BASE_INFO BASEINFO WHERE BASEINFO.SECTION_ID=(SELECT SECTION_ID FROM XJ_TEL_SECTION_RELA WHERE TEL='2311572' AND t_area_id='XJWL00'))SEC WHERE REG.SECTIONID=SEC.SECTION_ID) RES WHERE RES.ROWNUMS > 4 AND RES.ROWNUMS<=5]; SQL state [21000]; error code [1427]; ORA-01427: single-row subquery returns more than one row
; nested exception is java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

####<2008-10-29 下午06时50分33秒 CST> <Error> <HTTP> <xjd16> <bstServer> <ExecuteThread: '16' for queue: 'weblogic.kernel.Default'> <<WLS Kernel>> <> <BEA-101017> <[ServletContext(id=36779662,name=besttone,context-path=/besttone)] Root cause of ServletException.
java.net.SocketException: Connection reset
	at java.net.SocketInputStream.read(SocketInputStream.java:168)