SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in sqlmap/ORACLEORG/cakStructure2.xml.
--- The error occurred while executing query.
--- Check the
SELECT ORG.C_OIORGCODE AS cOiorgcode,
ODR.C_UIUSERKEY AS cUiuserkey,
ORG.C_OIORGNAME AS cOiorgname,
ORG.C_OIFAXNUM AS cOifaxnum,
USR.C_UIUSERNAME AS cUiusername,
ODR.C_OIJOBMEMO AS cOijobmemo,
ODR.C_CIKEYCODE AS cCikeycode,
(SELECT C_CINAME1
FROM T_COMMONINFO
WHERE C_CIFLAGCODE = 'A00'
AND C_CIKEYCODE = ODR.C_CIKEYCODE
GROUP BY C_CINAME1
) AS cCiname1,
(SELECT C_UDCTELNUM
FROM T_USERDETAILINFO
WHERE C_UIUSERKEY = USR.C_UIUSERKEY
GROUP BY C_UDCTELNUM
) AS cUdctelnum,
SUM(1) OVER (PARTITION BY ORG.C_OIORGCODE) TOTAL_COUNT,
ODR_RNK.RANK AS DEPT_ORDER
FROM T_ORDERINFO ODR,
T_ORGANINFO ORG,
T_USERINFO USR,
T_ORDERRANK ODR_RNK
WHERE ODR.C_OIORGCODE = ORG.C_OIORGCODE
AND ODR.C_UIUSERKEY = USR.C_UIUSERKEY
AND ORG.C_OIORGNAME = ODR_RNK.NAME
AND ( USR.C_CIHOLDFLAG IS NULL OR USR.C_CIHOLDFLAG != 'd')
AND ODR.C_CIKEYCODE != '000'
AND ORG.C_OIORGCODE = ?
ORDER BY DEPT_ORDER, ODR.C_CIKEYCODE DESC, USR.C_UICLASSDAY
.
--- Check the SQL Statement (preparation failed).
--- Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (IO 예외 상황: Got minus one from a read call); nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/ORACLEORG/cakStructure2.xml.
--- The error occurred while executing query.
--- Check the
SELECT ORG.C_OIORGCODE AS cOiorgcode,
ODR.C_UIUSERKEY AS cUiuserkey,
ORG.C_OIORGNAME AS cOiorgname,
ORG.C_OIFAXNUM AS cOifaxnum,
USR.C_UIUSERNAME AS cUiusername,
ODR.C_OIJOBMEMO AS cOijobmemo,
ODR.C_CIKEYCODE AS cCikeycode,
(SELECT C_CINAME1
FROM T_COMMONINFO
WHERE C_CIFLAGCODE = 'A00'
AND C_CIKEYCODE = ODR.C_CIKEYCODE
GROUP BY C_CINAME1
) AS cCiname1,
(SELECT C_UDCTELNUM
FROM T_USERDETAILINFO
WHERE C_UIUSERKEY = USR.C_UIUSERKEY
GROUP BY C_UDCTELNUM
) AS cUdctelnum,
SUM(1) OVER (PARTITION BY ORG.C_OIORGCODE) TOTAL_COUNT,
ODR_RNK.RANK AS DEPT_ORDER
FROM T_ORDERINFO ODR,
T_ORGANINFO ORG,
T_USERINFO USR,
T_ORDERRANK ODR_RNK
WHERE ODR.C_OIORGCODE = ORG.C_OIORGCODE
AND ODR.C_UIUSERKEY = USR.C_UIUSERKEY
AND ORG.C_OIORGNAME = ODR_RNK.NAME
AND ( USR.C_CIHOLDFLAG IS NULL OR USR.C_CIHOLDFLAG != 'd')
AND ODR.C_CIKEYCODE != '000'
AND ORG.C_OIORGCODE = ?
ORDER BY DEPT_ORDER, ODR.C_CIKEYCODE DESC, USR.C_UICLASSDAY
.
--- Check the SQL Statement (preparation failed).
--- Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (IO 예외 상황: Got minus one from a read call) |
|