'분류 전체보기' 카테고리의 글 목록 (25 Page)

분류 전체보기

별표시 되는 암호 필드 값 조회 프로그램 2011.02.17
AIX 5.3 OPENSSH INSTALL 2011.02.16
TCO Stream 제거 2011.02.16
부동산 임대차 계약서 모음 2011.02.08
파일 또는 폴더의 락 풀기"Unlocker Portable" v1.9.0 포터블 2011.02.08
던파 불법 프로그램 목록 2011.01.22
org.apache.catalina.session.StoreBase processExpires 2011.01.21
JEUSMain.xml Datasource 암호 설정 2011.01.13
퇴직 연금 2011.01.11
CLOB 파일 다루기 예제 2011.01.11

별표시 되는 암호 필드 값 조회 프로그램

하이주니 2011. 2. 17. 14:08

2011. 2. 17. 14:08

포터블도 시간나면 만들어야지... 하하하...

snadboys-revelation-2-0.zip

저작자표시 (새창열림)

'UTILITY' 카테고리의 다른 글

파수 관련 autoit 작성 코드 (0)	2011.03.10
비스타 관리자 권한 실행 파일 만드는 프로그램 (0)	2011.03.10
TCO Stream 제거 (0)	2011.02.16
파일 또는 폴더의 락 풀기"Unlocker Portable" v1.9.0 포터블 (0)	2011.02.08
VI 완전 정복하기 (1)	2011.01.06

AIX 5.3 OPENSSH INSTALL

하이주니 2011. 2. 16. 14:46

2011. 2. 16. 14:46

설치 필요파일

1. zlib

zlib-1.2.3-4.aix5.2.ppc.rpm

http://www.gzip.org/zlib/

2. openssl
http://www.openssl.org/

openssl.0.9.8.1104.tar

Readme.0.9.8.1104.txt

3. openssh

openssh_5.4p1.tar

http://sourceforge.net/projects/openssh-aix/

저작자표시 (새창열림)

'OS > AIX' 카테고리의 다른 글

IBM JVM -Xloratio 옵션 (0)	2011.03.03
날짜 관련 얻기 (0)	2011.03.02
bff 파일 설치 (AIX) (0)	2010.12.08
IBM AIX 용 JAVA 다운로드 주소 (0)	2010.12.07
AIX 5.3에서 Tomcat 설치 및 기본 홈 디렉토리 변경 (1)	2010.12.07

TCO Stream 제거

하이주니 2011. 2. 16. 09:33

2011. 2. 16. 09:33

* 참고 : TCO! stream 이란?
서버에서 클라이언트를 감시하는 원격관리 프로그램임.

- 제품종류 : 자산관리 / 제조업체 : MediaLand
- TCO! Stream : 미디어랜드에서 공급하는 TCO! Stream은 원격제어 소프트웨어라기 보다는 복합적인 성격을 지닌 소프트웨어다 이 소프트웨어는 TCO! Remocon이라고 불리우는 기능을 통해 상대 PC를 원격 제어할 수 있다. 클라이언트 PC를 시물레이션하여 모든 기능 제어가 가능하며, 한화면에서 다수의 원격지 PC를 제어 가능하다. 원격지 PC 연결은 기본적으로 TCP/IP 기반에서 동작되며, RAS를 통한 전화접속 사용자(PPP)를 지원한다...
___________________________

2004-09-14 21:51:10 / 백천기
TCO! stream Client Agent 라는 감시 프로그램을 지우고 싶은데 지워지지가 않습니다. 설령 지운다해도 Server에서 원격으로 다시 설치하더군요..

출처 : http://blog.paran.com/blog/detail/postBoard.kth?pmcId=birdfree&blogDataId=28250591

trcclient_uninstall.rar

저작자표시 (새창열림)

'UTILITY' 카테고리의 다른 글

