์ „์ฒด ๊ธ€ 128

[Oracle] ORA-12506 TNS:listener rejected connection based on service ACL filtering ์˜ค๋ฅ˜

Oracle Cloud ํ†ตํ•ด DB๋ฅผ ๋งŒ๋“ค์—ˆ๊ณ , ACL์— ๋‚ด ip๋ฅผ ๋“ฑ๋กํ•ด์คฌ๋‹ค. Listener refused the connection with the following error: ORA-12506, TNS:listener rejected connection based on service ACL filtering ๊ทธ๋Ÿฐ๋ฐ ์ด๋Ÿฌํ•œ ์˜ค๋ฅ˜๊ฐ€ ๋–ด๋‹ค. ๋‹ค ๋’ค์ ธ๋„ ACL์— ip๋ฅผ ๋“ฑ๋กํ•˜์ง€ ์•Š์•„์„œ ๋‚˜๋Š” ์˜ค๋ฅ˜๋ผ๋Š”๋ฐ.. ๋‚œ ๋ถ„๋ช… ๋“ฑ๋กํ–ˆ๋‹ค.. ์—ฌ๊ธฐ์„œ Edit ๋ˆ„๋ฅด๊ณ , 'Add My Ip address' ๋ฅผ ๋ˆŒ๋ €๋”๋‹ˆ ๋‚ด๊ฐ€ ์•Œ๋˜ ip์™€ ๋‹ค๋ฅธ ip๊ฐ€ ์ž…๋ ฅ๋˜์—ˆ๋‹ค.. ์•Œ๊ณ ๋ณด๋‹ˆ ipconfig์—์„œ ๋ณด์—ฌ์ง€๋Š” ip๊ฐ€ ์•„๋‹Œ, ๊ณต์ธ์•„์ดํ”ผ๋ฅผ ์ž…๋ ฅํ•ด์•ผํ•˜๋Š” ๊ฒƒ!! About - ๋‚ด ์•„์ดํ”ผ ํ™•์ธ (My ip address) - ip.pe.kr A..

DBMS/Oracle 2024.04.15

[SpringBoot] Java 1.8 ์Šคํ”„๋ง๋ถ€ํŠธ 2.7.x ํ”„๋กœ์ ํŠธ ๋งŒ๋“ค๊ธฐ

1. STS ์„ค์น˜ Spring Tools 4 for Eclipse ๋ฅผ ์„ค์น˜ Intellij๋„ ์‚ฌ์šฉํ•ด๋ณด๊ณ  ์‹ถ์—ˆ์ง€๋งŒ, ๋ฌด๋ฃŒ๋ฒ„์ „์—๋Š” ์ œ์•ฝ์ด ์žˆ์–ด์„œ ๋ง˜ํŽธํžˆ ์ดํด๋ฆฝ์Šค๋กœ ๊ฒฐ์ •! https://spring.io/tools Spring | Tools spring.io ๊ฐ€์žฅ ์ตœ์‹  ๋ฒ„์ „์„ ๋ฐ›์•˜๊ณ , jarํŒŒ์ผ๋กœ ๋ฐ›์•„์ง jarํŒŒ์ผ๋ช…์ด ๊ต‰์žฅํžˆ ๊ธธ๊ธฐ ๋•Œ๋ฌธ์—, sts4๋กœ ๋ณ€๊ฒฝ ํ›„์— ์›ํ•˜๋Š” ๋””๋ ‰ํ† ๋ฆฌ๋กœ ์ด๋™์‹œํ‚ค๊ณ  ํ•ด๋‹น ๋””๋ ‰ํ† ๋ฆฌ์—์„œ cmd๋ฅผ ์—ด์–ด ๋ช…๋ น์–ด ์ž…๋ ฅ. java -jar sts4.jar ๋ช…๋ น์–ด๋ฅผ ์น˜๋ฉด sts-4.22.0.RELEASE ํด๋”๊ฐ€ ์ƒ์„ฑ๋˜๊ณ  ํด๋” ๋‚ด๋ถ€์˜ SpringToolSuite4.exe๋กœ ์„ค์น˜๋ฅผ ์ง„ํ–‰. 2. JDK ์„ค์น˜ ์‚ฌ์šฉํ•  sdk๊ฐ€ openJDK 8๋ฒ„์ „์„ ๊ถŒ์žฅํ•˜๊ธฐ ๋•Œ๋ฌธ์— 8๋ฒ„์ „์œผ๋กœ ์„ค์น˜ - java-1.8.0-o..

