TOP
아이파크몰 멤버십

데이터 처리 중 오류가 발생하였습니다.

### Error querying database. Cause: java.sql.SQLException: Connection PoolingConnection: null is closed. ### The error may exist in class path resource [sqlMap/shop/ShopMapper.xml] ### The error may involve kr.co.iparkmall.members.web.shop.dao.ShopMapper.selectChnlFlInfo ### The error occurred while executing a query ### SQL: SELECT /* selectChnlFlInfo */ A.chnlLc, A.chnlLc_nm, A.chnlFl, ( SELECT DISTINCT STUFF(( SELECT '/' + ctg_nm FROM ubi.VIEW_BRAND SUB WHERE 1=1 and SUB.chnlLc = MAIN.chnlLc and SUB.chnlFl = MAIN.chnlFl group by SUB.ctg_nm, SUB.chnlLc, SUB.chnlFl FOR XML PATH('') ),1,1,'') AS NAME FROM ubi.VIEW_BRAND MAIN where MAIN.ctg_nm is not null and chnlLc = A.chnlLc and chnlFl = A.chnlFl ) as ctg_nm FROM ubi.VIEW_BRAND A WHERE (chnlLc is not null AND chnlLc_nm is not null) AND chnlLc = ? AND chnlShowYn = 'Y' GROUP BY chnlLc, chnlLc_nm, chnlFl ORDER BY chnlLc, chnlFl DESC ### Cause: java.sql.SQLException: Connection PoolingConnection: null is closed. ; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Connection PoolingConnection: null is closed.; nested exception is java.sql.SQLException: Connection PoolingConnection: null is closed.