비스타 관리자 권한 실행 파일 만드는 프로그램 (0)	2011.03.10
별표시 되는 암호 필드 값 조회 프로그램 (0)	2011.02.17
파일 또는 폴더의 락 풀기"Unlocker Portable" v1.9.0 포터블 (0)	2011.02.08
VI 완전 정복하기 (1)	2011.01.06
vmplayer 3.1.1 개인용 (1)	2010.12.10

부동산 임대차 계약서 모음

하이주니 2011. 2. 8. 16:17

2011. 2. 8. 16:17

하앍...

인터넷에서 마구 다운로드...

어디서 했는지 기억도 안남....

파일 또는 폴더의 락 풀기"Unlocker Portable" v1.9.0 포터블

하이주니 2011. 2. 8. 09:02

2011. 2. 8. 09:02

unlocker1.9.0-portable.zip

포터블이라...

32 or 64 비트 맞춰서 쓰면 됨....

2003/xp/vista/Windows 7 지원

사용법 ~

1. x86이든 폴더에 들어가서 Unlocker.exe 실행

2. 삭제 안되는 파일이나 폴더를 지정함

3. 왼쪽 아래의 드래그 목록에서 delete 를 선택하고 unlock all 등을 선택하면
권한 풀고 삭제가 이루어짐
만약 안된다면 리부팅 한번 하면 됨...

저작자표시 (새창열림)

'UTILITY' 카테고리의 다른 글

별표시 되는 암호 필드 값 조회 프로그램 (0)	2011.02.17
TCO Stream 제거 (0)	2011.02.16
VI 완전 정복하기 (1)	2011.01.06
vmplayer 3.1.1 개인용 (1)	2010.12.10
VMWARE 속도 튜닝 하기 (1)	2010.12.07

던파 불법 프로그램 목록

하이주니 2011. 1. 22. 20:02

2011. 1. 22. 20:02

- 프록시 프로그램 : CCProxy, Proxifier, easy2game, etc.

- 프로세스 숨김 프로그램 : HideToolz, etc.

- 디버거 : ollydbg, Windbg, Syser Debugger, etc.

- 디스어셈블러 : IDA, etc.

- 패킷 변조 프로그램 : WPE, rEdox Packet Editor, etc.

- 메모리 변조 프로그램 : Cheat Engine 류

- 키보드조작 : GlobePIE, PPJoy, etc.

