public abstract class RdbmsSupport
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
RDBMS_ACCESS |
static java.lang.String |
RDBMS_CLOUDSCAPE |
static java.lang.String |
RDBMS_DB2NT |
static java.lang.String |
RDBMS_DERBY |
static java.lang.String |
RDBMS_INFORMIX |
static java.lang.String |
RDBMS_MYSQL |
static java.lang.String |
RDBMS_ORACLE |
static java.lang.String |
RDBMS_POINTBASE |
Constructor and Description |
---|
RdbmsSupport(javax.sql.DataSource cp,
java.sql.Connection dbConn,
RdbmsInfo dbInfo) |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
createAddForeignKeyStatement(java.lang.String sourceTable,
java.lang.String sourceCols,
java.lang.String targetTable,
java.lang.String targetCols,
java.lang.String constrName)
This default implementation is valid for most RDBMS systems.
|
static RdbmsSupport |
createRdbmsSupport(javax.sql.DataSource cp) |
abstract java.lang.String |
getBlobDef() |
abstract java.lang.String |
getBooleanDef() |
abstract java.lang.String |
getCharDef(int length) |
abstract java.lang.String |
getClobDef() |
javax.sql.DataSource |
getDataSource() |
abstract java.lang.String |
getDateDef() |
DBSupport |
getDBSupport() |
abstract java.lang.String |
getDoubleDef() |
java.sql.Blob |
getEmptyBlob()
Most RDBMS systems need 'null', but Informix needs and empty Blob Object
|
java.sql.Clob |
getEmptyClob()
Most RDBMS systems need 'null', but Informix needs and empty Clob Object
|
abstract java.lang.String |
getFloatDef() |
static RdbmsSupport |
getInstance() |
abstract java.lang.String |
getIntDef() |
abstract java.lang.String |
getLongDef() |
abstract java.lang.String |
getLongVarcharDef() |
RdbmsInfo |
getRdbmsInfo()
Returns the RdbmsInfo object which caches the most frequently used database meta data
|
static java.lang.String[] |
getSupportedRdbmsTypes()
Returns the short-names of all supported RDBMS types that are
defined as public constants RDBMS_* in this class.
|
abstract java.lang.String |
getTimeDef() |
abstract java.lang.String |
getTimestampDef() |
abstract java.lang.String |
getVarcharDef() |
abstract java.lang.String |
getVarcharDef(int length) |
protected void |
init(java.sql.Connection dbConn)
May be overridden by subclasses in order to do any RDBMS-specific
initialization on the given connection.
|
static boolean |
isSupportedRdbmsType(java.lang.String rdbmsType)
Tells whether the given RDBMS type name is one of the RdbmsSupport.RDBMS_* constants.
|
java.lang.String |
toString() |
int |
updateStatisticsAll()
Updates the database statistics for all tables
(Not supported on most RDBMS systems)
|
int |
updateStatisticsFor(java.lang.String tableName)
Updates the database statistics for the given table
(Not supported on most RDBMS systems)
|
public static final java.lang.String RDBMS_MYSQL
public static final java.lang.String RDBMS_CLOUDSCAPE
public static final java.lang.String RDBMS_DB2NT
public static final java.lang.String RDBMS_INFORMIX
public static final java.lang.String RDBMS_POINTBASE
public static final java.lang.String RDBMS_ORACLE
public static final java.lang.String RDBMS_DERBY
public static final java.lang.String RDBMS_ACCESS
public RdbmsSupport(javax.sql.DataSource cp, java.sql.Connection dbConn, RdbmsInfo dbInfo) throws java.sql.SQLException
java.sql.SQLException
public javax.sql.DataSource getDataSource()
public RdbmsInfo getRdbmsInfo()
protected void init(java.sql.Connection dbConn) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String createAddForeignKeyStatement(java.lang.String sourceTable, java.lang.String sourceCols, java.lang.String targetTable, java.lang.String targetCols, java.lang.String constrName)
public int updateStatisticsFor(java.lang.String tableName)
public int updateStatisticsAll()
public java.sql.Blob getEmptyBlob()
public DBSupport getDBSupport()
public java.sql.Clob getEmptyClob()
public java.lang.String toString()
toString
in class java.lang.Object
public abstract java.lang.String getBooleanDef()
public abstract java.lang.String getCharDef(int length)
public abstract java.lang.String getIntDef()
public abstract java.lang.String getLongDef()
public abstract java.lang.String getFloatDef()
public abstract java.lang.String getDoubleDef()
public abstract java.lang.String getDateDef()
public abstract java.lang.String getTimeDef()
public abstract java.lang.String getTimestampDef()
public abstract java.lang.String getVarcharDef()
public abstract java.lang.String getVarcharDef(int length)
public abstract java.lang.String getLongVarcharDef()
public abstract java.lang.String getClobDef()
public abstract java.lang.String getBlobDef()
public static java.lang.String[] getSupportedRdbmsTypes()
public static boolean isSupportedRdbmsType(java.lang.String rdbmsType)
public static RdbmsSupport createRdbmsSupport(javax.sql.DataSource cp) throws java.sql.SQLException
java.sql.SQLException
public static RdbmsSupport getInstance()
Copyright © 2014 EsprIT-Systems. All Rights Reserved.