Posts

Showing posts from May, 2024

[Quick Solution] Someone else is still using this PC. If you shut down now, they could lose unsaved work.

Image
[Issue] Recently, I added a user to my Windows desktop computer so that my son and I could use it together. Each of us logs in with our own IDs. However, when we finish using the computer and try to shut it down, we encounter the following message: “ Someone else is still using this PC. If you shut down now, they could lose unsaved work. ” Ignoring it and shutting down anyway is an option, but this message keeps bothering us, and it leaves an uncomfortable feeling. [Solution] As shown below, navigate to Settings > Accounts > Sign-in options > Additional settings, and change the setting for “ Use my sign-in info to automatically finish setting up after an update ” from “On” to “Off.” This resolves the issue.  ( Note: The same setting must be applied to all users added to Windows. ) End.  Source:  https://m.blog.naver.com/beyond-gem/223460078213

[Simple Note] Select … For Update Options in Oracle (WAIT, NOWAIT, SKIP LOCKED)

Image
In Oracle, the SELECT ... FOR UPDATE statement allows you to acquire an exclusive lock on selected rows.  1. FOR UPDATE with no option  : In this case, Oracle waits indefinitely until it acquires the lock. If another session already holds the lock, it will wait until the lock is released.  2. FOR UPDATE WAIT integer  : With this option, Oracle retries acquiring the lock for the specified duration (in seconds). If the lock cannot be obtained during this time, the query fails with an  ORA-30006 error.  SELECT ename FROM scott.emp WHERE empno = 7900 FOR UPDATE WAIT 5 ;   3. FOR UPDATE NOWAIT (=  WAIT 0 ) : If the lock cannot be acquired immediately, Oracle raises an ORA-00054 error. This means that if another session has already locked the rows, the query fails immediately.  SELECT ename FROM scott.emp WHERE empno = 7900 FOR UPDATE NOWAIT;   4. FOR UPDATE OF  ... column  : This syntax locks the select rows only f...

[Quick Solution] Naver Blog Broken Issues on Microsoft Edge Mobile Browser

Image
[Issue]   Since the early days of using Microsoft Edge Mobile browser, I've encountered a persistent problem with Naver blog screens breaking. Despite numerous refresh attempts, the screens would stubbornly remain white, causing frustration. [Solution]   Recently, I discovered that advertisements on Naver blogs were conflicting with the ad blocking feature of mobile Edge.   To resolve this, I added the Naver blog URL to the ad blocking exceptions in settings, as follows:   ( Settings > Privacy and Security > Block Ads > Exceptions > Add Site > Enter "https://m.blog.naver.com/" and save )   Now, I can smoothly browse Naver blogs on mobile Edge without encountering screen breakage. However, it's worth noting that Naver blog ads are now visible. End. Source: https://m.blog.naver.com/beyond-gem/223436570433

[Quick Solution] Add Another Custom ObjectMapper Configuration in Spring Boot

[Issue]   I have a system that provides Rest APIs using Spring Boot, communicating smoothly with clients via JSON. Recently, I encountered a situation where I needed to communicate with a new server using slightly different JSON communication rules.   To accommodate this, I added a custom ObjectMapper Bean ("myObjectMapper") to my configuration.   However, after doing so, the previously functioning Rest APIs started to misbehave, giving the impression that the newly added myObjectMapper was being used even in the existing JSON communications. @Configuration public class MyConfiguration { @Bean ObjectMapper myObjectMapper () { ObjectMapper mapper1 = new ObjectMapper(); mapper1.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false ); // ... return mapper1; } } [Solution]   To address this issue, I added the following Primary Bean configuration for "jacksonObjectMapper" with the annotation @ConditionalOnMissingBean(name = "ja...