I had a problem as following:
A coloumn , it's data type is varchar2(4000). The same value for this column, "insert" operation [session.insert(myObject)]is ok, but "update" [session.update(myObject)]operation failed, can any one tell me , this is why?

Exception info like this :
java.sql.SQLException: Data size bigger than max size for this type: 2285
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:147)
at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2461)
at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1155)
at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1572)
at weblogic.jdbc.pool.Statement.setString(Statement.java:445)
at weblogic.jdbc.rmi.internal.PreparedStatementImpl.setString(PreparedStatementImpl.java:162)
at weblogic.jdbc.rmi.SerialPreparedStatement.setString(SerialPreparedStatement.java:208)
at cirrus.hibernate.type.StringType.set(StringType.java:22)
at cirrus.hibernate.type.NullableType.nullSafeSet(NullableType.java:45)
at cirrus.hibernate.type.NullableType.nullSafeSet(NullableType.java:30)
at cirrus.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:395)
at cirrus.hibernate.persister.EntityPersister.update(EntityPersister.java:616)
at cirrus.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:27)
at cirrus.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:1683)
at cirrus.hibernate.impl.SessionImpl.execute(SessionImpl.java:1664)
at cirrus.hibernate.impl.SessionImpl.flush(SessionImpl.java:1608)

From the stacktrace it appears that you are using a dated version of Hibernate. What version is this?

Do you get the same problem with 2.1?

Justin

Yes, the version I used is 1.2.2. I have no test with the version 2.1.

Don't post several times.