전체 글
byte[] dd = java.util.Base64.getDecoder().decode(encodedString);→ byte[] dd = java.util.Base64.getMimeDecoder().decode(encodedString.replaceAll("\\r\\n|\\r|\\n",""); API에 보면 Returns 값이 다름static Base64.Decoder getDecoder()Returns a Base64.Decoder that decodes using the Basic type base64 encoding scheme.static Base64.Decoder getMimeDecoder()Returns a Base64.Decoder that decodes using the MIM..
logback - DriverSpy Spring 3 부터는 기본으로 logback 사용 (log4j X) 환경 : Spring boot 3 / gradle / oracle 참고 : https://earth-95.tistory.com/41#Logback%EC%25-D%25B-%EB%25-E%25--%25-F 변경파일 build.gradle application.yml logback-spring.xml (추가) log4jdbc.log4j2.properties build.gradle # 의존성 추가 implementation 'org.bgee.log4jdbc-log4j2:log4jdbc-log4j2-jdbc4.1:1.16' /* Log4JDBC */ log4jdbc.log4j2.propertie..
/* ServiceImpl */ regMap.put("p_in1","값1"); regMap.put("p_in2","값1"); regMap.put("p_out1",""); regMap.put("p_out2",""); regMap.put("p_out3",""); VO.명칭(regMap) /* xml */ call 패키지명.프로시저명 ( #{p_in1}, #{p_in2}, #{p_out1, mode=OUT, jdbcType=VARCHAR}, #{p_out2, mode=OUT, jdbcType=VARCHAR}, #{p_out3, mode=OUT, jdbcType=VARCHAR} ) /* ServiceImpl */ regMap.put("p_in1","값1"); regMap.put("p_in2","값1"); reg..
/* 배치로 돌릴 프로시저 이므로 당연히 IN 변수가 없다 */ DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( JOB => X ,WHAT => ' declare v_result varchar2(1000); v_err_code number; v_err_mgs varchar2(1000); begin 패키지명.프로시저명(v_result, v_err_code, v_err_mgs); endl;' ,NEXT_DATE => SYSDATE + 1/24/60 -- 1분 후 부터 시작 ,INTERVAL => 'TRUNC(SYSDATE)+1+1/24' ,NO_PARSE => TRUE ); END; /* 생성 확인 */ SELECT * FROM USER_JOBS..