You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@activemq.apache.org by "tom@hostwebase.com" <to...@hostwebase.com> on 2007/08/22 20:10:33 UTC

A truncation error was encountered trying to shrink BLOB


Hi,

Let me explain my question more clearly. About the following error:

 ERROR 22001: A truncation error was encountered trying to shrink BLOB
'XX-RESOLVE-XX' to length 1048576. 

  Is there any way we can modify ActiveMQ or Derby database so that we don't
have data truncate problem ?

Thanks a lot.

-- 
View this message in context: http://www.nabble.com/Some-messages-get-lost.-tf4308194s2354.html#a12279969
Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.

Re: A truncation error was encountered trying to shrink BLOB

Posted by "tom@hostwebase.com" <to...@hostwebase.com>.
Hi Bruce,

Thanks a lot. It works now.

Have a nice day.


bsnyder wrote:
> 
> On 8/22/07, tom@hostwebase.com <to...@hostwebase.com> wrote:
>>
>>
>> Hi,
>>
>> Let me explain my question more clearly. About the following error:
>>
>>  ERROR 22001: A truncation error was encountered trying to shrink BLOB
>> 'XX-RESOLVE-XX' to length 1048576.
>>
>>   Is there any way we can modify ActiveMQ or Derby database so that we
>> don't
>> have data truncate problem ?
>>
>> Thanks a lot.
> 
> It would appear to me that the error indicates that the message size
> has exceeded the size limit of a BLOB field in Derby. The best thing
> to do is point ActiveMQ at a different database entirely, i.e.,
> substitute another database for Derby can handle a larger BLOB size
> such as MySQL or PostreSQL as Hiram suggested previously. There are
> some docs on this here:
> 
> http://activemq.apache.org/jdbc-support.html
> 
> The process of changing the ActiveMQ configuration is pretty simple
> because the default configuration in conf/activemq.xml provides data
> sources for both MySQL and PostgreSQL. All you have to do is uncomment
> the one you want and then refer to it by name in the
> persistenceAdapter element. There's even a commented out example of
> this as well, so just comment out the journaledJDBC element for Derby
> and uncomment the one for PostgreSQL. Then uncomment the PostreSQL
> datasource and point it to your local PostgreSQL database. Just make
> sure that the database is started up and accessible before starting
> ActiveMQ.
> 
> Bruce
> -- 
> perl -e 'print
> unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
> );'
> 
> Apache ActiveMQ - http://activemq.org/
> Apache ServiceMix - http://servicemix.org/
> Apache Geronimo - http://geronimo.apache.org/
> Castor - http://castor.org/
> 
> 

-- 
View this message in context: http://www.nabble.com/Some-messages-get-lost.-tf4308194s2354.html#a12282875
Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.

Re: A truncation error was encountered trying to shrink BLOB

Posted by Bruce Snyder <br...@gmail.com>.
On 8/22/07, tom@hostwebase.com <to...@hostwebase.com> wrote:
>
>
> Hi,
>
> Let me explain my question more clearly. About the following error:
>
>  ERROR 22001: A truncation error was encountered trying to shrink BLOB
> 'XX-RESOLVE-XX' to length 1048576.
>
>   Is there any way we can modify ActiveMQ or Derby database so that we don't
> have data truncate problem ?
>
> Thanks a lot.

It would appear to me that the error indicates that the message size
has exceeded the size limit of a BLOB field in Derby. The best thing
to do is point ActiveMQ at a different database entirely, i.e.,
substitute another database for Derby can handle a larger BLOB size
such as MySQL or PostreSQL as Hiram suggested previously. There are
some docs on this here:

http://activemq.apache.org/jdbc-support.html

The process of changing the ActiveMQ configuration is pretty simple
because the default configuration in conf/activemq.xml provides data
sources for both MySQL and PostgreSQL. All you have to do is uncomment
the one you want and then refer to it by name in the
persistenceAdapter element. There's even a commented out example of
this as well, so just comment out the journaledJDBC element for Derby
and uncomment the one for PostgreSQL. Then uncomment the PostreSQL
datasource and point it to your local PostgreSQL database. Just make
sure that the database is started up and accessible before starting
ActiveMQ.

Bruce
-- 
perl -e 'print unpack("u30","D0G)U8V4\@4VYY9&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'

Apache ActiveMQ - http://activemq.org/
Apache ServiceMix - http://servicemix.org/
Apache Geronimo - http://geronimo.apache.org/
Castor - http://castor.org/