001/** 002 * Licensed to the Apache Software Foundation (ASF) under one or more 003 * contributor license agreements. See the NOTICE file distributed with 004 * this work for additional information regarding copyright ownership. 005 * The ASF licenses this file to You under the Apache License, Version 2.0 006 * (the "License"); you may not use this file except in compliance with 007 * the License. You may obtain a copy of the License at 008 * 009 * http://www.apache.org/licenses/LICENSE-2.0 010 * 011 * Unless required by applicable law or agreed to in writing, software 012 * distributed under the License is distributed on an "AS IS" BASIS, 013 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 014 * See the License for the specific language governing permissions and 015 * limitations under the License. 016 */ 017package org.apache.activemq.store.jdbc.adapter; 018 019import org.apache.activemq.store.jdbc.Statements; 020 021/** 022 * A JDBC Adapter for Transact-SQL based databases such as SQL Server or Sybase 023 * 024 * @org.apache.xbean.XBean element="transact-jdbc-adapter" 025 * 026 * 027 */ 028public class TransactJDBCAdapter extends ImageBasedJDBCAdaptor { 029 @Override 030 public void setStatements(Statements statements) { 031 String lockCreateStatement = "SELECT * FROM " + statements.getFullLockTableName(); 032 033 if (statements.isUseLockCreateWhereClause()) { 034 lockCreateStatement += " WHERE ID = 1"; 035 } 036 lockCreateStatement += " WITH (UPDLOCK, ROWLOCK)"; 037 statements.setLockCreateStatement(lockCreateStatement); 038 039 super.setStatements(statements); 040 } 041}