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