org.arp.javautil.sql.AbstractConnectionSpec Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of javautil Show documentation

JavaUtil is a utility library to speed the development of Java software. We developed it over multiple years during our internal development efforts, and it has reached a point of stability where we have decided to make it available to the outside world. The JavaUtil package aims to fill in the gaps of the Apache Commons and similar utility libraries out there. Features include convenience classes for string, collections, arrays, dates, iterators, colors, logging, unit testing, a little bit of basic statistics, database queries, caching and more.

There is a newer version: 4.5

Show newest version

package org.arp.javautil.sql;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;

/*
 * #%L
 * JavaUtil
 * %%
 * Copyright (C) 2012 - 2015 Emory University
 * %%
 * Licensed 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.
 * #L%
 */
/**
 *
 * @author Andrew Post
 */
public abstract class AbstractConnectionSpec implements ConnectionSpec {

    private final boolean autoCommitEnabled;
    private DatabaseProduct databaseProduct;
    private DatabaseVersion databaseVersion;
    private Driver driverName;
    private DriverVersion driverVersion;
    
    AbstractConnectionSpec(boolean autoCommitEnabled) {
        this.autoCommitEnabled = autoCommitEnabled;
    }

    @Override
    public boolean isAutoCommitEnabled() {
        return this.autoCommitEnabled;
    }

    @Override
    public DatabaseProduct getDatabaseProduct() throws SQLException {
        readMetaDataIfNeeded();
        return this.databaseProduct;
    }

    @Override
    public DatabaseVersion getDatabaseVersion() throws SQLException {
        readMetaDataIfNeeded();
        return this.databaseVersion;
    }

    @Override
    public Driver getDriver() throws SQLException {
        readMetaDataIfNeeded();
        return this.driverName;
    }

    @Override
    public DriverVersion getDriverVersion() throws SQLException {
        readMetaDataIfNeeded();
        return this.driverVersion;
    }

    private void readMetaDataIfNeeded() throws SQLException {
        if (this.databaseVersion == null) {
            try (Connection cn = getOrCreate()) {
                DatabaseMetaData metaData = cn.getMetaData();
                this.databaseProduct = DatabaseProduct.fromMetaData(metaData);
                this.databaseVersion = new DatabaseVersion(metaData);
                this.driverName = Driver.fromMetaData(metaData);
                this.driverVersion = new DriverVersion(metaData);
            }
        }
    }

}