<bean class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" id="jdbc-ds">
    <property name="driverClassName" value="corg.apache.activemq.store.jdbc.adapter.DB2JDBCAdapter"/>
    <property name="url" value="jdbc:sqlserver://URL"/>
    <property name="username" value="username"/>
    <property name="password" value="password"/>
    <property name="maxActive" value="200"/>
    <property name="poolPreparedStatements" value="true"/>
  </bean>

<!--    <bean id="MSSQLAdapter" class="org.apache.activemq.store.jdbc.adapter.TransactJDBCAdapter"/> -->
<bean id="db2"
        class="org.apache.activemq.store.jdbc.adapter.DB2JDBCAdapter" />

  <broker xmlns="http://activemq.apache.org/schema/core" brokerName="${broker-name}" dataDirectory="${data}" restartAllowed="false" start="false">
    <persistenceAdapter>
      <jdbcPersistenceAdapter dataDirectory="${data}" dataSource="#jdbc-ds" adapter="#db2" />
    </persistenceAdapter>
...