Programming/Java 2024.04.12

[React] ag-grid์—์„œ columnDef์˜ useMemo์™€ valueFormatter

0. ์ฒซ ๋ Œ๋”๋ง. ์ฝ”๋“œ๋ถ ์กฐํšŒ. /** ์ฝ”๋“œ ์ดˆ๊ธฐ๊ฐ’ ์กฐํšŒ */ useEffect(() => { getCodeList(); // ์ฝ”๋“œ๋ถ ์กฐํšŒ // eslint-disable-next-line react-hooks/exhaustive-deps }, []); 1. ์ฝ”๋“œ๋ถ์—์„œ ์ƒํƒœ์— ๋Œ€ํ•œ ์ฝ”๋“œ๋ฅผ ๊ฐ€์ ธ์™€์„œ setJobStausCd ํ•ด์ค€๋‹ค. const [jobStatusCd, setJobStatusCd] = useState([]); 2. ์ด ํ™”๋ฉด์€ ์ž๋™์กฐํšŒ๊ฐ€ ๋˜์–ด์„œ, ์ฝ”๋“œ๋ถ ์กฐํšŒ ํ›„์—๋Š” ๋ฉ”์ธ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€์ ธ์˜จ๋‹ค. ๊ทธ ๋ฐ์ดํ„ฐ๋Š” dsRowData์— ๋„ฃ์–ด์ค€๋‹ค. const [dsRowData, setDsRowData] = useState([]); 3. ํ•ด๋‹น ๋ฐ์ดํ„ฐ์—์„œ ์ƒํƒœid ์นผ๋Ÿผ์ด ์žˆ๋Š”๋ฐ, id๊ฐ€ ์•„๋‹ˆ๋ผ name์„ ๋ณด์—ฌ์ฃผ..

Programming/React 2024.04.03

[ํŒจ์ŠคํŠธ์บ ํผ์Šค ๊ฐ•์˜] JS ๋ฐ์ดํ„ฐ

ECMAhttps://ko.wikipedia.org/wiki/ECMA%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8A%B8 ECMA์Šคํฌ๋ฆฝํŠธ - ์œ„ํ‚ค๋ฐฑ๊ณผ, ์šฐ๋ฆฌ ๋ชจ๋‘์˜ ๋ฐฑ๊ณผ์‚ฌ์ „์œ„ํ‚ค๋ฐฑ๊ณผ, ์šฐ๋ฆฌ ๋ชจ๋‘์˜ ๋ฐฑ๊ณผ์‚ฌ์ „. ECMA์Šคํฌ๋ฆฝํŠธ(ECMAScript, ๋˜๋Š” ES[1])๋ž€, Ecma International์ด ECMA-262 ๊ธฐ์ˆ  ๊ทœ๊ฒฉ์— ๋”ฐ๋ผ ์ •์˜ํ•˜๊ณ  ์žˆ๋Š” ํ‘œ์ค€ํ™”๋œ ์Šคํฌ๋ฆฝํŠธ ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด๋ฅผ ๋งํ•œ๋‹ค. ์ž๋ฐ”์Šคํฌ๋ฆฝํŠธ๋ฅผ ํ‘œko.wikipedia.orgJS = ES String๋ฌธ์ž๋ฐ์ดํ„ฐ๋Š” ํฐ๋”ฐ์˜ดํ‘œ, ์ž‘์€๋”ฐ์˜ดํ‘œ, ๋ฐฑํ‹ฑ(`)๋กœ ๋งŒ๋“ค ์ˆ˜ ์žˆ์Œ. ๋ฐฑํ‹ฑ์€ ${} ๋ฐ์ดํ„ฐ(ํ…œํ”Œ๋ฆฟ ๋ฆฌํ„ฐ๋Ÿด) ๋ฅผ ๋ฌธ์ž์—ด์— ์—ฐ๊ฒฐํ•  ๋•Œ ์‚ฌ์šฉ (๋ณด๊ฐ„)๋ฆฌํ„ฐ๋Ÿด : ๊ธฐํ˜ธ๋ฅผ ํ†ตํ•ด ๋ฐ์ดํ„ฐ๋ฅผ ๋งŒ๋“œ๋Š” ๋ฐฉ์‹. number์— undefined๋ฅผ ๋”ํ•˜๊ฒŒ ๋˜๋ฉด NaN..

๊ฐ•์˜ 2024.03.18

[ํŒจ์ŠคํŠธ์บ ํผ์Šค ๊ฐ•์˜] NODEJS

Node.js Chrome V8 JavaScript ์—”์ง„์œผ๋กœ ๋นŒ๋“œ๋œ JavaScript ๋Ÿฐํƒ€์ž„ -> ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด๊ฐ€ ๋™์ž‘ํ•˜๋Š” ํ™˜๊ฒฝ -> JavaScript์˜ ๋ฌธ๋ฒ•์„ ํ•ด์„ํ•˜๊ณ  ๊ทธ๊ฒƒ์„ ์‹ค์ œ๋กœ ๋™์ž‘์‹œ์ผœ์ค„ ์ˆ˜ ์žˆ๋Š” ์—”์ง„ ์›น๋ธŒ๋ผ์šฐ์ €์—์„œ๋Š” HTML, CSS, JS๋งŒ ์ž‘๋™. ๊ฐœ๋ฐœ์„ ๋„์™€์ฃผ๋Š” ๋ชจ๋“ˆ์„ ์„ค์น˜ํ•ด์„œ ๋„์›€์„ ๋ฐ›๊ณ ์ž ํ•  ๋•Œ, Node.js๋ฅผ ํ†ตํ•ด์„œ JavaScript๋กœ ๋ณ€ํ™˜ ํ•„์š”. https://nodejs.org/en Node.js Node.js® is a JavaScript runtime built on Chrome's V8 JavaScript engine. nodejs.org LTS ๋ฒ„์ „ ์„ค์น˜. node --version npm NPM(Node Package Manager)์€ ์ „ ์„ธ๊ณ„์˜ ๊ฐœ๋ฐœ์ž๋“ค์ด ๋งŒ๋“  ๋‹ค..

๊ฐ•์˜ 2024.03.18

[ AG-GRID ] ๋ณ€๊ฒฝ๋œ ๋ฐ์ดํ„ฐ๊ฐ€ ๊ทธ๋ฆฌ๋“œ์— ๋ฐ”๋กœ ๋ฐ˜์˜๋˜๊ฒŒ

applyTransaction์„ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค. const onCellValueChanged = (params: any) => { // ์ƒํƒœ๊ฐ€ '์ถ”๊ฐ€'๊ฐ€ ์•„๋‹ˆ๋ฉด ์ƒํƒœ๋ฅผ '์ˆ˜์ •'์œผ๋กœ ๋ณ€๊ฒฝ if (params.data.rowType !== '์ถ”๊ฐ€' && params.data.rowType !== '์‚ญ์ œ') { params.data.rowType = '์ˆ˜์ •'; const updatedData = [params.data]; params.api.applyTransaction({ update: updatedData }); } };

Programming/React 2024.03.11

[ TypeScript ] object์— key-value ํ•˜๋‚˜ ์ถ”๊ฐ€ (map ์ด์šฉ)

- ์กฐ๊ฑด์ด ์žˆ์„ ๋•Œ temp = temp.map((el: any) => (el.index === selectedData[i].index ? { ...el, rowType: '์‚ญ์ œ' } : el)); selectedDatas๋Š” ํ˜„์žฌ ์„ ํƒ๋˜์–ด ์žˆ๋Š” ํ–‰์„ ๋งํ•œ๋‹ค. (ag grid) ์„ ํƒ๋˜์–ด ์žˆ๋Š” index๊ณผ temp์— ์žˆ๋Š” index ๊ฐ’์ด ๊ฐ™์œผ๋ฉด rowType์— '์‚ญ์ œ'๋ผ๋Š” ๊ฐ’์„ ์ค€๋‹ค. const newData = callListcp.map((item: any) => ({ ...item, campaignName: initCampaignList?.find((el) => el.cdId === String(item.id))?.cdNm }));

[ํŒจ์ŠคํŠธ ์บ ํผ์Šค ๊ฐ•์˜] HTML ํ•ต์‹ฌ ์ •๋ฆฌ

๋ธ”๋ก(์ƒ์ž) ์š”์†Œ. ์ œ๋ชฉ์„ ์˜๋ฏธํ•˜๋Š” ์š”์†Œ. (Heading) h1~h6. ์ˆซ์ž๊ฐ€ ์ž‘์„์ˆ˜๋ก ๋” ์ค‘์š”ํ•œ ์ œ๋ชฉ์„ ์ •์˜. h1์€ ๋Œ€์ฃผ์ œ๋ผ์„œ ๋‚œ๋ฐœํ•˜๊ธฐ ๋ณด๋‹ค๋Š” h2~h4 ๋งŽ์ด ์”€. ๋ธ”๋ก(์ƒ์ž) ์š”์†Œ. ๋ฌธ์žฅ์„ ์˜๋ฏธํ•˜๋Š” ์š”์†Œ (Paragraph). pํƒœ๊ทธ ๋Œ€์‹  div์„ ์จ๋„ ์ƒ๊ด€์€ ์—†์Œ. ๋ธ”๋ก(์ƒ์ž) ์š”์†Œ. ์ˆœ์„œ๊ฐ€ ํ•„์š”์—†๋Š” ๋ชฉ๋ก์˜ ์ง‘ํ•ฉ์„ ์˜๋ฏธ. (Unordered List) ์ž์‹์œผ๋กœ li ํƒœ๊ทธ๊ฐ€ ๊ผญ ๋“ค์–ด๊ฐ€์•ผ ํ•จ. ๋ธ”๋ก(์ƒ์ž) ์š”์†Œ. ๋ชฉ๋ก ๋‚ด ๊ฐ ํ•ญ๋ชฉ (List Item) ์‚ฌ๊ณผ ๋”ธ๊ธฐ ์ธ๋ผ์ธ(๊ธ€์ž) ์š”์†Œ. ์ด๋ฏธ์ง€๋ฅผ ์‚ฝ์ž…ํ•˜๋Š” ์š”์†Œ (Image). src, alt ํ•„์ˆ˜ ์†์„ฑ. ์ธ๋ผ์ธ(๊ธ€์ž) ์š”์†Œ. ๋‹ค๋ฅธ/๊ฐ™์€ ํŽ˜์ด์ง€๋กœ ์ด๋™ํ•˜๋Š” ํ•˜์ดํผ๋งํฌ๋ฅผ ์ง€์ •ํ•˜๋Š” ์š”์†Œ. (Anchor) href : ๋งํฌ URL target : ๋งํฌ URL์˜ ..

๊ฐ•์˜ 2024.02.20

[ํŒจ์ŠคํŠธ ์บ ํผ์Šค ๊ฐ•์˜] HTML ๊ฐœ์š”

๋‚ด์šฉ ์‹œ์ž‘(์—ด๋ฆฐ) ํƒœ๊ทธ ์ข…๋ฃŒ(๋‹ซํžŒ) ํƒœ๊ทธ ๋ถ€๋ชจ์š”์†Œ, ์ƒ์œ„์š”์†Œ ์ž์‹์š”์†Œ, ํ•˜์œ„์š”์†Œ ๋นˆ(Empty) ํƒœ๊ทธ ๋‚ด์šฉ์„ ์ฑ„์šธ ์ˆ˜ ์—†๊ธฐ ๋•Œ๋ฌธ์— ์†์„ฑ์ด ํ•„์š”ํ•œ ๊ฒฝ์šฐ๊ฐ€ ๋งŽ์Œ. (ํ•„์ˆ˜์†์„ฑ) ex) meta ํƒœ๊ทธ๋Š” ๋‹ซํžŒ ํƒœ๊ทธ๊ฐ€ ์—†์Œ. vs ํŽธ๋ฆฌํ•จ ์•ˆ์ „ํ•จ HTML5์—์„œ๋Š” ๋‘˜๋‹ค ์‚ฌ์šฉ ๊ฐ€๋Šฅ. ๋‚ด์šฉ ๊ธ€์ž์™€ ์ƒ์ž ์š”์†Œ๊ฐ€ ํ™”๋ฉด์— ์ถœ๋ ฅ๋˜๋Š” ํŠน์„ฑ, ํฌ๊ฒŒ 2๊ฐ€์ง€๋กœ ๊ตฌ๋ถ„. ์ธ๋ผ์ธ(Inline) ์š”์†Œ : ๊ธ€์ž๋ฅผ ๋งŒ๋“ค๊ธฐ ์œ„ํ•œ ์š”์†Œ๋“ค. ๋ธ”๋ก(Block) ์š”์†Œ : ์ƒ์ž(๋ ˆ์ด์•„์›ƒ)๋ฅผ ๋งŒ๋“ค๊ธฐ ์œ„ํ•œ ์š”์†Œ๋“ค. ๋Œ€ํ‘œ์ ์ธ ์ธ๋ผ์ธ ์š”์†Œ. ๋ณธ์งˆ์ ์œผ๋กœ ์•„๋ฌด๊ฒƒ๋„ ๋‚˜ํƒ€๋‚ด์ง€ ์•Š๋Š”, ์ฝ˜ํ…์ธ  ์˜์—ญ์„ ์„ค์ •ํ•˜๋Š” ์šฉ๋„. ์š”์†Œ๊ฐ€ ์ˆ˜ํ‰์œผ๋กœ ์Œ“์ž„. → ํฌํ•จํ•œ ์ฝ˜ํ…์ธ  ํฌ๊ธฐ๋งŒํผ ์ž๋™์œผ๋กœ ์ค„์–ด๋“ฌ. Hello World Hello World - ๊ธ€์ž ์š”์†Œ๋Š” ๊ฐ€๋กœ, ์„ธ๋กœ ์‚ฌ์ด์ฆˆ๋ฅผ ์ง€์ •ํ•  ์ˆ˜ ..

๊ฐ•์˜ 2024.02.20

[ํŒจ์ŠคํŠธ ์บ ํผ์Šค ๊ฐ•์˜] ์›น์—์„œ ์‹œ์ž‘ํ•˜๊ธฐ

https://codepen.io/ CodePen An online code editor, learning environment, and community for front-end web development using HTML, CSS and JavaScript code snippets, projects, and web applications. codepen.io ๋ธŒ๋ผ์šฐ์ € ์Šคํƒ€์ผ ์ดˆ๊ธฐํ™” ๋ธŒ๋ผ์šฐ์ €๋งˆ๋‹ค ์—ฌ๋ฐฑ๊ฐ™์€ ๊ฒŒ ๋‹ค๋ฅด๊ธฐ ๋•Œ๋ฌธ์— ์ดˆ๊ธฐํ™” ํ•„์š”ํ•จ. https://www.jsdelivr.com/package/npm/reset-css jsDelivr - A free, fast, and reliable CDN for JS and Open Source Optimized for JS and ESM delivery fr..

๊ฐ•์˜ 2024.02.19