본문 바로가기

2020/07

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.. 더보기
쿼리 SELECT A.* , CASE WHEN A.COMMENTS IS NOT NULL THEN CHR(10) || '/* ' || LPAD(A.COLUMN_ID, 3, ' ') || '. ' || A.COMMENTS || ' */' || CHR(10) END || 'private ' || RPAD(A.VO_VAR_TYPE, 8, ' ') || A.VO_VAR_NAME || ';' AS VO_VAR , CASE WHEN A.COLUMN_ID = 1 AND 'MULTILINE' = 'MULTILINE1' THEN CHR(10) || 'SELECT' || CHR(10) || LPAD(' ', 8, ' ') WHEN A.COLUMN_ID = 1 THEN CHR(10) || 'SELECT' || LPAD(' ', 2.. 더보기
SHA-512 인코딩 package info.rue.app.common.util; import java.math.BigInteger; import java.security.MessageDigest; import java.security.NoSuchAlgorithmException; import java.security.SecureRandom; import org.springframework.stereotype.Component; import lombok.extern.slf4j.Slf4j; @Slf4j @Component public class CommonPasswordUtil { private final byte[] PREFIX_SALT_PASSWORD = { 0 , 22 , 67 , 3 , -88 , 27 , -89 , -.. 더보기
spring-datasource.xml 더보기
common-local.properties jdbc.connectionFactoryClassName=oracle.jdbc.pool.OracleDataSource jdbc.URL=jdbc:oracle:thin:@db202006191235_medium?TNS_ADMIN=D:\20.Dev\sqldeveloper-19.2.1.247.2212-x64\Wallet_DB202006191235 jdbc.user=dfdsefs jdbc.password=dfesfefgs dbc.initialPoolSize=5 jdbc.maxPoolSize=10 더보기
applicationContext.xml 더보기
pom.xml 4.0.0 info.rue rueWeb 0.0.1-SNAPSHOT war rueWeb rueWeb Project UTF-8 1.8 5.2.7.RELEASE 5.3.3.RELEASE 1.9.5 18.3.0.0 2.0.5 3.5.5 3.3.0 3.1.0 1.18.12 1.2.3 0.1.5 1.7.30 3.0.11.RELEASE 2.11.1 4.13 ${java.version} ${java.version} org.springframework spring-webmvc ${spring.version} org.springframework.security spring-security-web ${spring-security.version} org.springframework.security spring-security.. 더보기

티스토리툴바