import java.io.ByteArrayInputStream;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* @author http://java-sample-program.blogspot.in/
* Write CLOB to database
*/
public class ClobTest {
public static void main(String[] args) throws Exception{
Connection con = null;
CallableStatement stmt = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@IPAddress:Port:Database",
"username","password");
stmt = con.prepareCall("{call CLOBTEST.saveClob(?)}");
String xmlString = "1234567890";
stmt.setAsciiStream(1,new ByteArrayInputStream(xmlString.getBytes()),
xmlString.getBytes().length);
stmt.execute();
System.out.println("executed successfully");
}catch(Exception e){
e.printStackTrace();
} finally {
try{
if(stmt != null){
stmt.close();
}
if(con!= null){
con.close();
}
}catch (SQLException e) {
e.printStackTrace();
}
}
}
}
Thursday 21 March 2013
How to write CLOB fields
Below code shows the way to write CLOB fields to the database:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
/* */