db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marco Ferretti <marco.ferre...@gmail.com>
Subject Re: Truncating CLOB error
Date Thu, 06 May 2010 11:38:48 GMT
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..... "

Mime
View raw message