| /** |
| * Licensed to the Apache Software Foundation (ASF) under one or more |
| * contributor license agreements. See the NOTICE file distributed with |
| * this work for additional information regarding copyright ownership. |
| * The ASF licenses this file to You under the Apache License, Version 2.0 |
| * (the "License"); you may not use this file except in compliance with |
| * the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, software |
| * distributed under the License is distributed on an "AS IS" BASIS, |
| * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| * See the License for the specific language governing permissions and |
| * limitations under the License. |
| */ |
| package org.apache.activemq.store.jdbc.adapter; |
| |
| import java.util.ArrayList; |
| import java.util.Arrays; |
| |
| import org.apache.activemq.store.jdbc.Statements; |
| |
| /** |
| * |
| * @org.apache.xbean.XBean element="mysql-jdbc-adapter" |
| * |
| */ |
| public class MySqlJDBCAdapter extends DefaultJDBCAdapter { |
| |
| // The transactional types.. |
| public static final String INNODB = "INNODB"; |
| public static final String NDBCLUSTER = "NDBCLUSTER"; |
| public static final String BDB = "BDB"; |
| |
| // The non transactional types.. |
| public static final String MYISAM = "MYISAM"; |
| public static final String ISAM = "ISAM"; |
| public static final String MERGE = "MERGE"; |
| public static final String HEAP = "HEAP"; |
| |
| String engineType = INNODB; |
| String typeStatement = "ENGINE"; |
| |
| public void setStatements(Statements statements) { |
| String type = engineType.toUpperCase(); |
| if( !type.equals(INNODB) && !type.equals(NDBCLUSTER) ) { |
| // Don't use LOCK TABLE for the INNODB and NDBCLUSTER engine types... |
| statements.setLockCreateStatement("LOCK TABLE " + statements.getFullLockTableName() + " WRITE"); |
| } |
| |
| statements.setBinaryDataType("LONGBLOB"); |
| |
| |
| String typeClause = typeStatement + "=" + type; |
| if( type.equals(NDBCLUSTER) ) { |
| // in the NDBCLUSTER case we will create as INNODB and then alter to NDBCLUSTER |
| typeClause = typeStatement + "=" + INNODB; |
| } |
| |
| // Update the create statements so they use the right type of engine |
| String[] s = statements.getCreateSchemaStatements(); |
| for (int i = 0; i < s.length; i++) { |
| if( s[i].startsWith("CREATE TABLE")) { |
| s[i] = s[i]+ " " + typeClause; |
| } |
| } |
| |
| if( type.equals(NDBCLUSTER) ) { |
| // Add the alter statements. |
| ArrayList<String> l = new ArrayList<String>(Arrays.asList(s)); |
| l.add("ALTER TABLE "+statements.getFullMessageTableName()+" ENGINE="+NDBCLUSTER); |
| l.add("ALTER TABLE "+statements.getFullAckTableName()+" ENGINE="+NDBCLUSTER); |
| l.add("ALTER TABLE "+statements.getFullLockTableName()+" ENGINE="+NDBCLUSTER); |
| l.add("FLUSH TABLES"); |
| s = l.toArray(new String[l.size()]); |
| statements.setCreateSchemaStatements(s); |
| } |
| |
| super.setStatements(statements); |
| } |
| |
| public String getEngineType() { |
| return engineType; |
| } |
| |
| public void setEngineType(String engineType) { |
| this.engineType = engineType; |
| } |
| |
| public String getTypeStatement() { |
| return typeStatement; |
| } |
| |
| public void setTypeStatement(String typeStatement) { |
| this.typeStatement = typeStatement; |
| } |
| } |