Category 192

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

ํ†ฐ์บฃ์„ ์‹คํ–‰ ์‹œ ์ด๋Ÿฐ ์˜ค๋ฅ˜ ๋ฐœ์ƒ org.apache.commons.dbcp.SQLNestedException: 2020-11-17 17:32:32,713 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] execute ExceptionTransfer.transfer 2020-11-17 17:32:32,719 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] RuntimeException case :: RuntimeException 2020-11-17 17:32:32,722 ERROR [egovframework.example.sample.service.impl.FileServiceImpl] C..

DB 2020.11.17

[jQuery] $(document).ready vs $(window).load ์ฐจ์ด

$(document).ready ์™ธ๋ถ€ ๋ฆฌ์†Œ์Šค. ์ด๋ฏธ์ง€์™€๋Š” ์ƒ๊ด€์—†์ด ๋ธŒ๋ผ์šฐ์ €๊ฐ€ DOM (document object model) ํŠธ๋ฆฌ๋ฅผ ์ƒ์„ฑํ•œ ์งํ›„ ์‹คํ–‰ window.load() ๋ณด๋‹ค ๋” ๋น ๋ฅด๊ฒŒ ์‹คํ–‰๋˜๊ณ  ์ค‘๋ณต ์‚ฌ์šฉํ•˜์—ฌ ์‹คํ–‰ํ•ด๋„ ์„ ์–ธํ•œ ์ˆœ์„œ๋Œ€๋กœ ์‹คํ–‰๋จ $(window).load DOM์˜ standard ์ด๋ฒคํŠธ html์˜ ๋กœ๋”ฉ์ด ๋๋‚œ ํ›„์— ์‹œ์ž‘ ํ™”๋ฉด์— ํ•„์š”ํ•œ ๋ชจ๋“  ์š”์†Œ(css, js, image, iframe etc..)๋“ค์ด ์›น ๋ธŒ๋ผ์šฐ์ € ๋ฉ”๋ชจ๋ฆฌ์— ๋ชจ๋‘ ์˜ฌ๋ ค์ง„ ๋‹ค์Œ์— ์‹คํ–‰๋จ ํ™”๋ฉด์ด ๋ชจ๋‘ ๊ทธ๋ ค์ง„ ๋‹ค์Œ์˜ ๋ฉ”์„ธ์ง•์ด๋‚˜ ์ด๋ฏธ์ง€๊ฐ€ ๊ด€๋ จ ์š”์†Œ๊ฐ€ ๋ชจ๋‘ ์˜ฌ๋ ค์ง„ ๋‹ค์Œ์˜ ์• ๋‹ˆ๋ฉ”์ด์…˜์— ์ ํ•ฉํ•จ ์ „์ฒด ํŽ˜์ด์ง€์˜ ๋ชจ๋“  ์™ธ๋ถ€ ๋ฆฌ์†Œ์Šค์™€ ์ด๋ฏธ์ง€๊ฐ€ ๋ธŒ๋ผ์šฐ์ €์— ๋ถˆ๋ ค ์˜จ ์ดํ›„ ์ž‘๋™ํ•˜๊ฒŒ ๋˜์–ด ์ด๋ฏธ์ง€๊ฐ€ ์•ˆ๋œฐ ๋„ค๊ฐ€ ๋”œ๋ ˆ์ด๊ฐ€ ์ƒ๊ธธ ๋•Œ์—๋Š” ๊ทธ๋งŒํผ์˜ ์‹œ๊ฐ„์„ ๊ธฐ..

js 2020.10.05

[JavaScript] ์ˆซ์ž ์ฒœ๋‹จ์œ„ ๋งˆ๋‹ค ์ฝค๋งˆ(,) ์ •๊ทœ์‹

์ •์ˆ˜ํ˜•์— ๋Œ€ํ•ด์„œ๋Š” ์•„๋ฌด๋Ÿฐ ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•˜์ง€ ์•Š์œผ๋‚˜, ์†Œ์ˆ˜์ ์ด ์žˆ๋Š” ์‹ค์ˆ˜ํ˜•์˜ ๊ฒฝ์šฐ์—๋Š” ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•˜๊ฒŒ ๋œ๋‹ค. toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); 1. ํ•จ์ˆ˜ function numberWithCommas(x) { return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); } 2. td ๊ฐ’์— ์ฝค๋งˆ๋ฅผ ์ฐ์„ ๊ฒฝ์šฐ jquery $("#id๋ช…").text().toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); javascript document.getElementById('id๋ช…').innerText.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",..

