[jira] Commented: (AMQ-660) Add support for MaxDB

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (AMQ-660) Add support for MaxDB

JIRA jira@apache.org
    [ https://issues.apache.org/activemq/browse/AMQ-660?page=comments#action_35986 ]

Johan Hallgren commented on AMQ-660:
------------------------------------

Scratch the last question; I had missed to nest the statements elements properly. Doing this stopped the index from being auto-created:

 <persistenceAdapter>
      <journaledJDBC journalLogFiles="5" dataDirectory="../activemq-data" dataSource="#maxdb-ds">
        <statements>
          <statements deleteOldMessagesStatement="DELETE FROM ACTIVEMQ_MSGS WHERE &lt;&gt;? AND ID &lt;= (SELECT min(ACTIVEMQ_ACKS.LAST_ACKED_ID) FROM ACTIACTIVEMQ_ACKS WHERE ACTIVEMQ_ACKS.CONTAINER=ACTIVEMQ_MSGS.CONTAINER)">
            <createSchemaStatements />
          </statements>
        </statements>
      </journaledJDBC>
    </persistenceAdapter>

> Add support for MaxDB
> ---------------------
>
>          Key: AMQ-660
>          URL: https://issues.apache.org/activemq/browse/AMQ-660
>      Project: ActiveMQ
>         Type: New Feature

>   Components: Message Store
>     Reporter: Hiram Chirino
>     Assignee: Hiram Chirino
>      Fix For: 4.0 RC 2
>  Attachments: activemq.log, activemq.log
>
>
> Originaly reported on the user mailing list:
> http://www.nabble.com/Adding-support-for-MaxDB-in-ActiveMQ-JDBC-persistence-layer-t1334466.html#a3572564

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   https://issues.apache.org/activemq/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira