리스트 이미지파일 조인..

 SELECT RNUM,
			    NEWS_SEQ,
			    --USER_EMAIL,
			    NEWS_TITLE,
			    --NEWS_SUBTITLE,
			    --NEWS_CONTENT,
			    --NEWS_DEPARTMENT,
			    --NEWS_SYMPTOM,
			    --NEWS_REG_DATE,
			    --NEWS_UPDATE_DATE,
			    --NEWS_READ_CNT,
			    --NEWS_LIKE_CNT,
			    --NEWS_DEL_FLAG,
			    --NEWS_THUMBNAIL,
                FILE_ORG_NAME,
                FILE_NAME
			    FROM(SELECT ROWNUM RNUM,
			            NEWS_SEQ,
			            USER_EMAIL,
			            NEWS_TITLE,
			            NEWS_SUBTITLE,
			            NEWS_CONTENT,
			            NEWS_DEPARTMENT,
			            NEWS_SYMPTOM,
			            NEWS_REG_DATE,
			            NEWS_UPDATE_DATE,
			            NEWS_READ_CNT,
			            NEWS_LIKE_CNT,
			            NEWS_DEL_FLAG,
			            NEWS_THUMBNAIL,
                        FILE_ORG_NAME,
                        FILE_NAME
			            FROM(SELECT
			                    NVL(A.NEWS_SEQ,'') AS NEWS_SEQ,
			                    NVL(A.USER_EMAIL,'') AS USER_EMAIL,
			                    NVL(A.NEWS_TITLE,'') AS NEWS_TITLE,
			                    NVL(A.NEWS_SUBTITLE,'') AS NEWS_SUBTITLE,
			                    NVL(A.NEWS_CONTENT,'') AS NEWS_CONTENT,
			                    NVL(A.NEWS_DEPARTMENT,'') AS NEWS_DEPARTMENT,
			                    NVL(A.NEWS_SYMPTOM,'') AS NEWS_SYMPTOM,
			                    NVL(A.NEWS_REG_DATE,'') AS NEWS_REG_DATE,
			                    NVL(A.NEWS_UPDATE_DATE,'') AS NEWS_UPDATE_DATE,
			                    NVL(A.NEWS_READ_CNT,'') AS NEWS_READ_CNT,
			                    NVL(A.NEWS_LIKE_CNT,'') AS NEWS_LIKE_CNT,
			                    NVL(A.NEWS_DEL_FLAG,'') AS NEWS_DEL_FLAG,
			                    NVL(A.NEWS_THUMBNAIL,'') AS NEWS_THUMBNAIL,
                                NVL(B.FILE_ORG_NAME,'') AS FILE_ORG_NAME,
                                NVL(B.FILE_NAME,'') AS FILE_NAME
			                FROM TD_NEWS A, TD_NEWS_FILE B
			                WHERE A.NEWS_DEL_FLAG = 'N'
                            AND A.NEWS_SEQ = B.NEWS_SEQ
			               -- AND A.NEWS_DEPARTMENT LIKE '%%'
			               -- OR A.NEWS_SYMPTOM LIKE '%%'
			               -- OR A.NEWS_TITLE LIKE '%%'
			               -- OR A.NEWS_SUBTITLE LIKE '%%'
			               -- OR A.NEWS_CONTENT LIKE '%%'
			                ORDER BY A.NEWS_UPDATE_DATE DESC))
			                --ORDER BY A.NEWS_READ_CNT DESC))
			                --ORDER BY A.NEWS_LIKE_CNT DESC))
			WHERE RNUM >= 1
			  AND RNUM <= 10;

위와 같은 결과물이 나오길래 news_seq로 조인해서 파일이름도 같이 불러와서 list에 담아야겠다 생각했는데,

