Store CLOB data into database in Java
Description
The following code shows how to store CLOB data into database.
Example
/* ww w .ja v a 2 s . c o m*/
import java.io.File;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class Main {
private static String url = "jdbc:oracle:thin:@localhost:1521:xe";
private static String username = "yourDatabase";
private static String password = "welcome";
public static void main(String[] args) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(url, username, password);
conn.setAutoCommit(false);
String sql = "INSERT INTO documents (name, description, data) VALUES (?, ?, ?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, "a.txt");
stmt.setString(2, "b");
File data = new File("C:\\a.txt");
FileReader reader = new FileReader(data);
stmt.setCharacterStream(3, reader, (int) data.length());
stmt.execute();
conn.commit();
reader.close();
conn.close();
}
}