js 2020.09.21

[Eclipse] ์ดํด๋ฆฝ์Šค ๋ ˆ์ด์•„์›ƒ ์ดˆ๊ธฐํ™”

๋งˆ์šฐ์Šค๋กœ ์‚ด์ง ์ž˜๋ชป ๊ฑด๋“œ๋ ค๋„ ๋ ˆ์ด์•„์›ƒ์ด ๊ธˆ๋ฐฉ ํ‹€์–ด์ง€๋Š” ์ดํด๋ฆฝ์Šค ๊ทธ๋Ÿฌ๋‹ค๊ฐ€ ๋ ‰์ฒ˜๋Ÿผ console, server, debug๊ฐ€ 4๊ฐœ์”ฉ ๋– ์„œ ๋ ˆ์ด์•„์›ƒ ์ดˆ๊ธฐํ™” ๋ฐฉ๋ฒ•์„ ์ฐพ์•˜๋‹ค. window - Reset Perspective ํด๋ฆญ ์ดˆ๊ธฐ์˜ ์ดํด๋ฆฝ์Šค ๋ ˆ์ด์•„์›ƒ์œผ๋กœ ๋Œ์•„๊ฐ„๋‹ค. ์•„์ฃผ ๊ฐ„๋‹จํ•˜๊ฒŒ ํ•ด๊ฒฐ !

multi 2020.09.21

์ž๋ฃŒ๊ตฌ์กฐ (Data Structure)

์ž๋ฃŒ๊ตฌ์กฐ๋ž€ ์ž๋ฃŒ๊ตฌ์กฐ (data structure) : ์ปดํ“จํ„ฐ ๊ณผํ•™์—์„œ ํšจ์œจ์ ์ธ ์ ‘๊ทผ ๋ฐ ์ˆ˜์ •์„ ๊ฐ€๋Šฅ์ผ€ ํ•˜๋Š” ์ž๋ฃŒ์˜ ์กฐ์ง, ๊ด€๋ฆฌ, ์ €์žฅ์„ ์˜๋ฏธ, ๋ฐ์ดํ„ฐ ๊ฐ’์˜ ๋ชจ์ž„, ๋ฐ์ดํ„ฐ ๊ฐ„์˜ ๊ด€๊ณ„, ๋ฐ์ดํ„ฐ์— ์ ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ํ•จ์ˆ˜๋‚˜ ๋ช…๋ น์„ ์˜๋ฏธ - ์‹ ์ค‘ํ•˜๊ฒŒ ์„ ํƒํ•œ ์ž๋ฃŒ๊ตฌ์กฐ๋Š” ๋ณด๋‹ค ํšจ์œจ์ ์ธ ์•Œ๊ณ ๋ฆฌ์ฆ˜์„ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•จ. ์ž๋ฃŒ๊ตฌ์กฐ๊ฐ€ ์ค‘์š”ํ•œ ์ด์œ  ์ž๋ฃŒ๊ตฌ์กฐ์—๋Š” ์—ฌ๋Ÿฌ ์ข…๋ฅ˜๊ฐ€ ์žˆ๋Š”๋ฐ ๊ฐ๊ฐ ์ž๋ฃŒ๊ตฌ์กฐ๋Š” ๊ฐ๊ฐ์˜ ์—ฐ์‚ฐ ๋ฐ ๋ชฉ์ ์— ๋งž์ถฐ์ง B-ํŠธ๋ฆฌ๋Š” ๋ฐ์ดํ„ฐ ๋ฒ ์ด์Šค์— ํšจ์œจ์ ์ด๋ฉฐ, ๋ผ์šฐํŒ… ๋ฐ์ด๋ธ”์€ ๋„คํŠธ์›Œํฌ(์ธํ„ฐ๋„ท, ์ธํŠธ๋ผ๋„ท)์— ์ผ๋ฐ˜์ ์ด๋‹ค. ํ”„๋กœ๊ทธ๋žจ์„ ์„ค๊ณ„ํ•  ๋•Œ ์–ด๋–ค ์ž๋ฃŒ๊ตฌ์กฐ๋ฅผ ์„ ํƒํ• ์ง€ ๊ฐ€์žฅ ์šฐ์„ ์ ์œผ๋กœ ๊ณ ๋ คํ•ด์•ผ ํ•œ๋‹ค. ํฐ ์‹œ์Šคํ…œ์„ ์ œ์ž‘ํ•  ๋•Œ ๊ตฌํ˜„์˜ ๋‚œ์ด๋„๋‚˜ ์ตœ์ข… ๊ฒฐ๊ณผ๋ฌผ์˜ ์„ฑ๋Šฅ์ด ์ž๋ฃŒ๊ตฌ์กฐ์— ํฌ๊ฒŒ ์˜์กดํ•œ๋‹ค. ์ž๋ฃŒ๊ตฌ์กฐ๊ฐ€ ์„ ํƒ๋˜๋ฉด ์ ์šฉํ•  ์•Œ๊ณ ๋ฆฌ์ฆ˜์€ ์ƒ๋Œ€..

