MyBatis์˜ ResultHandler๋ฅผ ํ†ตํ•ด POI SXSSF๋กœ ๋Œ€์šฉ๋Ÿ‰ ์—‘์…€ํŒŒ์ผ ๋งŒ๋“ค๊ธฐ

๋ชฉ์ฐจ MyBatis์˜ ResultHandler๋ฅผ ํ†ตํ•ด POI SXSSF๋กœ ๋Œ€์šฉ๋Ÿ‰ ์—‘์…€ํŒŒ์ผ ๋งŒ๋“ค๊ธฐ ๊ฐœ๋ฐœํ™˜๊ฒฝ SpringBoot 2.6.2 JAVA 1.8 Gradle 7.3.2 IntelliJ ์ •์‚ฐ ๋ฐ์ดํ„ฐ๋ฅผ ์—‘์…€ํŒŒ์ผ๋กœ ๋งŒ๋“œ๋Š” ๊ณผ์ •์—์„œ ์ ์€ ๊ฑด์ˆ˜๋ฅผ ๋งŒ๋“ค๋•Œ๋Š” ์ด์Šˆ๊ฐ€ ์—†์—ˆ์ง€๋งŒ ๋ช‡์‹ญ๋งŒ ๊ฑด ๋˜๋Š” ๋ช‡๋ฐฑ๋งŒ๊ฑด์˜ ๋ฐ์ดํ„ฐ๋ฅผ ํ•œ๋ฒˆ์— ํ˜ธ์ถœํ•˜๊ฒŒ ๋˜๋ฉด์„œ OOM์„ ๋งŒ๋‚˜๊ฒŒ ๋˜์–ด ์—‘์…€ํŒŒ์ผ๋กœ ์ €์žฅ์„ ํ•  ์ˆ˜๊ฐ€ ์—†์—ˆ์Šต๋‹ˆ๋‹ค. MyBatis๋ฅผ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋‹ค๋ฉด MyBatis์—์„œ ์ œ๊ณตํ•˜๋Š” ResultHandler๋ฅผ ์ด์šฉํ•˜๋ฉด ๋ช‡๋ฐฑ๋งŒ๊ฑด์˜ ๋ฐ์ดํ„ฐ๋ฅผ ํ•œ๋ฒˆ์— ํ˜ธ์ถœํ•˜์ง€ ์•Š๊ณ  ๋ ˆ์ฝ”๋“œ๋ณ„๋กœ ๋‹ค๋ฃฐ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. https://mybatis.org/mybatis-3/ko/java-api.html#SqlSession (์•„๋ž˜ ResultHandler ์ฐธ๊ณ ) ๋‹ค์Œ์€ ๊ฐ€์ง€๊ณ  ..

๋ฆฌ๋ˆ…์Šค history - ์ด์ „ ์‚ฌ์šฉํ–ˆ๋˜ ๋ช…๋ น์–ด ํ™•์ธ ๋ฐ ์žฌ์‚ฌ์šฉ

๋ฆฌ๋ˆ…์Šค history - ์ด์ „ ์‚ฌ์šฉํ–ˆ๋˜ ๋ช…๋ น์–ด ํ™•์ธ ๋ฐ ์žฌ์‚ฌ์šฉ ๋ฆฌ๋ˆ…์Šค ์ฝ˜์†”, ํ„ฐ๋ฏธ๋„ ํ™˜๊ฒฝ์—์„œ ์ด์ „์— ์‚ฌ์šฉํ•œ ๋ช…๋ น์–ด๋ฅผ ํ™•์ธํ•˜๊ณ  ์ด์ „์— ์ž…๋ ฅํ–ˆ๋˜ ๋ช…๋ น์–ด๋ฅผ ๋‹ค์‹œ ์ž…๋ ฅํ•  ํ•„์š”์—†์ด ์ฐพ์•„์„œ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋ช…๋ น์–ด #์ด์ „์— ์‚ฌ์šฉํ–ˆ๋˜ ๋ช…๋ น์–ด ํ™•์ธ $history #๊ฐ€์žฅ ์ตœ๊ทผ์— ์‚ฌ์šฉํ•œ 3๊ฐœ์˜ ๋ช…๋ น์–ด๋ฅผ ํ™•์ธํ•ฉ๋‹ˆ๋‹ค. $history 3 #grep ๋ช…๋ น์„ ํ•จ๊ป˜ ์‚ฌ์šฉํ•˜์—ฌ history ๋ช…๋ น์„ ๊ฒ€์ƒ‰ํ• ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. $history | grep ps #ํžˆ์Šคํ† ๋ฆฌ ์‚ญ์ œ $history -c history ๋ช…๋ น์–ด ์žฌ์‚ฌ์šฉ #history ๋ช…๋ น์–ด๋ฅผ ์ž…๋ ฅํ•˜์—ฌ ์žฌ์‚ฌ์šฉํ•˜๊ณ  ์‹ถ์€ ๋ผ์ธ๋ฒˆํ˜ธ๋ฅผ ์ž…๋ ฅํ›„ Enter $!1171 #์—”ํ„ฐ๋ฅผ ์น˜๋ฉด ์Šค์ƒท๊ณผ ๊ฐ™์ด ํ•ด๋‹น๋ผ์ธ์˜ ๋ช…๋ น์–ด๋กœ ์น˜ํ™˜๋˜์–ด์žˆ๋‹ค $ps -ef | grep https

