[MariaDB] Spring Boot Unknown database ์—๋Ÿฌ DB ์—ฐ๋™ ์‹คํŒจ
ยท
Project
DB์— ์นผ๋Ÿผ ์ค‘๋ณต์œผ๋กœ ์ž…๋ ฅ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•ด ๊ณผ๊ฐํžˆ DB๋ฅผ ์‚ญ์ œํ•˜์˜€๋‹ค.ํ•˜์ง€๋งŒ ์ด๊ฒŒ ๋ฌด์Šจ ์ผ์ธ๊ฐ€?์„œ๋ฒ„๋ฅผ ์žฌ์‹คํ–‰ ํ•˜์˜€๋”๋‹ˆ ์œ„์™€ ๊ฐ™์€ Unknown database ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. ์ฆ‰,  onefitdb๋ผ๋Š” ์ด๋ฆ„์˜ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๊ฐ€ ์กด์žฌํ•˜์ง€ ์•Š์•„์„œ ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์ด ์—ฐ๊ฒฐํ•˜์ง€ ๋ชปํ•˜๊ณ  ์žˆ๋Š” ์ƒํƒœ์ด๋‹ค ๐Ÿ˜ก  ๋นจ๋ฆฌ ์ž‘์—… ํ•ด์•ผํ•˜๋Š”๋ฐ DB ์ƒ์„ฑ ๋ฌธ์ œ๊ฐ€ ํ„ฐ์ง€๋‹ค๋‹ˆ.. ๊ทธ๋ž˜๋„ ์–ธ์ œ๋‚˜ ๊ทธ๋žฌ๋“ฏ ๋ฌธ์ œ ํ•ด๊ฒฐ์„ ์‹œ์ž‘ํ•ด๋ณธ๋‹ค ์ธํ…”๋ฆฌ์ œ์ด ๊ฐœ๋ฐœํ™˜๊ฒฝ์—์„œ onefitdb์— ์ƒ์„ฑ์„ ์‹œ๋„ํ•˜์˜€๋‹ค.   ๊ฐœ๋ฐœํ™˜๊ฒฝ์—์„œ DB ์ƒ์„ฑ์€ ์‹คํŒจํ•˜์˜€๋‹ค ๐Ÿ˜ญ ํ•ญ์ƒ ์ด๋ ‡๊ฒŒ ํ•ด์™”๊ธฐ ๋•Œ๋ฌธ์— ์กฐ๊ธˆ ๋‹นํ™ฉ์Šค๋Ÿฌ์› ๋‹ค  ํ  ๊ทธ๋Ÿผ ์ง์ ‘ MariaDB ์„œ๋ฒ„์— ์ ‘์†ํ•ด์„œ DB๋ฅผ ๋งŒ๋“ค์–ด์ฃผ๋Š” ๋ฐฉ๋ฒ•์œผ๋กœ ์ ‘๊ทผํ–ˆ๋‹ค 1. ๋ช…๋ น์–ด๋กœ MariaDB ์ ‘์† (MaridDB XX\bin ์ฃผ์†Œ๋กœ ์ด๋™) 2. ๋ช…๋ น์–ด ์ž…๋ ฅ..
[Spring JPA] No property found for type ๋ฐœ์ƒ ์›์ธ๊ณผ ํ•ด๊ฒฐ๋ฒ•
ยท
Project
No property 'recruit' found for type 'Recruit_Register'org.springframework.data.mapping.PropertyReferenceException:  ๐Ÿ’ฅ ํ”„๋กœ์ ํŠธ ์ค‘ DTO ↔ domain ๋งคํ•‘ ๊ณผ์ •์—์„œ ์œ„์™€ ๊ฐ™์€ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. ์˜ค๋ฅ˜ ๋ฐœ์ƒ ์›์ธ์„ ํŒŒ์•…ํ•ด๋ณด๋‹ˆ ํ•„๋“œ๋ช…์˜ ๋ฌธ์ œ๊ฐ€ ์žˆ์—ˆ๋‹ค.ํ•„๋“œ๋ช…์— ์–ธ๋”๋ฐ”(_)๋ฅผ ์‚ฌ์šฉํ–ˆ๋Š”๋ฐ ์ด๋ฅผ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ, JPA ๋ฉ”์„œ๋“œ๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์—†์„ ์ˆ˜ ์žˆ๋‹ค๋Š” ๊ฒƒ์ด๋‹ค. * ๊ธฐ์กด ์–ธ๋”๋ฐ” ํ‘œ๊ธฐ๋ฒ• @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long recruit_id; ๐Ÿ’ซ ๋”ฐ๋ผ์„œ ๊ธฐ์กด์˜ recruit_id ์—์„œ recruitId ๋กœ *์นด๋ฉœ ํ‘œ๊ธฐ..
[MyBatis] : select : Spring๊ณผ ์—ฐ๋™ ๋งˆ์ด๋ฐ”ํ‹ฐ์Šค๋กœ DB ์กฐํšŒ
ยท
Framework
1. ์–ด๋…ธํ…Œ์ด์…˜์„ ํ™œ์šฉํ•œ select ๋ฌธMyBatis ์—๋Š” @Select ์–ด๋…ธํ…Œ์ด์…˜์„ ์ด์šฉํ•ด์„œ ์ฟผ๋ฆฌ๋ฅผ ์ž‘์„ฑํ•  ์ˆ˜ ์žˆ๋‹ค.* ์ฃผ์˜ : ๊ตฌ๋ฌธ ๋์— ' ; ' ์„ ์ด์šฉํ•˜์ง€ ์•Š๋Š”๋‹ค.2. XML์„ ํ™œ์šฉํ•œ select ๋ฌธMyBatis๋ฅผ ์ด์šฉํ•  ๋•Œ๋Š” SQL์„ ๋ณ„๋„์˜ ํŒŒ์ผ๋กœ ๋ถ„๋ฆฌํ•˜๋Š” ๊ฒƒ์„ ๊ถŒ์žฅํ•œ๋‹ค.XML ํŒŒ์ผ์— SQL ์„ ์ž‘์„ฑํ•˜๋Š” ์ด์œ ๋Š” SQL์ด ๊ธธ์–ด์ง€๋ฉด ์ด๋ฅผ ์–ด๋…ธํ…Œ์ด์…˜์œผ๋กœ ์ฒ˜๋ฆฌํ•˜๊ธฐ๊ฐ€ ๋ณต์žกํ•ด์ง€๊ณ  ์–ด๋…ธํ…Œ์ด์…˜์ด ๋ณ€๊ฒฝ๋˜๋ฉดํ”„๋กœ์ ํŠธ ์ „์ฒด๋ฅผ ๋‹ค์‹œ ๋นŒ๋“œํ•˜๋Š” ์ž‘์—…์ด ํ•„์š”ํ•˜๊ธฐ ๋•Œ๋ฌธ์— ๋‹จ์ˆœ ํŒŒ์ผ๋กœ ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ์„ ๊ถŒ์žฅํ•œ๋‹ค. XML์„ ์ž‘์„ฑํ•  ๋•Œ๋Š” ํƒœ๊ทธ์˜ namespace ์†์„ฑ์„ ๋ฐ˜๋“œ์‹œ ๋งคํผ ์ธํ„ฐํŽ˜์ด์Šค ์ด๋ฆ„๊ณผ ๋™์ผํ•˜๊ฒŒ ์ง€์ •ํ•ด์•ผ ํ•œ๋‹ค. ํƒœ๊ทธ์—๋Š” ๊ตฌ๋ฌธ์˜ ์ด๋ฆ„(id)๊ณผ ๋ฉ”์„œ๋“œ ๋ช…์„ ์ผ์น˜์‹œํ‚ค๊ณ , ๋ฐ˜ํ™˜ํƒ€์ž…(resultType)์„ ๋งž์ถฐ์ค˜์•ผ ํ•œ๋‹ค 3. ..
[Java] Lombok ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ๋ฅผ ์‚ฌ์šฉํ•œ JDBC ํ”„๋กœ๊ทธ๋ž˜๋ฐ
ยท
Java
[ Lombok ์ด๋ž€? ]@์–ด๋…ธํ…Œ์ด์…˜ ๊ธฐ๋ฐ˜์œผ๋กœ ์ฝ”๋“œ๋ฅผ ์ž๋™์™„์„ฑ ํ•ด์ฃผ๋Š” ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์ด๋‹ค. Lombok์„ ์ด์šฉํ•˜๋ฉด Model ํด๋ž˜์Šค์˜ getter,setter ๋“ฑ ๋‹ค์–‘ํ•œ๋ฉ”์„œ๋“œ๋“ค์„ ์ž‘์„ฑํ•˜์ง€ ์•Š์•„๋„ ์ž๋™์™„์„ฑ ์‹œ์ผœ์ฃผ๊ธฐ ๋•Œ๋ฌธ์— ์ฝ”๋“œ๊ฐ€ ๊ฐ„๊ฒฐํ•˜๊ณ  ๋‹จ์ˆœํ™”๋˜๋Š” ์žฅ์ ์ด ์žˆ๋‹ค.  [ Lombok ์‚ฌ์šฉ ์˜ˆ์ œ ]Lombok ์‚ฌ์šฉ โŒ โ˜‘๏ธ Lombok์„ ์‚ฌ์šฉํ•˜์ง€ ์•Š์œผ๋ฉด Getter, Setter ๋ฉ”์„œ๋“œ๋ฅผ ์•„๋ž˜์™€ ๊ฐ™์ด ์ž‘์„ฑํ•ด์•ผ ํ•œ๋‹ค.(์ฝ”๋“œ๊ฐ€ ๊ธธ์–ด์ง„๋‹ค)public class TodoDTO { private Long tno; private String title; private LocalDate dueDate; private boolean finished; public Long getTno() { ..