Basic 2020.09.17

[webapp] webapp WEB-INF lib

* WEB-INF/classes Servlet,JSP์—์„œ ์‚ฌ์šฉํ•˜๋Š” EJB Client Class์™€, Common Class ๋ฅผ classes ๋””๋ ‰ํ† ๋ฆฌ์— ํ’€์–ด์„œ ๋ฐฐํฌํ•˜๋Š” ๋ฐฉ๋ฒ•์ธ๋ฐ, ์ˆ˜์ •๊ณผ ์‚ญ์ œ๊ฐ€ ํŽธํ•˜๋‹ค๋Š” ์žฅ์ ์€ ์žˆ์œผ๋‚˜, Web Application ๋งˆ๋‹ค, classes ๋””๋ ‰ํ† ๋ฆฌ์— ๋ฐฐํฌ๋ฅผ ํ•ด์•ผํ•˜๊ธฐ ๋•Œ๋ฌธ์—, Version ๊ด€๋ฆฌ ๋ฌธ์ œ๋‚˜ Sync ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ๊ณ , ํŒŒ์ผ๋‹จ์œ„๋กœ ๊ด€๋ฆฌํ•˜๊ธฐ๋•Œ๋ฌธ์—, ๋ฒˆ๊ฑฐ๋กญ๋‹ค. ์†Œ๊ทœ๋ชจ๊ฐ€ Application์ด ์•„๋‹Œ๊ฒฝ์šฐ์—๋Š” ๊ถŒ์žฅํ•˜๊ธฐ ์–ด๋ ค์šด ๋ฐฉ๋ฒ•์ด๋‹ค. * WEB-INF/lib Servlet,JSP์—์„œ ์‚ฌ์šฉํ•˜๋Š” EJB Client Class์™€, Common Class ๋ฅผ jar๋กœ ๋ฌถ์–ด์„œ, lib ๋””๋ ‰ํ† ๋ฆฌ์— ์œ„์น˜์‹œํ‚ฌ ์ˆ˜ ์žˆ๋‹ค. Jar๋‹จ์œ„๋กœ ๋ฌถ์–ด์„œ ํŒจํ‚ค์ง•ํ•˜๊ธฐ ๋•Œ๋ฌธ์—, ๊ด€๋ฆฌ๊ฐ€ ๊ฐ„ํŽธํ•˜๋‹ค๋Š” ์žฅ์ ์ด..

multi 2020.09.16

[MAVEN] maven repository ์™ธ๋ถ€ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ถ”๊ฐ€ํ•˜๊ธฐ

maven : ๋นŒ๋“œ ๋„๊ตฌ, ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์˜์กด์„ฑ์„ ๊ด€๋ฆฌ pom.xml์— ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ฅผ ๋“ฑ๋กํ•˜๋ฉด ๋ฉ”์ด๋ธ์ด ๊ด€๋ จ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๊นŒ์ง€ ๊ฐ€์ ธ์˜ด. ๊ทธ๋ ‡์ง€๋งŒ ์™ธ๋ถ€ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ํ˜น์€ ๋‚ด๊ฐ€ ๋งŒ๋“  ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋Š” maven repository์— ๋‚˜์˜ค์ง€ ์•Š์Œ. ๊ทธ๋ž˜์„œ ์ง์ ‘ ๋กœ์ปฌ repository๋ฅผ ๋งŒ๋“ค์–ด ์‚ฌ์šฉ ํ•ด์•ผ ํ•จ. 1. pom.xml์— repository ๊ฒฝ๋กœ ์žก์•„์ฃผ๊ธฐ 1-1 ) lib ํด๋” ์•ˆ์— ๋„ฃ๊ธฐ ๋•Œ๋ฌธ์— url์—” ${lib.dir}๋กœ ์ค€๋‹ค. local-repository local repository file://${lib.dir} 2. ๊ฒฝ๋กœ์— ๋งž๊ฒŒ ํด๋” ์ƒ์„ฑ lib > ํด๋”(groupId) > ํด๋”(artifactId) > ํด๋”(version) ์ด๋ ‡๊ฒŒ ์ƒ์„ฑ 3. ๊ฒฝ๋กœ์— jar ์ถ”๊ฐ€ : ๋˜‘๊ฐ™์€ ์œ„์น˜๋กœ ๋“ค์–ด๊ฐ€ jarํŒŒ์ผ์„ ์ง์ ‘..

