Method for writing
import java.sql *;. import org.springframework.jdbc.core *;. import org.springframework.jdbc.core.support AbstractLobCreatingPreparedStatementCallback;. import org.springframework.jdbc.support.lob.LobCreator; import org.springframework.jdbc .support.lob.LobHandler; import org.springframework.jdbc.support.lob *;. import org.springframework.jdbc.support.nativejdbc *;. public void storeMessateContent (jdbcTemplate jdbcTemplate, String msg) throws
Sqlexception {
String SQL = "INSERT INTO TEST (Content)
VALUES (?) ";
Try {
Oraclelobhandler Handler = new oraclelobhandler ();
Handler.setnativejdbcextractor (New WebLogicNativeJDbcextractor ());
This.lobhandler = (lobhandler) Handler;
JDBCTemplate.execute (SQL,
New AbstractLobcreatingPrepReparedStatementCallback (this.
Lobhandler) {
Protected Void SetValues (PREPAREDSTATEMENT PS, LOBCREATOR LOBCREATOR) THROWS
Sqlexception {
Lobcreator.setClobasstring (PS, 1, MSG); // Set the content of the detailed clob field
}
}
);
}
Catch (Exception EX) {
Throw new sqlexception
"Update Clob Type Column [Content] Error!");
}
}
Program test environment: Welogic812 Springframework1.1 Oracle9i
