๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

๋…ธ๋ ฅ์„ ์ด๊ธฐ๋Š” ์žฌ๋Šฅ์€ ์—†๊ณ 
๋…ธ๋ ฅ์„ ์™ธ๋ฉดํ•˜๋Š” ๊ฒฐ๊ณผ๋„ ์—†๋‹ค.
- ์ด์ฐฝํ˜ธ 9๋‹จ

E R R O R/Java Error6

[Java Error] A Java Runtime Environment (JRE) or Java Development Kit (JDK) must be availavle in order to run Eclipse. No Java Virtual machine was found after searching the following locations. ์ดํด๋ฆฝ์Šค๋ฅผ ์‹คํ–‰ํ• ๋•Œ๋ฉด ๊ฐ€๋” ๋ณผ ์ˆ˜ ์žˆ๋Š” ์—๋Ÿฌ ์•Œ๋ฆผ์ฐฝ์ด๋‹ค. ๋‚œ ๋ถ„๋ช… JDK๋„ ์„ค์น˜๋„ํ•˜๊ณ  ์„ค์ •๊นŒ์ง€ ๋‹ค ํ–ˆ๋Š”๋ฐ ์ดํด๋ฆฝ์Šค๋ฅผ ์‹คํ–‰ํ•˜๋ฉด ์ €๋Ÿฐ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ์žˆ๋‹ค. ์ด๋Ÿฐ ์—๋Ÿฌ ์•Œ๋ฆผ์ฐฝ์ด ๋œฐ๋•Œ๋งˆ๋‹ค ์—ฌ๊ฐ„ ๋‹นํ™ฉ์Šค๋Ÿฌ์šธ์ˆ˜๊ฐ€ ์—†์ง€๋งŒ, ํ•ด๋‹น ์—๋Ÿฌ์ฐฝ์€ ํฌ๊ฒŒ ๋ฌธ์ œ๊ฐ€ ๋˜๊ฑฐ๋‚˜ ๋ณต์žกํ•œ ์—๋Ÿฌ๊ฐ€ ์•„๋‹ˆ๊ธฐ๋•Œ๋ฌธ์— ๊ฐ„๋‹จํ•˜๊ฒŒ ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋‹ค. ํ•ด๊ฒฐ๋ฐฉ๋ฒ• JDK ํ™˜๊ฒฝ๋ณ€์ˆ˜ ์„ค์น˜ ํ™•์ธ ๋˜๋Š” JDK ํ™˜๊ฒฝ๋ณ€์ˆ˜ ์žฌ์„ค์ • ๋˜๋Š” ์„ค์ • ์‹œ ์ ˆ๋Œ€๊ฒฝ๋กœ๋กœ ์„ค์ •ํ•˜๊ธฐ JDK ํ™˜๊ฒฝ๋ณ€์ˆ˜ ์„ค์น˜ ํ™•์ธ 1. JDK๊ฐ€ ์ •์ƒ์ ์œผ๋กœ ์„ค์น˜๋˜๊ณ  ์„ค์ •๋˜์—ˆ๋Š”์ง€ ํ™•์ธํ•˜๊ธฐ ์œ„ํ•ด ๋ช…๋ น ํ”„๋กฌํ”„ํŠธ ์ฐฝ์„ ์—ด๊ณ  "java -version"์„ ํ™•์ธํ•œ๋‹ค. ์ž๋ฐ” ๋ฒ„์ „ ๋ช…๋ น์–ด : java -version or javac -version ์œ„์™€ ๊ฐ™์ด java version "1.8.0_271" ์ด๋ผ๊ณ  ์ถœ๋ ฅ๋˜๋ฉด ์ •์ƒ.. 2022. 9. 7.
[Java Error] java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column ๊ฒŒ์‹œํŒ์— ๊ธ€ ๋“ฑ๋ก์„ ํ•˜๋˜ ์ค‘, ์œ„์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. ๋‚ด์šฉ์œผ๋กœ ์ž‘์„ฑํ•˜๊ณ  ์žˆ์—ˆ๋˜ ํ…์ŠคํŠธ ๊ธธ์ด๊ฐ€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํ…Œ์ด๋ธ”์˜ ๋‚ด์šฉ ์ปฌ๋Ÿผ์˜ ๊ณต๊ฐ„๋ณด๋‹ค ํ›จ์”ฌ ์ปธ๋‚˜๋ณด๋‹ค. Long์œผ๋กœ ์„ค์ •๋œ ์ปฌ๋Ÿผ์€ Long์— ๋งž์ถฐ ๋‚ด์šฉ์„ ์ž‘์„ฑํ•˜์—ฌ ์ €์žฅํ•ด์•ผํ•˜๋Š”๋ฐ, ๊ทธ๋ ‡์ง€ ๋ชปํ•œ ๊ฒƒ์ด๋‹ค. ๋‚ด์šฉ์— ์ด๋ฏธ์ง€๋ฅผ ํ•œ๊ฐœ ์ฒจ๋ถ€ํ–ˆ๋Š”๋ฐ ํ•ด๋‹น ์ด๋ฏธ์ง€๊ฐ€ base64๋กœ ์ธ์ฝ”๋”ฉ๋˜์–ด ๋“ค์–ด๊ฐ€๋Š” ๋ฐ”๋žŒ์— ์ด๋ฏธ์ง€๊ฐ€ ๋ฐ์ดํ„ฐ๋กœ ๋ณ€ํ™˜๋˜์„œ ๋‚ด์šฉ์— ์ฒจ๋ถ€๋˜์—ˆ๋‹ค. ๊ทธ๋ž˜์„œ ์—„์ฒญ๋‚œ ๊ธธ์ด์˜ ํ…์ŠคํŠธ ๋ฐ์ดํ„ฐ๋กœ ๋‚ด์šฉ์— ์ฒจ๋ถ€๋˜์—ˆ๋‹ค. ์‹ค์ œ htmlํ˜•ํƒœ๋กœ ๋ณด๋ฉด ์ด๋ฏธ์ง€์ง€๋งŒ ์†Œ์Šค์ฝ”๋“œ ๋ณด๊ธฐ๋กœ ํ™•์ธํ•ด๋ณด๋ฉด ์—„์ฒญ๋‚œ ๊ธธ์ด๋ฅผ ๊ฐ€์ง„ ํ…์ŠคํŠธ๋กœ ๋ณด์—ฌ์ง„๋‹ค. ์ฒ˜๋ฆฌ๊ฒฐ๊ณผ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํ…Œ์ด๋ธ”์—์„œ ์„ค์ •ํ•œ ์ปฌ๋Ÿผ์˜ ์ตœ๋Œ€ ๊ณต๊ฐ„์•ˆ์—์„œ ๊ธ€์„ ์ž‘์„ฑํ•˜๊ฑฐ๋‚˜, ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํ…Œ์ด๋ธ”์˜ ํ•ด๋‹น ์ปฌ๋Ÿผ ํฌ๊ธฐ๋ฅผ CLOB์œผ๋กœ ๋ณ€๊ฒฝํ•˜์—ฌ ๋” ๋งŽ์€ ๋ฐ์ดํ„ฐ๋ฅผ ๋‹ด์„ .. 2022. 8. 9.
[Java Error] java.lang.ArithmeticException: / by zero ํ…Œ์ŠคํŠธ์šฉ๋„๋กœ ๊ฒŒ์‹œํŒ ๋ฆฌ์ŠคํŠธ๋ฅผ ๊ตฌํ˜„ํ•˜๋ ค๊ณ  ํ•˜๋˜์ค‘์—, ํŽ˜์ด์ง• ์ฒ˜๋ฆฌ๋ฅผ ํ•˜์—ฌ ์„œ๋ฒ„๋กœ๋ถ€ํ„ฐ ๋ฐ์ดํ„ฐ๋ฅผ ๊ตฌํ˜„ํ•ด์„œ ํด๋ผ์ด์–ธํŠธ๋กœ ๋ณด๋‚ด๊ธฐ์œ„ํ•ด ํ•ด๋‹น ํŽ˜์ด์ง€๋ฅผ ์š”์ฒญํ•˜๋Š”๋ฐ / by zero ์—๋Ÿฌ๊ฐ€ ๋ฟœ์–ด์ ธ๋‚˜์™”๋‹ค. ๋ฌด์–ธ๊ฐ€๋ฅผ 0์œผ๋กœ ๋‚˜๋ˆ„๋ ค๊ณ ํ•ด์„œ ๋ฐœ์ƒํ•˜๋Š” ์—๋Ÿฌ์ธ๋ฐ, ์–ด๋”˜๊ฐ€์—์„œ 0์œผ๋กœ ๋‚˜๋ˆ„๋ ค๊ณ  ์‹œ๋„ํ–ˆ๋˜๊ฒƒ ๊ฐ™๋‹ค. 0์œผ๋กœ ๋‚˜๋ˆ ์งˆ๊ฒƒ ๊ฐ™์€ ๋ถ€๋ถ„ ๋ถ€๋ถ„์„ ์ฐพ์•„๋ณด์•˜๋Š”๋ฐ ํŽ˜์ด์ง€๋ฅผ ๊ตฌ์„ฑํ•˜๊ธฐ์œ„ํ•ด์„œ PagingVO๋ฅผ ๊พธ๋ฉฐ์ฃผ๋Š” setter, getter๋ถ€์˜ ๊ธฐ๋ณธ ์ดˆ๊ธฐ๊ฐ’์„ ์„ค์ •ํ•˜์ง€ ์•Š์•„, setter์—์„œ ๊ฐ’์ด ์—†์œผ๋ฏ€๋กœ ์ •์˜ ์ดˆ๊ธฐ๊ฐ’์ธ 0์ด ๋“ค์–ด๊ฐ€ 0์œผ๋กœ ๋‚˜๋ˆ ์ ธ ์œ„์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. ์ฒ˜๋ฆฌ๊ฒฐ๊ณผ ์–ด๋– ํ•œ ๊ฐ’์„ 0์œผ๋กœ ๋‚˜๋ˆ„๋ ค๊ณ  ํ•ด์„œ ๋ฐœ์ƒ, 0์œผ๋กœ ๋‚˜๋ˆ„์ง€ ๋ชปํ•˜๋„๋ก ๊ฐ’์˜ ์ •์˜ ๋ฐ ์ดˆ๊ธฐํ™”๋ฅผ ์ง„ํ–‰ํ•œ๋‹ค. PagingVO ํด๋ž˜์Šค์— ์ •์˜๋œ ๋ณ€์ˆ˜ ๋“ค ์ค‘, screenSize์™€ .. 2022. 8. 8.
[Java Error] Cause: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, ORA-00923: FROM keyword not found where expected. ํ…Œ์ŠคํŠธ ํ”„๋กœ์ ํŠธ๋กœ ์‚ฌ์šฉํ•˜๋˜ ์„œ๋น„์Šค๋ฅผ ์ˆ˜์ •ํ•˜๊ธฐ ์œ„ํ•ด์„œ ์˜ค๋žœ๋งŒ์— ํ”„๋กœ์ ํŠธ๋ฅผ ์—ด๊ณ  Mysql ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋กœ ์‚ฌ์šฉํ•˜๋˜ ์„ค์ •๋“ค์„ Oracle ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„ค์ •์œผ๋กœ ๋ณ€๊ฒฝ ํ›„, ์„œ๋ฒ„๋ฅผ ๊ฐ€๋™ํ•˜๊ณ  ๋กœ๊ทธ์ธ์„ ์ง„ํ–‰ํ–ˆ๋‹ค. ๊ทธ๋Ÿฐ๋ฐ, ORA-00923: From keyword not found where expected. ๋ผ๋Š” ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. From์ ˆ๊ณผ ๊ด€๋ จ์ด ์žˆ๋Š”๊ฑฐ ๊ฐ™์•„ DB ์ฟผ๋ฆฌ๊ฐ€ ์žˆ๋Š” Mapper์ชฝ์œผ๋กœ ๊ฐ€ ๋กœ๊ทธ์ธ์„ ๊ด€์žฅํ•˜๋Š” Mapper xml์„ ๋“ค์—ฌ๋‹ค๋ณด์•˜๋‹ค. ์ฟผ๋ฆฌ์— Mysql์—์„œ ์‚ฌ์šฉ์ค‘์ด๋˜ ๊ตฌ๋ฌธ์ด ์žˆ์–ด ์ˆ˜์ •ํ•˜๊ณ , ์˜คํƒ€ ๋˜ํ•œ ํ™•์ธํ–ˆ์ง€๋งŒ ์˜คํƒ€๋Š” ์—†์—ˆ๋‹ค. ๋‹ค์‹œ ์„œ๋ฒ„๋ฅผ ์žฌ๊ฐ€๋™ํ•˜๊ณ  ๋กœ๊ทธ์ธ์„ ์ง„ํ–‰ํ–ˆ๋‹ค. ํ•˜์ง€๋งŒ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฟœ์–ด์ ธ๋‚˜์™”๋‹ค. ์„ค์ •์ด ์ž˜๋ชป๋œ๊ฑด๊ฐ€? ์–ด๋””์„œ๋ถ€ํ„ฐ ์ž˜๋ชป๋œ๊ฑด์ง€ ํ•˜๋‚˜ํ•˜๋‚˜์”ฉ ์ฐพ์•„๋‚˜๊ฐ”๋‹ค. ํ•œ์ฐธ์„ ํ—ค๋งค๊ณ  ์‹œ๋„ํ•˜๋‹ค๊ฐ€ ๋งˆ์ง€๋ง‰.. 2022. 8. 4.
[Java Error] Invalid character found in method name. ์„œ๋น„์Šค๋ฅผ ๋„์šฐ๋ ค๊ณ  ํ†ฐ์บฃ์„ ์‹คํ–‰ํ•˜๊ณ  ์„œ๋น„์Šค URL์„ ์ธํ„ฐ๋„ท ๋ธŒ๋ผ์šฐ์ €์—์„œ ์‹คํ–‰ํ•˜์˜€๋Š”๋ฐ ํ™ˆํŽ˜์ด์ง€๊ฐ€ ์—ด๋ฆฌ์ง€ ์•Š๊ณ  ์œ„์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜์˜€๋‹ค. ๊ธฐ์กด์— ๊ฐœ๋ฐœ์„œ๋ฒ„์—์„œ๋„ ๋ฌธ์ œ ์—†์ด ์—ด๋ ธ๋˜ ์„œ๋น„์Šค๊ฐ€ ์—ด๋ฆฌ์ง€ ์•Š์œผ๋‹ˆ ๋‹นํ™ฉ์Šค๋Ÿฌ์› ๋‹ค. ํ†ฐ์บฃ docbase๊ฐ€ ์ž˜๋ชป๋˜์—ˆ๋‚˜? ์†Œ์Šค์ƒ์— ๋ˆ„๋ฝ๋œ ๋ถ€๋ถ„์ด ์žˆ๋‚˜? 404์—๋Ÿฌ์™€ ๊ฐ™์€ ๊ฒฝ๋กœ๋ฅผ ์ •ํ™•ํ•˜๊ฒŒ ์ž‘์„ฑํ•˜์ง€ ์•Š์€๊ฑด๊ฐ€? ๋“ฑ๋“ฑ ์—ฌ๋Ÿฌ๊ฐ€์ง€ ํ™•์ธ์ ์„ ๊ฐ€์ง€๊ณ  ํ™•์ธ์„ ํ•ด๋ณด์•˜๋‹ค. ํ•˜์ง€๋งŒ ๊ทธ๋Ÿฐ ๋ชจ๋“  ๋ถ€๋ถ„์ด ์•„๋‹ˆ๊ณ  ๋‚ด๊ฐ€ ์„ค์ •ํ•œ js์—์„œ http๋กœ ์š”์ฒญํ•˜๋ฉด https๋กœ ๋ฐ”๋กœ ์—ฐ๊ฒฐ๋˜๊ฒŒ ํ•œ js๊ฐ€ ๋ฌธ์ œ์˜€๋‹ค. ๊ฐœ๋ฐœ์„œ๋ฒ„์—๋Š” ์‹ ๋ขฐํ• ์ˆ˜ ์žˆ๋Š” SSL ๋ณด์•ˆ์ธ์ฆ์„œ๊ฐ€ ๋“ฑ๋ก๋˜์–ด ์žˆ๊ฑฐ๋‚˜ OpenSSL๊ณผ ๊ฐ™์€ ๋ณด์•ˆ ์ •์ฑ…์ด ๋“ฑ๋ก๋˜์–ด ์žˆ์ง€ ์•Š์€ ์ƒํƒœ์˜€๊ธฐ์— ์œ„์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•œ ๊ฒƒ์ด๋‹ค. ๊ทธ๋ž˜์„œ ํ•ด๋‹น js๋ฅผ ์ฃผ์„์ฒ˜๋ฆฌํ•˜๊ณ  ๊ฐœ๋ฐœ์„œ๋ฒ„๋ฅผ ์‹คํ–‰ํ•˜์˜€.. 2022. 6. 6.
[Java Error] java.lang.IllegalStateException: Optional int parameter 'bo_no' is present but cannot be translated into a null value due to being declared as a primitive type. ์—๋Ÿฌ ํ•ด๊ฒฐ๋ฐฉ๋ฒ• Rest Api ํ†ต์‹ ์ค‘, ์„œ๋ฒ„๋กœ int bo_no ํŒŒ๋ผ๋ฏธํ„ฐ๋ฅผ ๋ฐ›์•„ ์ฒ˜๋ฆฌํ•˜๋Š” ํ•จ์ˆ˜๊ฐ€ ์žˆ๋Š”๋ฐ ์š”์ฒญ๋„ ์•ˆ์˜ค๊ณ  ๊ทธ๋ƒฅ 500์—๋Ÿฌ๋งŒ ์ถœ๋ ฅํ•˜๋Š” ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. ์—๋Ÿฌ๋กœ๊ทธ๋Š” ์•„๋ž˜์™€ ๊ฐ™๋‹ค. java.lang.IllegalStateException: Optional int parameter 'bo_no' is present but cannot be translated into a null value due to being declared as a primitive type. [ ๊ตฌ๊ธ€ ๋ฒˆ์—ญ ] ๊ตฌ๊ธ€ ๋ฒˆ์—ญ์„ ํ•ด๋ณด๋‹ˆ, bo_no๊ฐ€ ํŒŒ๋ผ๋ฏธํ„ฐ๋กœ ์†์„ฑ์œผ๋กœ ๋„˜์–ด์˜ค์ง€๋งŒ, ๊ฐ’์ด ์—†์–ด null์ฒ˜๋ฆฌ๋ฅผ ํ•˜๋ ค๊ณ  ํ–ˆ์œผ๋‚˜ int๋ผ null ๋ณ€ํ™˜์ด ์•ˆ๋œ๋‹ค๋Š” ์—๋Ÿฌ๋‹ค. ์„ ํƒ์  int ๋งค๊ฐœ๋ณ€์ˆ˜ 'bo_no'๊ฐ€ ์žˆ์ง€๋งŒ ๊ธฐ๋ณธ ์œ ํ˜•์œผ๋กœ ์„ ์–ธ๋˜์—ˆ๊ธฐ ๋•Œ๋ฌธ์— nul.. 2021. 12. 29.