multi 2020.09.16

[JSP] WEB-INF/ lib .jar ์ถ”๊ฐ€ (= jsp์—์„œ import๊ฐ€ ์•ˆ๋ ๋•Œ)

jsp์—์„œ import๊ฐ€ ์ž˜ ๋˜๋Š”๋ฐ ์™œ ์ž๊พธ ์—๋Ÿฌ๊ฐ€ ๋œฐ๊นŒ.. ? ์—๋Ÿฌ : org.Apache.jasper.JasperException: Unable to compile class for JSP:An error occurred at line: in the generated Java file Only a type can be imported. 1. build path ์— web app libraries ์ถ”๊ฐ€ ํ”„๋กœ์ ํŠธ ์šฐํด๋ฆญ ํ›„ Build Pathํด๋ฆญ Add Library ํด๋ฆญ WEB App Libraries ํด๋ฆญ ์ถ”๊ฐ€ ๋œ๊ฑฐ ํ™•์ธ ํ›„ apply - ok 2. ....webapp/web-inf/lib์— .jar์ถ”๊ฐ€ jsp ์—์„œ jar๋ฅผ ์‚ฌ์šฉํ•˜๊ธฐ ๋•Œ๋ฌธ์— libํด๋”๋ฅผ webapp์•„๋ž˜ WEB-INF ์•ˆ์— ์ƒ์„ฑ lib..

multi 2020.09.14

์ด์ง„ํŒŒ์ผ(binary file)์— ๋Œ€ํ•ด ์•Œ์•„๋ณด์ž.

๊ธฐ๋ณธ ์ƒ์‹์ด ๋งŽ์ด ๋ถ€์กฑํ•œ ๋‚˜๋กœ์จ ๋ชจ๋“  ๊ฑธ ๋ฉ”๋ชจํ•ด์•ผ๊ฒ ๋‹ค.. ์ด์ง„ ํŒŒ์ผ ๋˜๋Š” ๋ฐ”์ด๋„ˆ๋ฆฌ ํŒŒ์ผ(binary file) ์ด๋ž€ ? ๊ธฐ๋ณธ์ ์œผ๋กœ ํ–‰๋‹จ์œ„๊ฐ€ ์•„๋‹Œ ๋ชจ๋“  ํŒŒ์ผ์„ ์ผ์ปซ๋Š”๋‹ค. ํ‘œ์‹œ์šฉ ๋ฌธ์ž์™€ ๊ฐœํ–‰๋ฌธ์ž ์™ธ์— ๋‹ค๋ฅธ ๊ธฐํ˜ธ๊ฐ€ ๋“ค์–ด์žˆ๋Š” ํŒŒ์ผ๋„ ๋ฐ”์ด๋„ˆ๋ฆฌ ํŒŒ์ผ์ด๋‹ค. ๋ฐ”์ด๋„ˆ๋ฆฌ ํŒŒ์ผ์ด๋ž€ ‘0’ ๊ณผ ‘1’ ์„ ์ด์šฉํ•œ 2์ง„์ˆ˜ ๋ฐ์ดํ„ฐ ๋งŒ์œผ๋กœ๋งŒ์œผ๋กœ ์ด๋ฃจ์–ด์ง„ ํŒŒ์ผ์ด๋‹ค. ์‚ฌ๋žŒ์ด ์ง์ ‘ ์ฝ์„ ์ˆ˜ ์—†๋‹ค. ๋Œ€ํ‘œ์ ์ธ ํ™•์žฅ์ž๋Š” exe, dll, zip, rar, mp3, mpg, jpg, png ๋“ฑ์ด ์žˆ๋‹ค. ์ด์ง„ ํŒŒ์ผ ๋˜๋Š” ๋ฐ”์ด๋„ˆ๋ฆฌ ํŒŒ์ผ(binary file) ์žฅ์  ? ๋ฐ์ดํ„ฐ๋ฅผ ์ฒ˜๋ฆฌํ•˜๊ณ  ์ „์†กํ•˜๋Š”๋ฐ ์ผ๋ฐ˜์ ์œผ๋กœ ๋น„์šฉ์ด ์ ๊ฒŒ๋“ฌ ๋ณดํ†ต ํ…์ŠคํŠธ์— ๋น„ํ•ด ํŒŒ์‹ฑ์ด ์‰ฌ์–ด ๋ฐ์ดํ„ฐ ์ฒ˜๋ฆฌ ์†๋„๊ฐ€ ๋น ๋ฅด๋‹ค. ํ•„์š”ํ•œ ๋ฐ์ดํ„ฐ ๊ณต๊ฐ„๋„ ๋” ์ž‘์€ ๊ฒฝ์šฐ๊ฐ€ ๋งŽ๋‹ค. ์ด์ง„ ํŒŒ์ผ์„ ํ…์ŠคํŠธ ๋ชจ๋“œ..

