2024/05 6

[๋ฌธ์ œ ํ’€์ด] ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค - ์ฒด์œก๋ณต(java)

ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค - ์ˆ˜์—ด๊ณผ ๊ตฌ๊ฐ„ ์ฟผ๋ฆฌ2(java)ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ฌธ์ œ ํ’€์ด ์ž…๋‹ˆ๋‹ค !์˜ค๋ฅ˜๊ฐ€ ์žˆ๋‹ค๋ฉด ๋Œ“๊ธ€๋กœ ๋‚จ๊ฒจ์ฃผ์„ธ์š” :) 1. ์ฒ˜์Œ ์ œ์ถœํ•œ ์ฝ”๋“œ2. ๋‹ค์Œ ์ œ์ถœํ•œ ์ฝ”๋“œ1. ์ฒ˜์Œ ์ œ์ถœํ•œ ์ฝ”๋“œimport java.util.Arrays;class Solution { public int solution(int n, int[] lost, int[] reserve) { int answer = n - lost.length; Arrays.sort(lost); Arrays.sort(reserve); for (int i = 0; i   ๋ฌธ์ œ๋ฅผ ๋ณด๊ณ  ์•ž ์‚ฌ๋žŒ๊ณผ ๋’ท ์‚ฌ๋žŒ์—๊ฒŒ ๋นŒ๋ฆด ์ˆ˜ ์žˆ๋Š” ๊ฒฝ์šฐ๋ฅผ ์ƒ๊ฐํ•˜์—ฌ ์œ„์™€ ๊ฐ™์ด ์ฝ”๋“œ๋ฅผ ์ž‘์„ฑํ–ˆ๋‹ค.ํ…Œ์ŠคํŠธ ์‹คํ–‰ํ–ˆ์„ ๋•Œ..

[infra] AWS EC2 ์‹คํ–‰ ์˜ค๋ฅ˜ ํ•ด๊ฒฐํ•˜๊ธฐ

AWS EC2 ์‹คํ–‰ ์˜ค๋ฅ˜ ํ•ด๊ฒฐํ•˜๊ธฐspring project ๋ฐฐํฌํ•˜๋ฉด์„œ ๊ณต๋ถ€ํ•œ ๋‚ด์šฉ ์ •๋ฆฌ ์ž…๋‹ˆ๋‹ค ! 1. ๋ฌธ์ œ ์ƒํ™ฉ1. ๋ฌธ์ œ ์ƒํ™ฉ์ฒ˜์Œ์—๋Š” ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๊ฐ€ ์—ฐ๊ฒฐ๋˜์ง€ ์•Š์•„ ์˜ค๋ฅ˜๊ฐ€ ๋‚ฌ๊ธฐ ๋•Œ๋ฌธ์— ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์—ฐ๊ฒฐํ•ด์คฌ๋‹ค.๊ทธ ํ›„์— ์‹คํ–‰์‹œ์ผฐ๋Š”๋ฐ ์•„๋ž˜์™€ ๊ฐ™์ด ์ปดํŒŒ์ผ ๋ฉˆ์ถค ํ˜„์ƒ์ด ์ผ์–ด๋‚œ๋‹ค. ์ด๋Ÿฐ ๊ฒฝ์šฐ์—๋Š” ๋ฉ”๋ชจ๋ฆฌ ๋ถ€์กฑ ํ˜„์ƒ์ด๋ผ๊ณ  ํ•˜๋˜๋ฐ, ํ•ด๊ฒฐํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” RDS๋ฅผ ์‚ฌ์šฉํ•˜๊ฑฐ๋‚˜ RAM์„ ๋Š˜๋ฆฌ๊ฑฐ๋‚˜ ํ•ด์•ผ๋œ๋‹ค๊ณ  ํ•œ๋‹ค.Hello world ์ถœ๋ ฅํ•˜๋Š” ์‚ฌ์ดํŠธ๋ฅผ ์˜ฌ๋ ธ์„ ๋• ๋นŒ๋“œ๊ฐ€ ์ž˜ ๋๋Š”๋ฐ, mysql์„ ์„ค์น˜ํ•˜๊ณ  build๋ฅผ ํ•˜๊ฒŒ ๋˜๋ฉด ๊ณ„์† ์ด๋Ÿฐ ์˜ค๋ฅ˜๊ฐ€ ๋‚œ๋‹ค.ํ”„๋ฆฌํ‹ฐ์–ด๋ฅผ ์‚ฌ์šฉํ•  ๋•Œ๋Š” ์ด๋Ÿฐ ๊ฒƒ๋„ ์‹ ๊ฒฝ ์จ์„œ ํ•ด์•ผ๋œ๋‹ค๋Š” ๊ฒƒ์„ ๋‹ค์‹œ๊ธˆ ๋Š๊ผˆ๋‹ค.

[infra] AWS EC2 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์—ฐ๊ฒฐํ•˜๊ธฐ

AWS EC2 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์—ฐ๊ฒฐํ•˜๊ธฐspring project ๋ฐฐํฌํ•˜๋ฉด์„œ ๊ณต๋ถ€ํ•œ ๋‚ด์šฉ ์ •๋ฆฌ ์ž…๋‹ˆ๋‹ค ! 1. ๋ฌธ์ œ ์ƒํ™ฉ2. ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•1. ๋ฌธ์ œ ์ƒํ™ฉ์ „์—๋Š” ๋นŒ๋“œ ์˜ค๋ฅ˜, ์ด๋ฒˆ์—๋Š” ์‹คํ–‰ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค.1. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure2. Caused by: java.net.ConnectException: Connection refused3. java.lang.NullPointerException: Cannot invoke "org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(java.sql.SQLException, String)" ..

[infra] AWS EC2 build ์˜ค๋ฅ˜ ํ•ด๊ฒฐํ•˜๊ธฐ

AWS EC2 build ์˜ค๋ฅ˜ ํ•ด๊ฒฐํ•˜๊ธฐspring project ๋ฐฐํฌํ•˜๋ฉด์„œ ๊ณต๋ถ€ํ•œ ๋‚ด์šฉ ์ •๋ฆฌ ์ž…๋‹ˆ๋‹ค ! 1. ๋ฌธ์ œ ์ƒํ™ฉ2. ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•1. ๋ฌธ์ œ ์ƒํ™ฉ BoardApplicationTests > contextLoads() FAILED java.lang.IllegalStateException at DefaultCacheAwareContextLoaderDelegate.java:180 Caused by: org.springframework.beans.factory.BeanCreationException at AbstractAutowireCapableBeanFactory.java:1786 Caused by: org.hibernate.service.spi.ServiceExcept..

[infra] AWS EC2 ๋ฐฐํฌํ•˜๊ธฐ

AWS EC2 ๋ฐฐํฌํ•˜๊ธฐspring project ๋ฐฐํฌํ•˜๋ฉด์„œ ๊ณต๋ถ€ํ•œ ๋‚ด์šฉ ์ •๋ฆฌ ์ž…๋‹ˆ๋‹ค ! 1. ๋ฐฐํฌํ•˜๋ฉด์„œ ๊ฒช์€ ๋ฌธ์ œ2. ํšŒ๊ณ ๋ก3. ๋นŒ๋“œ ์‹œ ์‚ฌ์šฉํ•œ ๋ฆฌ๋ˆ…์Šค ๋ช…๋ น์–ด ๋ชจ์Œ1. ๋ฐฐํฌํ•˜๋ฉด์„œ ๊ฒช์€ ๋ฌธ์ œ- springboot-boardspring ๊ณต๋ถ€ํ•˜๋ฉด์„œ ๊ฒŒ์‹œํŒ ํ”„๋กœ์ ํŠธ๋ฅผ ๋งŒ๋“ค์–ด๋ดค๊ณ , ๋‹ค์Œ์œผ๋กœ๋Š” ๋ฐฐํฌํ•˜๊ณ ์ž ํ–ˆ๋‹ค.์œ ํŠœ๋ธŒ ๊ฐ•์˜์™€ ๋ธ”๋กœ๊ทธ๋ฅผ ๋ณด๋ฉด์„œ ์ธ์Šคํ„ด์Šค ์ƒ์„ฑ ํ•œ ํ›„ sshํ‚ค๋ฅผ ๊นƒํ—ˆ๋ธŒ์— ๋“ฑ๋กํ•˜์—ฌ ์ ‘์†ํ•˜๋Š” ๊ฒƒ ๊นŒ์ง€๋Š” ์„ฑ๊ณตํ–ˆ๋‹ค.ํ•˜์ง€๋งŒ git clone ํ•ด์„œ ์‹ค์ œ๋กœ ๋‚ด ํ”„๋กœ์ ํŠธ๋ฅผ ์‹คํ–‰ํ•˜๋ ค๊ณ  ํ•˜๋‹ˆ๊นŒ  Gradle ์˜ค๋ฅ˜๊ฐ€ ๋–ด๋‹ค. ์˜ค๋ฅ˜ ๋กœ๊ทธ๋ฅผ ๋ดค์„ ๋•Œ, ๋ฒ„์ „์ด๋‚˜ ํ…Œ์ŠคํŠธ ์ฝ”๋“œ์—์„œ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค๋Š” ๋‚ด์šฉ์ธ ๊ฒƒ ๊ฐ™๋‹ค.์ด์— ๋Œ€ํ•ด์„œ๋Š” ๊ณต๋ถ€๋ฅผ ์กฐ๊ธˆ ๋” ํ•œ ํ›„์— ์˜ค๋ฅ˜๋ฅผ ํ•ด๊ฒฐํ•˜๊ณ ์ž ํ•œ๋‹ค. - aws-test์˜ค๋Š˜์€ ๋ฐฐํฌํ•ด๋ณด๋Š” ๊ฒƒ์ด ๋ชฉ์ ์ด์—ˆ๊ธฐ ๋•Œ๋ฌธ..

[spring] ์Šคํ”„๋ง์œผ๋กœ CRUD ๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ๊ตฌ๊ธ€ ๋กœ๊ทธ์ธ

์Šคํ”„๋ง์œผ๋กœ CRUD ๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ๊ตฌ๊ธ€ ๋กœ๊ทธ์ธ์Šคํ”„๋ง ๊ณต๋ถ€ํ•˜๋ฉด์„œ ์ •๋ฆฌํ•œ ๋‚ด์šฉ ์ž…๋‹ˆ๋‹ค !์˜ค๋ฅ˜๊ฐ€ ์žˆ๋‹ค๋ฉด ๋Œ“๊ธ€๋กœ ๋‚จ๊ฒจ์ฃผ์„ธ์š” :) https://jcowwk.tistory.com/135 [spring] ์Šคํ”„๋ง์œผ๋กœ CRUD ๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ํŽ˜์ด์ง• ์ฒ˜๋ฆฌ, TIMESTAMP์Šคํ”„๋ง์œผ๋กœ CRUD ๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ํŽ˜์ด์ง• ์ฒ˜๋ฆฌ, TIMESTAMP ์Šคํ”„๋ง ๊ณต๋ถ€ํ•˜๋ฉด์„œ ์ •๋ฆฌํ•œ ๋‚ด์šฉ ์ž…๋‹ˆ๋‹ค ! ์˜ค๋ฅ˜๊ฐ€ ์žˆ๋‹ค๋ฉด ๋Œ“๊ธ€๋กœ ๋‚จ๊ฒจ์ฃผ์„ธ์š” :) 1. ํŽ˜์ด์ง• ์ฒ˜๋ฆฌ 2. TIMESTAMP https://jcowwk.tistory.com/133 [spring] ์Šคํ”„jcowwk.tistory.com ๋ณธ ํฌ์ŠคํŒ…๊ณผ ์ด์–ด์ง‘๋‹ˆ๋‹ค.  1. oauth22. ๊ตฌ๊ธ€ ๋กœ๊ทธ์ธ1. oauth2https://jcowwk.tistory.com/138 [security..