#####################################
#  DB에 JAVA Object 입력하기        # 
#####################################

작성자 : 장형화(hhjang97@venus.uos.ac.kr)
작성일 : 2005. 10. 11 
수정일 : 

원본 :
설명 :

Oracle DB에 자바를 객체 형태로 저장하기

Writing Advanced Applications
  Chpater 4:JDBC Technology 참조


create table lob_test( 
   id number(5),
   blob_col BLOB default EMPTY_BLOB()
);

################################# ################################# #################################

소스 다운로드

TestObject은 Serializable 해야 되고.. 
TestObject에 포함되는 객체도 Serializable 해야 된다.


public class TestObject implements Serializable 
{
	public int testid = 1234;
	public String testStr = "bbbb";
	public MyObject;		// MyObject 도 Serializable 해야됨
}


#################################
#  DB에 입력하기
#################################

	// TestObject 을 직렬화 한다.
	java.io.ByteArrayOutputStream bos = new java.io.ByteArrayOutputStream();
	java.io.ObjectOutputStream oos = new java.io.ObjectOutputStream(bos);
	oos.writeObject(testObject);
			
	byte[] bytes = bos.toByteArray();
	oos.close();
	bos.close();
			
	ByteArrayInputStream regArrayStream = 
					new ByteArrayInputStream(bytes);


	pstmt.setBinaryStream( 1, regArrayStream, bytes.length);


#################################
#  BLOB로 저장후 읽기
#################################
	// BLOB 읽기
	Blob blob = rs.getBlob("blob_col");

	ObjectInputStream regObjectStream =	new ObjectInputStream(blob.getBinaryStream());
	TestObject testObj = (TestObject)   regObjectStream.readObject();


#################################
# byte[] 로 저장후 읽기
#################################
	byte[] regBytes = rs.getBytes("blob_col");	// blob_col
	
	ByteArrayInputStream regArrayStream =	new ByteArrayInputStream(regBytes);
	ObjectInputStream regObjectStream =	new ObjectInputStream(regArrayStream);
	TestObject testObj = (TestObject)   regObjectStream.readObject();