WHY???

bugjiang · **Joined:** Fri Dec 19, 2003 5:27 am **Posts:** 5

I had a problem as following:
A coloumn , it's data type is varchar2(4000). The same value for this column, "insert" operation (session.inert(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)

cluck · **Joined:** Wed Dec 03, 2003 1:34 pm **Posts:** 9

Ehm...I'might be stating the obvious but:

Quote:

Data size bigger than max size for this type

would suggest that there is a property of your object which is > 4000 characters.

bugjiang · **Joined:** Fri Dec 19, 2003 5:27 am **Posts:** 5

Thanks. But why the insert operation is ok with the same value? And the length of this string is smaller than 4000, I'm sure of it.

emmanuel · **Posted:** Mon Dec 22, 2003 5:02 am

I've never played with Hibernate 1.x, but sounds like a JDBC dirver issue.
Can you try Hibernate 2.1.x

bugjiang · **Joined:** Fri Dec 19, 2003 5:27 am **Posts:** 5

Thanks 4 your help. I'll try it!
Merry Christmas!