import java.sql.*;
import java.util.*;
import java.io.*;import oracle.sql.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */public class TestClob {
    public static void main(String[] args) {
        try {
           Properties pro = new Properties();
           pro.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
           pro.put(Context.PROVIDER_URL, "t3://198.188.168.113:7001");           Context ctx = new InitialContext(pro);
           javax.sql.DataSource driver = (javax.sql.DataSource) ctx.lookup("newStarDB");
           Connection conn = driver.getConnection();
           System.out.println(conn);
           java.sql.PreparedStatement pstmt = null;
           ResultSet rs = null;
           String query = "";
           query =
               "update name set text=? where id = 1";
           pstmt = conn.prepareStatement(query);
           pstmt.setCharacterStream(1,new BufferedReader(new FileReader(new File("c:/read.txt"))), new FileInputStream("c:/read.txt").available());
           System.out.println("Buffer =========" + new BufferedReader(new FileReader(new File("c:/read.txt"))));
           BufferedReader bread = new  BufferedReader(new BufferedReader(new FileReader(new File("c:/read.txt"))));
           while(query!= null)
             {
                 System.out.println(query);
                 query = bread.readLine();
             }           pstmt.executeUpdate();           query =
                  "select text from name  where id = 1";
              pstmt = conn.prepareStatement(query);
              rs = pstmt.executeQuery();
              rs.next();
              Clob clob = rs.getClob(1);
              Reader read = clob.getCharacterStream();
               bread = new  BufferedReader(read);
              query = bread.readLine();
              while(query!= null)
              {
                  System.out.println(query);
                  query = bread.readLine();
              }       System.out.println("over");       }
       catch (Exception ep) {
           ep.printStackTrace();
       }    }}