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

####<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)

评论

1 楼 anlinew 2008-10-31  

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