์ ์ฒด ๊ธ
-
[SpringQuartz] FOR UPDATE ์ ์ DECLARE CURSOR์์๋ง ์ฌ์ฉํ ์ ์์ต๋๋ค.Dev_Log 2023. 3. 6. 15:00
[ ์๋ฌ ๋ฐ์ ์ํฉ ] 01. SpringQuartz๋ฅผ MS-SQL๊ณผ ์ฐ๋ํ๊ธฐ์ํด ์ธํ ํ ํ๋ก์ ํธ ๊ตฌ๋ 02. ์๋ ์๋ฌ ๋ฐ์ org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@1d204519 jd..
-
[MS-SQL] Microsoft SQL Server Versions ListDev_Info 2023. 2. 28. 17:46
Release RTM (no SP) Latest CU SQL Server 2022 SQL Server latest version SQL Server 16 codename Dallas Release date: 2022-11-16 Support end date: 2028-01-11 Ext. end date: 2033-01-11 16.0.1000.6 CU1 (16.0.4003.1, February 2023) SQL Server 2019 SQL Server 15 codename Aris Seattle Release date: 2019-11-04 Support end date: 2025-01-07 Ext. end date: 2030-01-08 15.0.2000.5 CU19 (15.0.4298.1, February..
-
[Oracle] ORA-28014: ๊ด๋ฆฌ ์ฌ์ฉ์ ๋๋ ๋กค์ ์ญ์ ํ ์ ์์ต๋๋ค.Dev_Log 2023. 2. 22. 11:02
[ ์๋ฌ ๋ฐ์ ์ํฉ ] 01. ํ ์คํธ๋ก ์์ฑํ ๊ณ์ ์ญ์ ๋ฅผ ์๋ 02. ์๋ ์๋ฌ ๋ฐ์ ORA-28014: ๊ด๋ฆฌ ์ฌ์ฉ์ ๋๋ ๋กค์ ์ญ์ ํ ์ ์์ต๋๋ค. [ Solution ] 01. ์๋SQL ์คํ --ORA-28014: ๊ด๋ฆฌ ์ฌ์ฉ์ ๋๋ ๋กค์ ์ญ์ ํ ์ ์์ต๋๋ค. --๋ฅผ ํด๊ฒฐํ๊ธฐ ์ํ SQL๋ฌธ ALTER SESSION SET "_oracle_script" = true; 02. ์ ์์ํ