org.hibernate.Session session = org.trundle.cms.db.HibernateUtil.getNewSession();
        org.hibernate.Transaction t = session.beginTransaction();
        org.trundle.cms.po.Clob po = new org.trundle.cms.po.Clob();
        po.setClob(MyExample.readFile());[b][color=blue]//file length is 1115 byte[/color][/b]
        session.save(po);
        session.flush();
        t.commit();
        session.close();

org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update

   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)

   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)

   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)

   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)

   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)

   at org.trundle.test.ClobManipulationIn10g.main(ClobManipulationIn10g.java:228)

[color=red]Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column[/color]


   at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)

   at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10698)

   at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)

   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)

   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)

   ... 6 more

    public void insertClob() throws SQLException {
            // Create a PreparedStatement object.
        PreparedStatement pstmt = null;
        try {
            // Create the database connection, if it is closed.
            if ((conn == null) || conn.isClosed()) {
                // Connect to the database.
                 //conn = DriverManager.getConnection(this.url, this.props);
                 conn = org.trundle.cms.db.HibernateUtil.currentSession().connection();
            }
            // Create SQL query to insert data into the CLOB column in the database.
            String sql = "INSERT INTO clob_tab(ID,CLOB_COL) VALUES(?,?)";
            // Read a big file(larger than 32765 bytes)
            String str = this.readFile();
            // Create the OraclePreparedStatement object
            pstmt = conn.prepareStatement(sql);
            // Use the same setString() method which is enhanced to insert
            // the CLOB data. The string data is automatically transformed into a
            // clob and inserted into the database column. Make sure that the
            // Connection property - 'SetBigStringTryClob' is set to true for
            // the insert to happen.
            pstmt.setString(1,System.currentTimeMillis()+"");
             pstmt.setString(2,str);
            // Execute the PreparedStatement
            conn.setAutoCommit(true);
            pstmt.execute();
           
        } catch (SQLException sqlex) {
            sqlex.printStackTrace();
            // Catch Exceptions and display messages accordingly.
            System.out.println("SQLException while connecting and inserting into " + "the database table: " + sqlex.toString());
        } catch (Exception ex) {System.out.println("Exception while connecting and inserting into the" + " database table: " +
                ex.toString());
        } finally { // Close the Statement and the connection objects.
            if (pstmt != null) {
                pstmt.close();
            }
            if (conn != null) {
                conn.close();
            }
        }
    }