i want to insert a clob type field into database,
and i have read the article"Using Clobs with Oracle and Hibernate 1.2";
and use the solution "mapping clob to string".
when i insert data to database,it's a error. the following is the error:
java.sql.SQLException: Io 异常: End of TNS data channel

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2150)

at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)

at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)

at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:514)

... 50 more

please help me.

i knew the question,when i inset data less than 4K,it is no problem,but when the data is large then 4K,has the question.
i change the mapping file,and use the text type,but the question still exist.
why?

I have no experience with inserting clobs via hibernate, but as you mention the 4K issue, I think a varchar2 column in Oracle is limited to 4000 characters.

Hope this might give a clue.

Jan