Uploaded image for project: 'JBoss A-MQ'
  1. JBoss A-MQ
  2. ENTMQ-2350

IBM DB2 11.1 setup workaround needed to define Adapter

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • JBoss AMQ 6.3 R16
    • JBoss A-MQ 6.3
    • jdbc
    • None

    Description

      This might not be needed. Waiting for PnT Ticket to be resolved first.

      There is a needed workaround for setting up JDBC adapter in activemq.xml in order to make connection work "out of the box".

      2019-08-12 14:22:24,956 | INFO  | AMQ-1-thread-1   | JDBCPersistenceAdapter           | tore.jdbc.JDBCPersistenceAdapter  478 | 162 - org.apache.activemq.activemq-osgi - 5.11.0.redhat-630403 | Database adapter driver override not found for : [microsoft_jdbc_driver_6_4_for_sql_server].  Will use default implementation.
      

      One has to perform following updates (commented out):

       <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>
      ...
      

      Attachments

        Issue Links

          Activity

            People

              gtully@redhat.com Gary Tully
              mtoth@redhat.com Michal Toth
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: