In my environment, I have topic sizes up to 5000 characters. This is because SonicMQ allows for the use of MULTITOPICS. ie... If you could like to publish to multiple topics, the topic name would be "TOPIC1|TOPIC2|TOPIC3..etc..."

If you could increase the size of the topic field, that would be great, thanks.

....

Is there a simple way for me to increase the maximum topic size in the message store. The current size limit is 256. Unfortunately I have topics which are larger than this (due to the use of MULTITOPICS in SonicMQ implementation).

Can I increase the size? or is this something that needs to fixed in the code?

java.sql.SQLException: A truncation error was encountered trying to shrink VARCHAR '.......' to length 256. Query: insert into stores values (?, ?, ?, ?) Parameters: [....]
at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:330)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:399)
at hermes.store.schema.DefaultJDBCAdapter.insert(DefaultJDBCAdapter.java:149)
at hermes.store.SingleUserMessageStore.store(SingleUserMessageStore.java:230)
at hermes.browser.tasks.RecordDestinationTask.invoke(RecordDestinationTask.java:85)
at hermes.browser.tasks.TaskSupport.run(TaskSupport.java:175)
at hermes.browser.tasks.ThreadPool.run(ThreadPool.java:170)
at java.lang.Thread.run(Thread.java:619)