Save This Page
Home » activemq-parent-5.3.1-source-release » org.apache » activemq » store » jdbc » adapter » [javadoc | source]
    1   /**
    2    * Licensed to the Apache Software Foundation (ASF) under one or more
    3    * contributor license agreements.  See the NOTICE file distributed with
    4    * this work for additional information regarding copyright ownership.
    5    * The ASF licenses this file to You under the Apache License, Version 2.0
    6    * (the "License"); you may not use this file except in compliance with
    7    * the License.  You may obtain a copy of the License at
    8    *
    9    *      http://www.apache.org/licenses/LICENSE-2.0
   10    *
   11    * Unless required by applicable law or agreed to in writing, software
   12    * distributed under the License is distributed on an "AS IS" BASIS,
   13    * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   14    * See the License for the specific language governing permissions and
   15    * limitations under the License.
   16    */
   17   package org.apache.activemq.store.jdbc.adapter;
   18   
   19   import org.apache.activemq.store.jdbc.Statements;
   20   
   21   /**
   22    * Axion specific Adapter.
   23    * 
   24    * Axion does not seem to support ALTER statements or sub-selects.  This means:
   25    * - We cannot auto upgrade the schema was we roll out new versions of ActiveMQ
   26    * - We cannot delete durable sub messages that have be acknowledged by all consumers.
   27    * 
   28    * @org.apache.xbean.XBean element="axionJDBCAdapter"
   29    * @version $Revision: 1.4 $
   30    */
   31   public class AxionJDBCAdapter extends StreamJDBCAdapter {
   32   
   33       public void setStatements(Statements statements) {
   34           
   35           String[] createStatements = new String[]{
   36               "CREATE TABLE " + statements.getFullMessageTableName() + "("
   37                   + "ID " + statements.getSequenceDataType() + " NOT NULL"
   38                   + ", CONTAINER " + statements.getContainerNameDataType()
   39                   + ", MSGID_PROD " + statements.getMsgIdDataType()
   40                   + ", MSGID_SEQ " + statements.getSequenceDataType()
   41                   + ", EXPIRATION " + statements.getLongDataType()
   42                   + ", MSG " + (statements.isUseExternalMessageReferences() ? statements.getStringIdDataType() : statements.getBinaryDataType())
   43                   + ", PRIMARY KEY ( ID ) )",                          
   44               "CREATE INDEX " + statements.getFullMessageTableName() + "_MIDX ON " + statements.getFullMessageTableName() + " (MSGID_PROD,MSGID_SEQ)",
   45               "CREATE INDEX " + statements.getFullMessageTableName() + "_CIDX ON " + statements.getFullMessageTableName() + " (CONTAINER)",                                       
   46               "CREATE INDEX " + statements.getFullMessageTableName() + "_EIDX ON " + statements.getFullMessageTableName() + " (EXPIRATION)",                 
   47               "CREATE TABLE " + statements.getFullAckTableName() + "("
   48                   + "CONTAINER " + statements.getContainerNameDataType() + " NOT NULL"
   49                   + ", SUB_DEST " + statements.getContainerNameDataType()
   50                   + ", CLIENT_ID " + statements.getStringIdDataType() + " NOT NULL"
   51                   + ", SUB_NAME " + statements.getStringIdDataType() + " NOT NULL"
   52                   + ", SELECTOR " + statements.getStringIdDataType()
   53                   + ", LAST_ACKED_ID " + statements.getSequenceDataType()
   54                   + ", PRIMARY KEY ( CONTAINER, CLIENT_ID, SUB_NAME))"
   55           };
   56           statements.setCreateSchemaStatements(createStatements);
   57           statements.setDeleteOldMessagesStatement("DELETE FROM " + statements.getFullMessageTableName() + " WHERE ( EXPIRATION<>0 AND EXPIRATION<?)");
   58           statements.setLongDataType("LONG");
   59           statements.setSequenceDataType("LONG");
   60           
   61           super.setStatements(statements);
   62       }
   63       
   64   }

Save This Page
Home » activemq-parent-5.3.1-source-release » org.apache » activemq » store » jdbc » adapter » [javadoc | source]