Basic 2020.09.09

[SVN] SVN์ด๋ž€ ? ์žฅ์  , ๋‹จ์  , ์šฉ์–ด ์ •๋ฆฌ

ํšŒ์‚ฌ์—์„œ ์†Œ์Šค๋ฅผ ํ˜•์ƒ๊ด€๋ฆฌํ• ๋•Œ svn์„ ์ž์ฃผ ์‚ฌ์šฉํ•˜๋Š”๋ฐ svn์— ๋Œ€ํ•ด ์•Œ์•„๋ณด์ž. 1. SVN์ด๋ž€? SVN์€ SubVersion์˜ ์ค„์ž„๋ง๋กœ ์ค‘์•™์ง‘์ค‘๊ด€๋ฆฌ์‹ ํ˜•์ƒ๊ด€๋ฆฌ ์†Œ์Šค ๊ด€๋ฆฌ ํˆด์ด๋‹ค. ๋กœ์ปฌ pc์—์„œ ์ปค๋ฐ‹ ์‹œ ์ค‘์•™ ์ €์žฅ์†Œ์— ๋ฐ”๋กœ ๋ฐ˜์˜ 2. SVN ํ•„์š”์„ฑ ๊ธฐ์กด์˜ ํŒŒ์ผ ์‹œ์Šคํ…œ ๊ณต์œ  ๋“ฑ์œผ๋กœ ๋ฌธ์ œ ๋ฐœ์ƒ ์‹œ ๋ณต๊ตฌ ํ”„๋กœ์ ํŠธ ์ง„ํ–‰ ์ค‘ ๊ณผ๊ฑฐ์˜ ํŠน์ • ์‹œ์ ์œผ๋กœ ๋Œ์•„๊ฐ€์•ผ ํ•˜๋Š” ๊ฒฝ์šฐ ์—ฌ๋Ÿฌ ์‚ฌ๋žŒ์ด ๊ฐ™์€ ํ”„๋กœ์ ํŠธ์— ์ฐธ์—ฌ ํ•  ๊ฒฝ์šฐ, ๊ฐ์ž๊ฐ€ ์ˆ˜์ •ํ•œ ๋ถ€๋ถ„์„ ํŒ€์› ์ „์ฒด๊ฐ€ ๋™๊ธฐํ™”ํ•˜๋Š” ๊ณผ์ •์„ ์ž๋™ํ™” ์†Œ์Šค ์ฝ”๋“œ์˜ ๋ณ€๊ฒฝ ์‚ฌํ•ญ์„ ์ถ”์  ์†Œ์Šค ์ฝ”๋“œ์—์„œ ๋ˆ„๊ฐ€ ์ˆ˜์ •ํ–ˆ๋Š”์ง€ ์ถ”์  ๋Œ€๊ทœ๋ชจ ์ˆ˜์ • ์ž‘์—…์„ ๋”์šฑ ์•ˆ์ „ํ•˜๊ฒŒ ์ง„ํ–‰ ๋งˆ์ด๋„ˆ ๋ฒ„์ „(branch)๋กœ ํ”„๋กœ์ ํŠธ์— ์˜ํ–ฅ์„ ์ตœ์†Œํ™”ํ•˜๋ฉด์„œ ์ƒˆ๋กœ์šด ๋ถ€๋ถ„์„ ๊ฐœ๋ฐœ 3. SVN ์žฅ์  ์›์ž์  ์ปค๋ฐ‹์„ ์ง€์›ํ•˜๋ฏ€๋กœ ๋‹ค๋ฅธ ์‚ฌ์šฉ์ž์˜ ์ปค๋ฐ‹๊ณผ ์—‰..