본문 바로가기

전체 글

JOB 설정을 XML에서 할 때 MYBATIS MAPPER 설정 보호되어 있는 글입니다. 더보기
임시작업중 보호되어 있는 글입니다. 더보기
logback log4jdbc.log4j2.properties log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator log4jdbc.dump.sql.maxlinelength=0 org.bgee.log4jdbc-log4j2 log4jdbc-log4j2-jdbc4.1 1.16 ---------- batch ------- org.egovframe.rte org.egovframe.rte.bat.core ${org.egovframe.rte.version} log4j-core org.apache.logging.log4j log4j-slf4j-impl org.apache.logging.log4j log4j-over-slf4j org.slf4j co.. 더보기
샘플 SELECT * FROM DUSER.MY_NOTICE_MGMT A WHERE A.USER_ID = :USER_ID AND A.NOTICE_DATE >= :START_NOTICE_DATE AND A.NOTICE_DATE 더보기
알림 테이블 CREATE TABLE MY_NOTICE_MGMT ( USER_ID VARCHAR2(20) /* 사용자 ID / , NOTICE_SEQ NUMBER(10) / 알림 일련번호 / , NOTICE_KEY VARCHAR2(16) / 알림 고유 키 / , NOTICE_DATE VARCHAR2(8) / 알림 일자 / , NOTICE_TIME VARCHAR2(6) / 알림 시간 / , NOTICE_DTM DATE / 알림 일시 / , REPETITION_CD VARCHAR2(20) / 반복 코드 / , NOTICE_INTERVAL NUMBER(10) / 알림 주기 / , NOTICE_COUNT NUMBER(10) / 알림 횟수 / , NOTICE_CONTENT VARCHAR2(256) / 내용 / , SNS_SIT.. 더보기
쿼츠 테이블 스키마 오라클 -- -- A hint submitted by a user: Oracle DB MUST be created as "shared" and the -- job_queue_processes parameter must be greater than 2 -- However, these settings are pretty much standard after any -- Oracle install, so most users need not worry about this. -- -- Many other users (including the primary author of Quartz) have had success -- running in dedicated mode, so only consider the above as.. 더보기
spring boot - oracle cloud jdbc spring: datasource: url: jdbc:oracle:thin:@db202006191235_medium?TNS_ADMIN=전자지갑경로(D:/Wallet) username: username password: password driver-class-name: oracle.jdbc.pool.OracleDataSource oracle: ucp: minPoolSize: 5 maxPoolSize: 10 initalPoolSize: 5 더보기
Spring Session Table - ORACLE CREATE TABLE SPRING_SESSION ( PRIMARY_ID CHAR(36) NOT NULL, SESSION_ID CHAR(36) NOT NULL, CREATION_TIME NUMBER(19,0) NOT NULL, LAST_ACCESS_TIME NUMBER(19,0) NOT NULL, MAX_INACTIVE_INTERVAL NUMBER(10,0) NOT NULL, EXPIRY_TIME NUMBER(19,0) NOT NULL, PRINCIPAL_NAME VARCHAR2(100 CHAR), CONSTRAINT SPRING_SESSION_PK PRIMARY KEY (PRIMARY_ID) ); CREATE UNIQUE INDEX SPRING_SESSION_IX1 ON SPRING_SESSION (S.. 더보기
공통코드 DROP TABLE COMM_CD_GRP PURGE; CREATE TABLE COMM_CD_GRP ( CODE_GRP_ID VARCHAR2(20) , CODE_GRP_ID_NM VARCHAR2(128) , ETC1 VARCHAR2(128) , ETC2 VARCHAR2(128) , ETC3 VARCHAR2(128) , APPL_STRT_DTM DATE , APPL_END_DTM DATE , USE_YN VARCHAR2(2) , CRDT_USER_ID VARCHAR2(20) , CRDT_DTM DATE , UPDT_USER_ID VARCHAR2(20) , UPDT_DTM DATE , CONSTRAINT COMM_CD_PK PRIMARY KEY(CODE_GRP_ID) ); COMMENT ON TABLE COM.. 더보기
user DROP TABLE USER_INFO PURGE; CREATE TABLE USER_INFO ( USER_ID VARCHAR2(20) , USERNAME VARCHAR2(20) , NAME VARCHAR2(20) , PASSWORD VARCHAR2(256) , EMAIL VARCHAR2(64) , TEL_NO VARCHAR2(20) , HP_NO VARCHAR2(20) , USER_STATUS_CD VARCHAR2(2) , CRDT_USER_ID VARCHAR2(20) , CRDT_DTM DATE , UPDT_USER_ID VARCHAR2(20) , UPDT_DTM DATE , CONSTRAINT USER_INFO_PK PRIMARY KEY(USER_ID) ); CREATE INDEX USER_INFO_I.. 더보기