JBoss A-MQ ActiveMQ, JDBCPersistence : How to add additional sql to db schema creation?

Solution Verified - Updated -

Issue

  • Where is the SQL statements defined for creating the DB schema for the JDBC Persistence adatper?
  • How do we disable database table creation on startup within JBoss A-MQ?
  • How do we create the JBoss A-MQ database schema objects manually?
  • We are planning to use Database for creating the AMQ message persistance. After googling we found the following tables have to be created- ACTIVEMQ_MSGS,ACTIVEMQ_ACKS,
    ACTIVEMQ_LOCK. Could you provide us the DDL for creating the tables so that i can pass it our DBA?
  • How can we stop AMQ to automatically creating the schema tables?

Environment

  • JBoss A-MQ
    • 6.0
    • 6.1.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.