The column name is invalid 1
[IBATIS] The column name is invalid ์—๋Ÿฌํ•ด๊ฒฐ

IBATIS๋ฅผ ์ด์šฉํ•ด์„œ ๋™์ ์œผ๋กœ ์ปฌ๋Ÿผ๋ช…์„ ์‚ฌ์šฉํ• ๋•Œ The column name is invalid ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ์Šต๋‹ˆ๋‹ค. ํ•ด๋‹น๊ตฌ๋ฌธ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์•˜์Šต๋‹ˆ๋‹ค. SELECT count(*) as qrtr_$rp_datatype$ FROM tb_q_$rp_datatype$ WHERE RP_USER_CD = #rp_user_cd# AND RP_YEAR = #rp_year# AND RP_TERM = #rp_term# GROUP BY RP_YEAR, RP_TERM, RP_USER_CD ๋”ฑ๋ดค์„๋•Œ๋Š” ์ „ํ˜€ ์ด์ƒ์ด ์—†์–ด๋ณด์˜€๊ณ , ์ฒ˜์Œ ์‹คํ–‰์‹œ์—๋Š” ์˜ค๋ฅ˜๋„ ๋‚˜์ง€ ์•Š์•˜์Šต๋‹ˆ๋‹ค. ํ•˜์ง€๋งŒ ์ด์ƒํ•˜๊ฒŒ ๋‘๋ฒˆ์งธ ์‹คํ–‰ํ• ๋•Œ๋ถ€ํ„ฐ๋Š” ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค... WAS์žฌ๊ธฐ๋™ ํ›„ ์‹คํ–‰ํ•˜๋ฉด ๋˜ ์ฒ˜์Œ์—” ์ž˜๋˜๋Š”๋ฐ, ๋‘๋ฒˆ์งธ๋Š” ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ์Šต๋‹ˆ๋‹ค. ๋„๋Œ€์ฒด ์–ด๋””๊ฐ€ ์ž˜๋ชป๋œ๊ฑด์ง€...
๊ฐœ๋ฐœ/DATABASE 2023.08.03
1
๋”๋ณด๊ธฐ

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”