기본 콘텐츠로 건너뛰기

1월, 2014의 게시물 표시

keytool 사용법

keytool.exe -genkey -alias juheon -keyalg RSA -keypass 1234qwer -storepass 1234qwer -keystore juheon.jks  keytool.exe -export -alias juheon -storepass 1234qwer -file juheon.cer -keystore juheon.jks  keytool.exe -importkeystore -srckeystore juheon.jks -destkeystore juheon.key.p12 -deststoretype PKCS12  D:\Java\32bit\jdk1.5.0_22\jre\lib\security\cacert  D:\Java\32bit\jdk1.5.0_22\bin\keytool.exe -import -alias tsasample -keystore  D:\Java\32bit\jdk1.5.0_22\jre\lib\security\cacert -file D:\workspace\Servers\tsa-server-web-config\tomcat.cer  keytool -import -alias somansa -keystore C:\Program Files\Java\jdk1.8.0_102\jre\lib\security\cacert -file c:\somansa.cer #인증서 생성  keytool -genkey -alias keyAlias -keyalg RSA -keypass changeit -storepass changeit –validity 9999 -keystore keystore.jks  keytool -export -alias keyAlias -storepass changeit -file server.cer -keystore keystore.jks  keytool -import -v -trustcacerts -alias keyAlias -file server.cer -keystore cacerts.jks -keypass changeit

Oracle clob data insert 방법

1. 오라클 CLOB 객체의 createTemporary 함수를 이용하여 응용프로그램에서 처리 .... DBCPNativeJdbcExtractor jdbcExtractor = new DBCPNativeJdbcExtractor(); Connection conn = jdbcExtractor.doGetNativeConnection(ps.getConnection()); CLOB clob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION); clob.putChars(1, value.toCharArray()); ps.setClob(i, clob); .... 2. 오라클 쿼리 EMPTY_CLOB() 함수를 이용하여 쿼리에서 처리