Caused by: org.apache.derby.client.am.SqlException: Java exception: 'A
truncatio
n error was encountered trying to shrink CLOB '<stream-value>' to length
255.: o
rg.apache.derby.iapi.services.io.DerbyIOException'.
I am getting this when a user adds an event with more than 255
characters using the Bedework calendar system. It is using Derby version
10.5.3.
Subsequently Derby fails with locking timeouts
Caused by: java.sql.SQLTransactionRollbackException: A lock could not be
obtaine
d within the time requested
at
org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unkn
own Source)
at
org.apache.derby.client.am.SqlException.getSQLException(Unknown Sourc
e)
at
org.apache.derby.client.am.PreparedStatement.executeQuery(Unknown Sou
rce)
Which I suspect is a consequence of the earlier problem
I found a more complete stack trace here:
org.apache.derby.client.am.SqlException: Java exception: 'A truncation
error was
encountered trying to shrink CLOB '<stream-value>' to length 255.:
org.apache.d
erby.iapi.services.io.DerbyIOException'.
at org.apache.derby.client.am.Statement.completeExecute(Unknown
Source)
at
org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unk
nown Source)
at
org.apache.derby.client.net.NetStatementReply.readExecute(Unknown Sou
rce)
at
org.apache.derby.client.net.StatementReply.readExecute(Unknown Source
)
at
org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
at
org.apache.derby.client.am.PreparedStatement.readExecute(Unknown Sour
ce)
at
org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Sour
ce)
at
org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown S
ource)
at
org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown So
urce)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdat
e(WrappedPreparedStatement.java:365)
Any suggestions welcome.
Mark Thornton