SELECT RNUM,
			    NEWS_SEQ,
			    USER_EMAIL,
			    NEWS_TITLE,
			    NEWS_SUBTITLE,
			    NEWS_CONTENT,
			    NEWS_DEPARTMENT,
			    NEWS_SYMPTOM,
			    NEWS_REG_DATE,
			    NEWS_UPDATE_DATE,
			    NEWS_READ_CNT,
			    NEWS_LIKE_CNT,
			    NEWS_DEL_FLAG,
			    NEWS_THUMBNAIL,
			    FILE_ORG_NAME,
                FILE_NAME
			    FROM(SELECT ROWNUM RNUM,
			            NEWS_SEQ,
			            USER_EMAIL,
			            NEWS_TITLE,
			            NEWS_SUBTITLE,
			            NEWS_CONTENT,
			            NEWS_DEPARTMENT,
			            NEWS_SYMPTOM,
			            NEWS_REG_DATE,
			            NEWS_UPDATE_DATE,
			            NEWS_READ_CNT,
			            NEWS_LIKE_CNT,
			            NEWS_DEL_FLAG,
			            NEWS_THUMBNAIL,
			            FILE_ORG_NAME,
                		FILE_NAME
			            FROM(SELECT
			                    NVL(A.NEWS_SEQ,'') AS NEWS_SEQ,
			                    NVL(A.USER_EMAIL,'') AS USER_EMAIL,
			                    NVL(A.NEWS_TITLE,'') AS NEWS_TITLE,
			                    NVL(A.NEWS_SUBTITLE,'') AS NEWS_SUBTITLE,
			                    NVL(A.NEWS_CONTENT,'') AS NEWS_CONTENT,
			                    NVL(A.NEWS_DEPARTMENT,'') AS NEWS_DEPARTMENT,
			                    NVL(A.NEWS_SYMPTOM,'') AS NEWS_SYMPTOM,
			                    NVL(A.NEWS_REG_DATE,'') AS NEWS_REG_DATE,
			                    NVL(A.NEWS_UPDATE_DATE,'') AS NEWS_UPDATE_DATE,
			                    NVL(A.NEWS_READ_CNT,'') AS NEWS_READ_CNT,
			                    NVL(A.NEWS_LIKE_CNT,'') AS NEWS_LIKE_CNT,
			                    NVL(A.NEWS_DEL_FLAG,'') AS NEWS_DEL_FLAG,
			                    NVL(A.NEWS_THUMBNAIL,'') AS NEWS_THUMBNAIL,
			                    NVL(B.FILE_ORG_NAME,'') AS FILE_ORG_NAME,
                                NVL(B.FILE_NAME,'') AS FILE_NAME
			                FROM TD_NEWS A, TD_NEWS_FILE B
			                WHERE A.NEWS_DEL_FLAG = 'N'
			    <if test='searchValue != null and searchValue !=""'>
			                AND A.NEWS_DEPARTMENT LIKE '%' || #{searchValue} || '%'
			                OR A.NEWS_SYMPTOM LIKE '%' || #{searchValue} || '%'
			                OR A.NEWS_TITLE LIKE '%' || #{searchValue} || '%'
			                OR A.NEWS_SUBTITLE LIKE '%' || #{searchValue} || '%'
			                OR A.NEWS_CONTENT LIKE '%' || #{searchValue} || '%'
			    </if>
				<if test='newsFilter == "1" or newsFilter == "" or newsFilter == null'>
			                ORDER BY A.NEWS_UPDATE_DATE DESC))
				</if>
				<if test='newsFilter == "2"'>
			                ORDER BY A.NEWS_READ_CNT DESC))
				</if>
				<if test='newsFilter == "3"'>
			                ORDER BY A.NEWS_LIKE_CNT DESC))
				</if>
			WHERE RNUM <![CDATA[>=]]> #{startRow}
			  AND RNUM <![CDATA[<=]]> #{endRow}

 

이렇게 그대로 작성해서 서버를 돌려 실행해보니 가장 최근의 글 news_seq 12에 지금까지 작성한 news_file에 있는 데이터에 대한 fileName이 돌아가며 찍혔다. 

(무슨 말이냐 하면,,,,)

이런 식으로 12개의 Megazines객체가...

 

Megazines.java  dto에는 megazinesFile 참조형객체가 첨부파일 인서트를 위해 있었고, 이 조인문을 위해 fileOrgName과 fileName String 변수도 추가선언해두었었다.

 

무엇이 문제일까....?????