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 <mthorn...@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..... "