All,
Since we have put some Clob datatype column in our project we have the error
below. We are using a quit important transaction with many Clob in columns.
Our Clob datas are not so important (Max = 6000 characters in the same
column).
It is quite weird. We are under Oracle 9i, OjbRc5. The connection reset
without any explanation..
One of our table script creation is :
CREATE TABLE DST_DESC (
DST_TABLE_PK VARCHAR(255) NOT NULL,
DST_ID_PK NUMBER NOT NULL, DST_CODE_LANG_PK VARCHAR(5) NOT NULL,
DST_DESC CLOB, DST_LABEL VARCHAR(255) NOT NULL,
CONSTRAINT pk_JWT_DST_DESC1 PRIMARY KEY
(DST_TABLE_PK,DST_ID_PK,DST_CODE_LANG_PK))
LOB("DST_DESC") STORE AS (DISABLE STORAGE IN ROW CACHE)
Any help would be appreciated.
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the insert (for a
com.jware.jwf.scf.jwt.jdo.JWT_too_tool): Exception d'E/S: Connection reset
Exception d'E/S: Connection reset
java.sql.SQLException: Exception d'E/S: Connection reset
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(OraclePreparedState
ment.java:608)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImp
l.java:236)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker
Impl.java:1384)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1301)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1261)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:171)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:171)
at
org.apache.ojb.odmg.states.StateNewDirty.commit(StateNewDirty.java:148)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(ObjectEnvelopeTab
le.java:241)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commit(ObjectEnvelopeTable.java:195)
at
org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(TransactionImpl.java:3
35)
at
org.apache.ojb.odmg.TransactionImpl.prepare(TransactionImpl.java:656)
at
org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:613)
at com.jware.jwf.scf.jwt.dbs.JWTDbs.importSite(JWTDbs.java:1207)
at
com.jware.jwf.jsi.InstallStarter.importConfig(InstallStarter.java:109)
at com.jware.jwf.jsi.InstallStarter.run(InstallStarter.java:73)
java.sql.SQLException: Exception d'E/S: Connection reset
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(OraclePreparedState
ment.java:608)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImp
l.java:236)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker
Impl.java:1384)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1301)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1261)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:171)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:171)
at
org.apache.ojb.odmg.states.StateNewDirty.commit(StateNewDirty.java:148)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(ObjectEnvelopeTab
le.java:241)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commit(ObjectEnvelopeTable.java:195)
at
org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(TransactionImpl.java:3
35)
at
org.apache.ojb.odmg.TransactionImpl.prepare(TransactionImpl.java:656)
at
org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:613)
at com.jware.jwf.scf.jwt.dbs.JWTDbs.importSite(JWTDbs.java:1207)
at
com.jware.jwf.jsi.InstallStarter.importConfig(InstallStarter.java:109)
at com.jware.jwf.jsi.InstallStarter.run(InstallStarter.java:73)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: Exception
d'E/S: Connection reset
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImp
l.java:265)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBroker
Impl.java:1384)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1301)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl
.java:1261)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:171)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(DelegatingPersi
stenceBroker.java:171)
at
org.apache.ojb.odmg.states.StateNewDirty.commit(StateNewDirty.java:148)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commitAllEnvelopes(ObjectEnvelopeTab
le.java:241)
at
org.apache.ojb.odmg.ObjectEnvelopeTable.commit(ObjectEnvelopeTable.java:195)
at
org.apache.ojb.odmg.TransactionImpl.doCommitOnObjects(TransactionImpl.java:3
35)
at
org.apache.ojb.odmg.TransactionImpl.prepare(TransactionImpl.java:656)
at
org.apache.ojb.odmg.TransactionImpl.commit(TransactionImpl.java:613)
at com.jware.jwf.scf.jwt.dbs.JWTDbs.importSite(JWTDbs.java:1207)
at
com.jware.jwf.jsi.InstallStarter.importConfig(InstallStarter.java:109)
at com.jware.jwf.jsi.InstallStarter.run(InstallStarter.java:73)
Caused by: java.sql.SQLException: Exception d'E/S: Connection reset
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(OraclePreparedState
ment.java:608)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImp
l.java:236)
... 15 more
[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR: Rollback
on the underlying connection failed
Exception d'E/S: Connection reset by peer: socket write error
[org.apache.ojb.broker.platforms.PlatformDefaultImpl] ERROR: Set
autoCommit(true) failed
Exception d'E/S: Connection reset by peer: socket write error
at
com.jware.jwf.scf.persistence.ojb.JwtTransactionImpl.commit(JwtTransactionIm
pl.java:138)
at com.jware.jwf.scf.jwt.dbs.JWTDbs.importSite(JWTDbs.java:1207)
at
com.jware.jwf.jsi.InstallStarter.importConfig(InstallStarter.java:109)
at com.jware.jwf.jsi.InstallStarter.run(InstallStarter.java:73)