grep ํŒจํ„ด๊ฒ€์ƒ‰

grep ํŒจํ„ด๊ฒ€์ƒ‰ grep ๋ช…๋ น์€ ํŒŒ์ผ ๋‚ด์—์„œ ์ง€์ •ํ•œ ํŒจํ„ด์ด๋‚˜ ๋ฌธ์ž์—ด์„ ์ฐพ์€ ํ›„ ๊ทธ ํŒจํ„ด์„ ํฌํ•จํ•˜๊ณ  ์žˆ๋Š” ๋ชจ๋“  ํ–‰์„ ํ‘œ์ค€ ์ถœ๋ ฅํ•ด์ค๋‹ˆ๋‹ค. grep ๋ช…๋ น์–ด ๊ธฐ๋ณธ ๋ฌธ๋ฒ• grep (1)[-์˜ต์…˜] (2)ํŒจํ„ด (3)ํŒŒ์ผ๋ช… grep ์˜ต์…˜ -c: ํŒŒ์ผ ๋‹น ํŒจํ„ด์ด ์ผ์น˜ํ•˜๋Š” ๋ผ์ธ์˜ ๊ฐฏ์ˆ˜ ์ถœ๋ ฅ -i: ๋น„๊ต์‹œ ๋Œ€/์†Œ๋ฌธ์ž ๊ตฌ๋ณ„ ์•ˆํ•จ -v: ์ง€์ •ํ•œ ํŒจํ„ด๊ณผ ์ผ์น˜ํ•˜์ง€ ์•Š๋Š” ๋ผ์ธ ์„ ํƒ -n: ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ ์ถœ๋ ฅ ๋ผ์ธ ์•ž์— ๋ผ์ธ ๋ฒˆํ˜ธ ์ถœ๋ ฅ -l: ํŒจํ„ด์ด ํฌํ•จ๋œ ํŒŒ์ผ์˜ ์ด๋ฆ„๋งŒ ํ‘œ์‹œ -w: ํŒจํ„ด์ด ์ „์ฒด ๋‹จ์–ด(word)์™€ ์ผ์น˜ํ•˜๋Š” ๋ผ์ธ๋งŒ ์ถœ๋ ฅ -m: ์ตœ๋Œ€ ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ ๊ฐฏ์ˆ˜ ์ œํ•œ -H: ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ ์ถœ๋ ฅ ๋ผ์ธ ์•ž์— ํŒŒ์ผ ์ด๋ฆ„ ํ‘œ์‹œ -E: PATTERN์„ ํ™•์žฅ ์ •๊ทœ ํ‘œํ˜„์‹(Extended RegEx)์œผ๋กœ ํ•ด์„ -F: PATTERN์„ ์ •๊ทœ ํ‘œํ˜„์‹(Reg..

๋ฐ˜์‘ํ˜•
๊ณต์ง€์‚ฌํ•ญ
์ตœ๊ทผ์— ์˜ฌ๋ผ์˜จ ๊ธ€
์ตœ๊ทผ์— ๋‹ฌ๋ฆฐ ๋Œ“๊ธ€
Total
Today
Yesterday
๋งํฌ
ยซ   2024/07   ยป
์ผ ์›” ํ™” ์ˆ˜ ๋ชฉ ๊ธˆ ํ† 
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31
๊ธ€ ๋ณด๊ด€ํ•จ
๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ (56)
๐Ÿ“บ Develop (34)
๐ŸŒ‹ Error Fixed (3)
๐Ÿ— Tool (3)
๐Ÿ’ป MacBook M1 (15)
๐Ÿ“ฆ ETC (1)

์ด ํฌ์ŠคํŒ…์€ ์ฟ ํŒก ํŒŒํŠธ๋„ˆ์Šค ํ™œ๋™์˜ ์ผํ™˜์œผ๋กœ, ์ด์— ๋”ฐ๋ฅธ ์ผ์ •์•ก์˜ ์ˆ˜์ˆ˜๋ฃŒ๋ฅผ ์ œ๊ณต๋ฐ›์Šต๋‹ˆ๋‹ค.