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

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

    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