iruplace

mysql insert문 안에 select문 있을 시, error 발생 SQL Error [10930][HY000] : You can't specify target table insert into table_name (column1, column2, column3) values ((select ifnull(max(seq), 0) + 1 from table_name), 'value2', 'value3') 해결! insert문 안에 select max 함수를 사용 할 때는, select max 함수 table에 별칭 추가 insert into table_name (column1, column2, column3) values ((select ifnull(max(seq), 0) + 1 from table_nam..

Springboot request param VO class로 받을 시, 필수 값 null일 경우 exception handler 처리 RestController @RequestMapping("/test") @RestController public class TestController { @GetMapping(value = "/t1") public Map t1( @Validated ReqVo req) { Request Param VO import lombok.Data; import javax.validation.constraints.NotNull; @Data public class ReqVo{ /** * 필수코드 @NotNull 선언 */ @NotNull String code_type; Exception..

springboot restcontroller requestparam 설정 @GetMapping(value = "/test") public Map accounts( @RequestParam(value = "code") String code, @RequestParam(value = "page" , required = false, defaultValue = "0") int page, @RequestParam Map req) throws Exception { @RequestParam 필수값 exception handler 잘못된 예 @ControllerAdvice @RestController public class ResponseExceptionHandler extends ResponseEntityExcept..

1. git hub에서 repository 추가 New > Create a new repository 에서 Repository name 추가 후 'Create repository' 버튼 클릭 2. IntelliJ Project 생성 Welcome to IntelliJ IDEA > New Project (기본 : Spring , Gradle, log4j, jpa, mysql 연동) 좌측 Spring Initializr 클릭 > - Name : project 명 (편하게 repository 명과 동일) - Location 지정 : ~/path/project 명 - Type : Gradle-Groovy - Group : com.test.api (package명) - Artifact: project 명 - Pa..

-- gradle build error A problem occurred configuring root project 'test-project'. > Could not resolve all files for configuration ':classpath'. > Could not resolve org.springframework.boot:spring-boot-gradle-plugin:3.0.2. Required by: project : > org.springframework.boot:org.springframework.boot.gradle.plugin:3.0.2 -- gralde sync Gradle sync failed: No matching variant of org.springframework.boo..

서버 jar로 띄울 때 FileNotFoundException 에러 java -jar xxxxxx.jar -- exception cannot be resolved to absolute file path because it does not reside in the file system: jar: -- 원래 소스 (오류 발생) pom.xml file-path: classpath:xml/ -- java @Autowired private ResourceLoader resourceLoader; @Value("${file-path:''}") private String filePath; void reader() { resourceLoader.getResource(filePath + "test.xml").getFile..

tar xvfz prometheus-*.tar.gz cd prometheus-* ./prometheus -bash: ./prometheus: cannot execute binary file OS에 맞는 버전을 재 설치 https://prometheus.io/download/ Download | Prometheus An open-source monitoring system with a dimensional data model, flexible query language, efficient time series database and modern alerting approach. prometheus.io Mac에서 linux 파일을 다운로드 받아서 실행 했더니, 에러 발생

spring-boot-starter-actuator 의존성 주입 org.springframework.boot spring-boot-starter-actuator 서버 실행 IllegalArgumentException: Value must only contain valid chars application.yml management: endpoints: web: base-path: /tr exposure: include: info management.endpoints.web.exposure.include 확인

$ sudo date 2022. 08. 11. (목) 06:06:06 UTC $ sudo cat /etc/localtime TZif2UTCTZif2?UTC UTC0 -- 기존시간 삭제 $ sudo rm /etc/localtime -- 서울시간 등록 $ sudo ln -s /usr/share/zoneinfo/Asia/Seoul /etc/localtime -- 시간 확인 $ date 2022. 08. 11. (목) 15:11:01 KST

[CodeDeploy error] : ApplicationStop : [error] CodeDeploy agent was not able to receive the lifecycle event. Check the CodeDeploy agent logs on your host and make sure the agent is running and can connect to the CodeDeploy server. + 배포되는 서버에 CodeDeploy 에이전트가 실행 중인 지 확인 $ sudo service codedeploy-agent status (비정상) Redirecting to /bin/systemctl status codedeploy-agent.service (정상) The AWS CodeDepl..