Hi Bruce, Thanks a lot. It works now.
Have a nice day. bsnyder wrote: > > On 8/22/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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)[EMAIL PROTECTED]&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.
