How to insert clob data??


How to insert clob data??

Can any one tell me in details how to populate clob column in a table using sql??I tried simple sql statements but found out that simple sql statements won't allow more than 4000 characters but I need to insert more than 4000 characters.I have heard that clob fields can hold 4 gb of data and need pl/sql to avail that feature.Can any one tell me how to create pl/sql blocks and statements.I want to insert value of a textarea into clob column of a table.So please some one tell me what should I do??

View Answers

April 12, 2012 at 1:50 PM

No it is not the way I actually want.I need the pl/sql code.Actually I am fetching the data from a form page.I can't use a file to fetch the data.All I need is to get the data from text area and then insert the data into table through pl/sql code.

April 12, 2012 at 12:52 PM

In MySql database,TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT can be taken as CLOB type. Here we have used longtext datatype.

1)create a table article in database.

              CREATE TABLE `article` (                 
               `ID` int(11) NOT NULL auto_increment,  
               `Subject` varchar(256) NOT NULL,       
               `Body` longtext,                       
               PRIMARY KEY  (`ID`)                    

2)Here is the java code:

import java.sql.*;
class  InsertClobData
    public static void main(String[] args){
        Connection con = null;

  String fileName = "c:/data.dat";
  try {
  con =DriverManager.getConnection ("jdbc:mysql://localhost:3306/test", "root", "root");
  String clobData = getClobDataAsString(fileName);
  PreparedStatement ps = con.prepareStatement("insert into article(subject, body)values (?, ?)");
  ps.setString(1, fileName);
  ps.setString(2, clobData);
  System.out.println("Clob data is instered successfully");
  catch (Exception e) {

  public static String getClobDataAsString(String filename) throws Exception {
    InputStream is = null;
    try {
      is = new FileInputStream(filename);
      int BUFFER_SIZE = 1024;
      ByteArrayOutputStream output = new ByteArrayOutputStream();
      int length;
      byte[] buffer = new byte[BUFFER_SIZE];
      while ((length = != -1) {
        output.write(buffer, 0, length);
      return new String(output.toByteArray());
    } finally {


Related Tutorials/Questions & Answers:
How to insert clob data??
Servlet Example To Insert Mysql Clob Data
How to update clob??
How to save excel sheet into mysql database using blob or clob
Problem in inserting clob data in jsp
Inserting Mysql CLOB data using Servlet
how to insert image into server
how to insert check box
How to insert rows in jTable?
DB Insert
how to insert a summary values in grid
How to insert data into MySQL Table?
How to insert a car in the picture, insert a car in the picture, insert a car
how to insert value in dynamic table
how to insert excel file into mysql datbase in servlet
how to insert values from jsp into ms access
how to insert one table to anothere table
Servlet Example To Update Mysql Clob Data
how to insert data from netbeans into databse
To insert maximum number of data in database.
Deleting Mysql Clob data using servlet
how to insert the physical path of an image in database - JDBC
CLOB example - JDBC
how to insert date&time coloumn value in mssql - JDBC
how to insert the selected item of combobox in mysql - XML
how to insert data into database using jsp & retrive
how to insert checkbox value into database using jsp
how to insert, retrieve data from,to db(code)....
how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp
how to insert, retrieve data from,to db(code)....