Hi
some simple questions that could address the issue ( I am not familiar with that calendar system ) : are you using some ORM ? Did you check the table ? ( the size of the CLOB )

Marco

On Thu, May 6, 2010 at 12:42 PM, Mark Thornton <mthornton@optrak.co.uk> wrote:
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





--
"No Im sorrys, no apologies, no regrets..... "