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