db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Truncating CLOB error
Date Thu, 06 May 2010 10:42:02 GMT
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



Mime
View raw message