nz.co.gregs.dbvolution.databases.InformixDB Maven / Gradle / Ivy
/*
* Copyright 2013 Gregory Graham.
*
* 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.
*/
package nz.co.gregs.dbvolution.databases;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;
import nz.co.gregs.dbvolution.databases.definitions.DBDefinition;
import nz.co.gregs.dbvolution.databases.definitions.InformixDBDefinition;
/**
* A version of DBDatabase tweaked for Informix 7 and higher.
*
* Support DBvolution at
* Patreon
*
* @author Gregory Graham
*/
public class InformixDB extends DBDatabase {
private final static String INFORMIXDRIVERNAME = "com.informix.jdbc.IfxDriver";
public static final long serialVersionUID = 1l;
public static final int DEFAULT_PORT = 1526;
/**
* Create a database object for a Informix 7+ database using the supplied
* definition and datasource.
*
* @param definition the DBDefiition that should be used with this database.
* Usually this will be a {@link InformixDBDefinition} but other definitions
* can be supplied.
* @param ds the data source that defines the connection to the database.
*/
protected InformixDB(DBDefinition definition, DataSource ds) {
super(definition, ds);
// Informix causes problems when using batched statements :(
setBatchSQLStatementsWhenPossible(false);
}
/**
* Create a database object for a Informix 7+ database using the supplied
* definition and connection details.
*
* @param definition the DBDefiition that should be used with this database.
* Usually this will be a {@link InformixDBDefinition} but other definitions
* can be supplied.
* @param driverName the name of the driver class to use with this database.
* @param jdbcURL the JDBC URL to the database
* @param username the username to use when connecting to the database
* @param password the password to use when connecting
*/
protected InformixDB(DBDefinition definition, String driverName, String jdbcURL, String username, String password) {
super(definition, driverName, jdbcURL, username, password);
// Informix causes problems when using batched statements :(
setBatchSQLStatementsWhenPossible(false);
}
/**
* Creates a DBDatabase configured for Informix with the given JDBC URL,
* username, and password.
*
*
* Remember to include the Informix JDBC driver in your classpath.
*
*
*
*
*
* - Database exceptions may be thrown
*
* @param jdbcURL jdbcURL the JDBC URL to use to connect to the database
* @param username username the username used for the connection
* @param password password the password required to connect the user to the
* database
*/
public InformixDB(String jdbcURL, String username, String password) {
this(new InformixDBDefinition(), INFORMIXDRIVERNAME, jdbcURL, username, password);
}
/**
* Creates a DBDatabase configured for Informix for the given data source.
*
*
* Remember to include the Informix JDBC driver in your classpath.
*
*
*
* 1 Database exceptions may be thrown
*
* @param dataSource dataSource
*/
public InformixDB(DataSource dataSource) {
this(new InformixDBDefinition(), dataSource);
}
@Override
public DBDatabase clone() throws CloneNotSupportedException {
return super.clone(); //To change body of generated methods, choose Tools | Templates.
}
@Override
protected void addDatabaseSpecificFeatures(Statement statement) throws SQLException {
// none implemented so far
;
}
}