java clob内存溢出_java - Hibernate> CLOB> Oracle :( - 堆栈内存溢出

我试图写一个超过4000个字符的Oracle clob字段。 这种接缝是一个常见问题，但解决方案似乎不起作用。 所以我从这里祈求帮助。

肮脏的信息：

使用Oracle 9.2.0.8.0

Hibernate3使用注释实现pojo

Tomcat 6.0.16

Oracle 10.2.x驱动程序

C3P0连接池提供商

在我的persistence.xml中，我有：

org.hibernate.ejb.HibernatePersistence

getter和setter看起来像：

@Lob

@Column(name="COMMENT_DOC")

public String getDocument(){

return get("Document");

}

public void setDocument(String s){

put("Document",s);

}

我得到的例外是：

SEVERE: Servlet.service() for servlet SW threw exception

java.sql.SQLException: Io exception: Software caused connection abort: socket write error

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.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)

at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1999)

at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)

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

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

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

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

at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)

at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)

at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)

at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

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

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

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

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

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

at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:304)

at org.sw.website.actions.content.AddComment.performAction(AddComment.java:60)

...

如果我需要提供更多信息请求。 一切都有效，直到超过可怕的极限。