/**
* Licensed to Jasig under one or more contributor license
* agreements. See the NOTICE file distributed with this work
* for additional information regarding copyright ownership.
* Jasig 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.jasig.portal.utils;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;
import org.hibernate.dialect.Dialect;
import org.hibernate.dialect.SQLServer2005Dialect;
import org.hibernate.service.jdbc.dialect.internal.AbstractDialectResolver;
/**
* @author Eric Dalquist
* @version $Revision$
*/
public class PortalDialectResolver extends AbstractDialectResolver {
private static final long serialVersionUID = 1L;
protected final Dialect resolveDialectInternal(DatabaseMetaData metaData) throws SQLException {
final String databaseName = metaData.getDatabaseProductName();
final int databaseMajorVersion = metaData.getDatabaseMajorVersion();
final int databaseMinorVersion = metaData.getDatabaseMinorVersion();
if ("MySQL".equals(databaseName) && 5 == databaseMajorVersion) {
return new MySQL5InnoDBCompressedDialect();
}
if ("PostgreSQL".equals(databaseName) && 8 == databaseMajorVersion && databaseMinorVersion <= 1) {
return new PostgreSQL81Dialect();
}
// This is due to a jTDS not supporting SQL Server 2008+, hence does not support some new types like TIME.
if ("Microsoft SQL Server".equals(databaseName) && databaseMajorVersion > 9) {
return new SQLServer2005Dialect();
}
return null;
}
}