Hi Tobias, there's a little utility class that can help you with that
https://fisheye6.atlassian.com/browse/activemq/trunk/activemq-core/src/main/java/org/apache/activemq/util/GenerateJDBCStatements.java?r=HEAD but generally, it's better to create it on the dev db and then dump ddls you need Cheers -- Dejan Bosanac - http://twitter.com/dejanb Open Source Integration - http://fusesource.com/ ActiveMQ in Action - http://www.manning.com/snyder/ Blog - http://www.nighttale.net On Wed, Sep 29, 2010 at 1:40 PM, Tobias Trelle <tobias.tre...@codecentric.de> wrote: > > > Gary Tully wrote: >> >> ActiveMQ will create all the relevant tables automatically at startup. >> > > In case the ActiveMQ db user does not have the permission to create tables > (what most db admins will prefer), is there a DDL script (or at least a > table description) that creates the tables in advance? Depending on the size > of the messages, it might be important to set table spaces etc. > > TIA, > Tobias > > -- > View this message in context: > http://activemq.2283324.n4.nabble.com/How-to-store-everything-in-DB-tp2531110p2718802.html > Sent from the ActiveMQ - User mailing list archive at Nabble.com. >