(특정 장치를 이용하여 여러 컴퓨터를 동시에 조작하는 경우도 포함됩니다

저작자표시 (새창열림)

'Game > 던전앤파이터' 카테고리의 다른 글

던파 5월 18일 기준 광렙업 루트 (0)	2015.06.24
던파 광렙업 루트 (4)	2014.12.23
던파 빠른 렙업 사냥터 추천 (0)	2011.01.05
던전앤 파이터 투 계정 돌리기 (0)	2010.12.16
마도학자 스킬트리 (0)	2010.12.09

org.apache.catalina.session.StoreBase processExpires

하이주니 2011. 1. 21. 16:32

2011. 1. 21. 16:32

금일..

이클립스 상에서 apache 5.5를 실행하던중

다음과 같은 오류 발생

org.apache.catalina.session.StoreBase processExpires

심각 : java.io.EOFException

...

원인

JDK 1.4에서 발생하며

이파일은 톰켓이 시작 정보 백업을 위해 만드는 것인데, 아마도 시작 정보 만들때 뭔가 문제가 생겨서 그런듯...

결론 !

이클립스 종료 ->

<dotcms home>\work\Catalina\localhost\_\SESSIONS.ser

삭제

이클립스 시작

근데.. 플러그인 형태로 설치한 난.. tldCache.ser 로 검색하니 금일 날짜로 나왔슴...

삭제하고 재시작하니 깔끔하고 상쾌한 기분 ~

저작자표시 (새창열림)

'UTILITY > Eclipse' 카테고리의 다른 글

이클립스에서 Visual VM 사용하기 (0)	2011.10.12
DOMParser cannot be resolved to a type (0)	2011.03.28
ActiveXObject cannot be resolved to a type (0)	2011.03.28
RSE (Remote System Explorer) 설치하기 (0)	2010.07.14
이클립스 오라클 플러그인 (0)	2010.07.05

JEUSMain.xml Datasource 암호 설정

하이주니 2011. 1. 13. 15:44

2011. 1. 13. 15:44

가이드에는 <database> 안에 <encryption>암호..</encryption> 으로 지정되어 있으나...

제길슨...

안먹어... jeus5는 모르는 child 원소란다 -_-ㅋ

아놔...

찾아보니

<password>tiger</password>

값이

base64일 경우
<password>{base64}dGlnZXI=</password>

형태로 변경적용 하면 된다.

특정 값을 암호화 하는 방법은

jeus 계정으로

$> encryption base64 tiger

하면
[base64] : [tiger] --> [encode:dGlnZXI=]
[base64] : [dGlnZXI=] --> [decode:tiger]

적용가능한 암호화 알고리즘

- base64
많이 쓰이나 암호화와 복호화가 쉬움.
   또한 복호화 툴이 많이... 2초면 복호화..

- SHA
해쉬 암호화 방식 (중간 유추가 안되고)
   입력 A -> 해쉬함수 -> XADDD (값이라면)
   비교시 값을 입력받아 똑같이 해쉬 결과값을 비교하는 방식 비교적 안전

- DES
- DESede
- AES
- SEED
- Blowfish

저작자표시 (새창열림)

'WAS > JEUS' 카테고리의 다른 글

제우스에서 log4sql 사용하기 (0)	2011.03.15
JEUS 5 세션 공유 (0)	2011.03.09
IBM JVM 튜닝 - 3 (0)	2009.08.24
제우스 환경 설정 부분 (0)	2009.03.05
JAVA HEAPDUMP 분석방법 (0)	2009.03.05

퇴직 연금

하이주니 2011. 1. 11. 17:20

2011. 1. 11. 17:20

1. 미래에셋 퇴직플랜 아시아 퍼시픽 40 증권 자투자 신탁 1호(채권혼합)
2. 신영 퇴직연금 가치채권 증권 자투자 신탁 (채권혼합)
3. 미래에셋 퇴직연금 솔로몬 40 증권 자투자 신탁 1호 (채권혼합)

저작자표시 (새창열림)

'Private' 카테고리의 다른 글

OPENSSL 패스워드 변경 (0)	2011.10.20
존 더 리퍼 john-mmx (1)	2011.09.28
ssl crack (0)	2011.09.27
Aircrack-ng is an 802.11 WEP and WPA/WPA2-PSK key cracking program. (1)	2011.09.09
산모가 자신의 태반 먹는다? (0)	2010.02.27

CLOB 파일 다루기 예제

하이주니 2011. 1. 11. 08:58

2011. 1. 11. 08:58

출처(Reference) : http://www.javafaq.nu/java-example-code-141.html

// -----------------------------------------------------------------------------
// CLOBFileExample.java
// -----------------------------------------------------------------------------

/*
* =============================================================================
* Copyright (c) 1998-2005 Jeffrey M. Hunter. All rights reserved.
*
* All source code and material located at the Internet address of
* http://www.idevelopment.info is the copyright of Jeffrey M. Hunter, 2005 and
* is protected under copyright laws of the United States. This source code may
* not be hosted on any other site without my express, prior, written
* permission. Application to host any of the material elsewhere can be made by
* contacting me at jhunter@idevelopment.info.
*
* I have made every effort and taken great care in making sure that the source
* code and other content included on my web site is technically accurate, but I
* disclaim any and all responsibility for any loss, damage or destruction of
* data or any other property which may arise from relying on it. I will in no
* case be liable for any monetary damages arising from such loss, damage or
* destruction.
*
* As with any code, ensure to test this code in a development environment
* before attempting to run it in production.
* =============================================================================
*/

import java.sql.*;
import java.io.*;
import java.util.*;

// Needed since we will be using Oracle's CLOB, part of Oracle's JDBC extended
// classes. Keep in mind that we could have included Java's JDBC interfaces
// java.sql.Clob which Oracle does implement. The oracle.sql.CLOB class
// provided by Oracle does offer better performance and functionality.
import oracle.sql.*;

// Needed for Oracle JDBC Extended Classes
import oracle.jdbc.*;

/**
* -----------------------------------------------------------------------------
* Used to test the functionality of how to load and unload text data from an
* Oracle CLOB.
*
* This example uses an Oracle table with the following definition:
*
* CREATE TABLE test_clob (
* id NUMBER(15)
* , do*****ent_name VARCHAR2(1000)
* , xml_do*****ent CLOB
* , timestamp DATE
* );
* -----------------------------------------------------------------------------
* @version 1.0
* @author Jeffrey M. Hunter (jhunter@idevelopment.info)
* @author http://www.idevelopment.info
* -----------------------------------------------------------------------------
*/

public class CLOBFileExample {

private String inputTextFileName = null;
private File inputTextFile = null;

private String outputTextFileName1 = null;
private File outputTextFile1 = null;

private String outputTextFileName2 = null;
private File outputTextFile2 = null;

private String dbUser = "SCOTT";
private String dbPassword = "TIGER";
private Connection conn = null;

/**
* Default constructor used to create this object. Responsible for setting
* this object's creation date, as well as incrementing the number instances
* of this object.
* @param args Array of string arguments passed in from the command-line.
* @throws java.io.IOException
*/
public CLOBFileExample(String[] args) throws IOException {

inputTextFileName = args[0];
inputTextFile = new File(inputTextFileName);

if (!inputTextFile.exists()) {
throw new IOException("File not found. " + inputTextFileName);
}

outputTextFileName1 = inputTextFileName + ".getChars.out";
outputTextFileName2 = inputTextFileName + ".Streams.out";

}

/**
* Obtain a connection to the Oracle database.
* @throws java.sql.SQLException
*/
public void openOracleConnection()
throws SQLException
, IllegalAccessException
, InstantiationException
, ClassNotFoundException {

String driver_class = "oracle.jdbc.driver.OracleDriver";
String connectionURL = null;

try {
Class.forName (driver_class).newInstance();
connectionURL = "jdbc:oracle:thin:@melody:1521:JEFFDB";
conn = DriverManager.getConnection(connectionURL, dbUser, dbPassword);
conn.setAutoCommit(false);
System.out.println("Connected.\n");
} catch (IllegalAccessException e) {
System.out.println("Illegal Access Exception: (Open Connection).");
e.printStackTrace();
throw e;
} catch (InstantiationException e) {
System.out.println("Instantiation Exception: (Open Connection).");
e.printStackTrace();
throw e;
} catch (ClassNotFoundException e) {
System.out.println("Class Not Found Exception: (Open Connection).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Open Connection).");
e.printStackTrace();
throw e;
}

}

/**
* Close Oracle database connection.
* @throws java.sql.SQLException
*/
public void closeOracleConnection() throws SQLException {

try {
conn.close();
System.out.println("Disconnected.\n");
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Closing Connection).");
e.printStackTrace();
if (conn != null) {
try {
conn.rollback();
} catch (SQLException e2) {
System.out.println("Caught SQL (Rollback Failed) Exception.");
e2.printStackTrace();
}
}
throw e;
}

}

/**
* Method used to print program usage to the console.
*/
static public void usage() {
System.out.println("\nUsage: java CLOBFileExample \"Text File Name\"\n");
}

/**
* Validate command-line arguments to this program.
* @param args Array of string arguments passed in from the command-line.
* @return Boolean - value of true if correct arguments, false otherwise.
*/
static public boolean checkArguments(String[] args) {

if (args.length == 1) {
return true;
} else {
return false;
}

}

/**
* Override the Object toString method. Used to print a version of this
* object to the console.
* @return String - String to be returned by this object.
*/
public String toString() {

String retValue;

retValue = "Input File : " + inputTextFileName + "\n" +
"Output File (1) : " + outputTextFileName1 + "\n" +
"Output File (2) : " + outputTextFileName2 + "\n" +
"Database User : " + dbUser;
return retValue;

}

/**
* Method used to write text data contained in a file to an Oracle CLOB
* column. The method used to write the data to the CLOB uses the putChars()
* method. This is one of two types of methods used to write text data to
* a CLOB column. The other method uses Streams.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void writeCLOBPut()
throws IOException, SQLException {

FileInputStream inputFileInputStream = null;
InputStreamReader inputInputStreamReader = null;
BufferedReader inputBufferedReader = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
int chunkSize;
char[] textBuffer;
long position;
int charsRead = 0;
int charsWritten = 0;
int totCharsRead = 0;
int totCharsWritten = 0;

try {

stmt = conn.createStatement();

inputTextFile = new File(inputTextFileName);
inputFileInputStream = new FileInputStream(inputTextFile);
inputInputStreamReader = new InputStreamReader(inputFileInputStream);
inputBufferedReader = new BufferedReader(inputInputStreamReader);

sqlText =
"INSERT INTO test_clob (id, do*****ent_name, xml_do*****ent, timestamp) " +
" VALUES(1, '" + inputTextFile.getName() + "', EMPTY_CLOB(), SYSDATE)";
stmt.executeUpdate(sqlText);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 1 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

chunkSize = xmlDo*****ent.getChunkSize();
textBuffer = new char[chunkSize];

position = 1;
while ((charsRead = inputBufferedReader.read(textBuffer)) != -1) {
charsWritten = xmlDo*****ent.putChars(position, textBuffer, charsRead);
position += charsRead;
totCharsRead += charsRead;
totCharsWritten += charsWritten;
}

inputBufferedReader.close();
inputInputStreamReader.close();
inputFileInputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" PUT METHOD\n" +
"==========================================================\n" +
"Wrote file " + inputTextFile.getName() + " to CLOB column.\n" +
totCharsRead + " characters read.\n" +
totCharsWritten + " characters written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value - Put Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value - Put Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Method used to write the contents (data) from an Oracle CLOB column to
* an O/S file. This method uses one of two ways to get data from the CLOB
* column - namely the getChars() method. The other way to read data from an
* Oracle CLOB column is to use Streams.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void readCLOBToFileGet()
throws IOException, SQLException {

FileOutputStream outputFileOutputStream = null;
OutputStreamWriter outputOutputStreamWriter = null;
BufferedWriter outputBufferedWriter = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
long clobLength;
long position;
int chunkSize;
char[] textBuffer;
int charsRead = 0;
int charsWritten = 0;
int totCharsRead = 0;
int totCharsWritten = 0;

try {

stmt = conn.createStatement();

outputTextFile1 = new File(outputTextFileName1);
outputFileOutputStream = new FileOutputStream(outputTextFile1);
outputOutputStreamWriter = new OutputStreamWriter(outputFileOutputStream);
outputBufferedWriter = new BufferedWriter(outputOutputStreamWriter);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 1 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

clobLength = xmlDo*****ent.length();
chunkSize = xmlDo*****ent.getChunkSize();
textBuffer = new char[chunkSize];

for (position = 1; position <= clobLength; position += chunkSize) {

// Loop through while reading a chunk of data from the CLOB
// column using the getChars() method. This data will be stored
// in a temporary buffer that will be written to disk.
charsRead = xmlDo*****ent.getChars(position, chunkSize, textBuffer);

// Now write the buffer to disk.
outputBufferedWriter.write(textBuffer, 0, charsRead);

totCharsRead += charsRead;
totCharsWritten += charsRead;

}

outputBufferedWriter.close();
outputOutputStreamWriter.close();
outputFileOutputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" GET METHOD\n" +
"==========================================================\n" +
"Wrote CLOB column data to file " + outputTextFile1.getName() + ".\n" +
totCharsRead + " characters read.\n" +
totCharsWritten + " characters written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value to file - Get Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value to file - Get Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Method used to write text data contained in a file to an Oracle CLOB
* column. The method used to write the data to the CLOB uses Streams.
* This is one of two types of methods used to write text data to
* a CLOB column. The other method uses the putChars() method.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void writeCLOBStream()
throws IOException, SQLException {

FileInputStream inputFileInputStream = null;
OutputStream clobOutputStream = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
int bufferSize;
byte[] byteBuffer;
int bytesRead = 0;
int bytesWritten = 0;
int totBytesRead = 0;
int totBytesWritten = 0;

try {

stmt = conn.createStatement();

inputTextFile = new File(inputTextFileName);
inputFileInputStream = new FileInputStream(inputTextFile);

sqlText =
"INSERT INTO test_clob (id, do*****ent_name, xml_do*****ent, timestamp) " +
" VALUES(2, '" + inputTextFile.getName() + "', EMPTY_CLOB(), SYSDATE)";
stmt.executeUpdate(sqlText);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 2 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

bufferSize = xmlDo*****ent.getBufferSize();

// Notice that we are using an array of bytes as opposed to an array
// of characters. This is required since we will be streaming the
// content (to either a CLOB or BLOB) as a stream of bytes using
// using an OutputStream Object. This requires that a byte array to
// be used to temporarily store the contents that will be sent to
// the LOB. Note that they use of the byte array can be used even
// when reading contents from an ASCII text file that will be sent
// to a CLOB.
byteBuffer = new byte[bufferSize];

clobOutputStream = xmlDo*****ent.getAsciiOutputStream();

while ((bytesRead = inputFileInputStream.read(byteBuffer)) != -1) {

// After reading a buffer from the text file, write the contents
// of the buffer to the output stream using the write()
// method.
clobOutputStream.write(byteBuffer, 0, bytesRead);

totBytesRead += bytesRead;
totBytesWritten += bytesRead;

}

// Keep in mind that we still have the stream open. Once the stream
// gets open, you cannot perform any other database operations
// until that stream has been closed. This even includes a COMMIT
// statement. It is possible to loose data from the stream if this
// rule is not followed. If you were to attempt to put the COMMIT in
// place before closing the stream, Oracle will raise an
// "ORA-22990: LOB locators cannot span transactions" error.

inputFileInputStream.close();
clobOutputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" OUTPUT STREAMS METHOD\n" +
"==========================================================\n" +
"Wrote file " + inputTextFile.getName() + " to CLOB column.\n" +
totBytesRead + " bytes read.\n" +
totBytesWritten + " bytes written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value - Stream Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value - Stream Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Method used to write the contents (data) from an Oracle CLOB column to
* an O/S file. This method uses one of two ways to get data from the CLOB
* column - namely using Streams. The other way to read data from an
* Oracle CLOB column is to use getChars() method.
*
* @throws java.io.IOException
* @throws java.sql.SQLException
*/
public void readCLOBToFileStream()
throws IOException, SQLException {

FileOutputStream outputFileOutputStream = null;
InputStream clobInputStream = null;
String sqlText = null;
Statement stmt = null;
ResultSet rset = null;
CLOB xmlDo*****ent = null;
int chunkSize;
byte[] textBuffer;
int bytesRead = 0;
int bytesWritten = 0;
int totBytesRead = 0;
int totBytesWritten = 0;

try {

stmt = conn.createStatement();

outputTextFile2 = new File(outputTextFileName2);
outputFileOutputStream = new FileOutputStream(outputTextFile2);

sqlText =
"SELECT xml_do*****ent " +
"FROM test_clob " +
"WHERE id = 2 " +
"FOR UPDATE";
rset = stmt.executeQuery(sqlText);
rset.next();
xmlDo*****ent = ((OracleResultSet) rset).getCLOB("xml_do*****ent");

// Will use a Java InputStream object to read data from a CLOB (can
// also be used for a BLOB) object. In this example, we will use an
// InputStream to read ASCII characters from a CLOB.
clobInputStream = xmlDo*****ent.getAsciiStream();

chunkSize = xmlDo*****ent.getChunkSize();
textBuffer = new byte[chunkSize];

while ((bytesRead = clobInputStream.read(textBuffer)) != -1) {

// Loop through while reading a chunk of data from the CLOB
// column using an InputStream. This data will be stored
// in a temporary buffer that will be written to disk.
outputFileOutputStream.write(textBuffer, 0, bytesRead);

totBytesRead += bytesRead;
totBytesWritten += bytesRead;

}

outputFileOutputStream.close();
clobInputStream.close();

conn.commit();
rset.close();
stmt.close();

System.out.println(
"==========================================================\n" +
" INPUT STREAMS METHOD\n" +
"==========================================================\n" +
"Wrote CLOB column data to file " + outputTextFile2.getName() + ".\n" +
totBytesRead + " characters read.\n" +
totBytesWritten + " characters written.\n"
);

} catch (IOException e) {
System.out.println("Caught I/O Exception: (Write CLOB value to file - Streams Method).");
e.printStackTrace();
throw e;
} catch (SQLException e) {
System.out.println("Caught SQL Exception: (Write CLOB value to file - Streams Method).");
System.out.println("SQL:\n" + sqlText);
e.printStackTrace();
throw e;
}

}

/**
* Sole entry point to the class and application.
* @param args Array of string arguments passed in from the command-line.
*/
public static void main(String[] args) {

CLOBFileExample cLOBFileExample = null;

if (checkArguments(args)) {

try {

cLOBFileExample = new CLOBFileExample(args);

System.out.println("\n" + cLOBFileExample + "\n");

cLOBFileExample.openOracleConnection();

cLOBFileExample.writeCLOBPut();
cLOBFileExample.readCLOBToFileGet();

cLOBFileExample.writeCLOBStream();
cLOBFileExample.readCLOBToFileStream();

cLOBFileExample.closeOracleConnection();

} catch (IllegalAccessException e) {
System.out.println("Caught Illegal Accecss Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (InstantiationException e) {
System.out.println("Instantiation Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (ClassNotFoundException e) {
System.out.println("Class Not Found Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (SQLException e) {
System.out.println("Caught SQL Exception. Exiting.");
e.printStackTrace();
System.exit(1);
} catch (IOException e) {
System.out.println("Caught I/O Exception. Exiting.");
e.printStackTrace();
System.exit(1);
}

} else {
System.out.println("\nERROR: Invalid arguments.");
usage();
System.exit(1);
}

System.exit(0);
}

저작자표시 (새창열림)

'Language > JAVA' 카테고리의 다른 글

System.out.println()은 잊어라 log4sql이 온다. (0)	2011.03.15
Log for SQL (PL/SQL 개발환경에서 로그 정보 확인하기) (0)	2011.03.15
FILE을 CLOB에 INSERT하고, 반대로 컬럼을 읽어 FILE로 WRITE하는 JDBC PROGRAM 예제 (JDBC 8.1 이상 (0)	2011.01.07
Heap Dump 분석을 통한 Perm Area Memory Leak 원인 진단 (0)	2010.12.14
Java ARchives (JAR) (0)	2010.11.17

PREV 이전 1 ···22 23 24 25 26 27 28 ···67 NEXT 다음

웹 개발과 관련된 모든 것들