/** * oracle의 CLOB을 이용하여 java의 Clob을 생성한다.
* @param clobValue
* @param conn
* @return
* @throws Exception */
public static Clob getClob( String clobValue, Connection conn)
throws Exception{
Clob newClob = null;
if(clobValue != null) {
try{
//env: resin pool connection
if (conn.getClass() == UserConnectionAdapter.class) {
newClob = oracle.sql.CLOB.createTemporary(
(UserConnectionAdapter) conn).getConnection()
,true
, oracle.sql.CLOB.DURATION_SESSION);
}
//env: oracle connection
else if (conn.getClass() == OracleConnection.class) {
newClob = oracle.sql.CLOB.createTemporary(
conn, true, oracle.sql.CLOB.DURATION_SESSION);
}
//env: jennifer connection
else if (conn.getClass() == Connection4Oracle.class) {
conn = ((Connection4Oracle)conn)
.getNativeConnection();
newClob = oracle.sql.CLOB.createTemporary(
((UserConnectionAdapter)conn)
.getConnection()
, true
, oracle.sql.CLOB.DURATION_SESSION);
}
//env: else connection
else {
newClob = oracle.sql.CLOB.createTemporary(
conn, true, oracle.sql.CLOB.DURATION_SESSION);
}
if(newClob! = null) {
((oracle.sql.CLOB)newClob)
.putString(1, clobValue);
}
} catch (Exception e){
e.printStackTrace();
}
}
return newClob;
}
getClob method를 사용하는 예제는 아래와 같다.
psmt.setClob(psmtIndex++, DaoHelper.getClob( info.getEtcInfo(), conn )); sp;
댓글 없음:
댓글 쓰기