public class RdbmsInformix extends RdbmsSupport
RDBMS_ACCESS, RDBMS_CLOUDSCAPE, RDBMS_DB2NT, RDBMS_DERBY, RDBMS_INFORMIX, RDBMS_MYSQL, RDBMS_ORACLE, RDBMS_POINTBASE
Constructor and Description |
---|
RdbmsInformix(javax.sql.DataSource cp,
java.sql.Connection dbConn,
RdbmsInfo dbi) |
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)
Overridden to adapt to informix syntax: the constraint name is appended last!
|
java.lang.String |
getBlobDef() |
java.lang.String |
getBooleanDef() |
java.lang.String |
getCharDef(int length) |
java.lang.String |
getClobDef() |
java.lang.String |
getDateDef() |
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
|
java.lang.String |
getFloatDef() |
java.lang.String |
getIntDef() |
java.lang.String |
getLongDef() |
java.lang.String |
getLongVarcharDef() |
java.lang.String |
getTimeDef() |
java.lang.String |
getTimestampDef() |
java.lang.String |
getVarcharDef() |
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.
|
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)
|
createRdbmsSupport, getDataSource, getDBSupport, getInstance, getRdbmsInfo, getSupportedRdbmsTypes, isSupportedRdbmsType, toString
public RdbmsInformix(javax.sql.DataSource cp, java.sql.Connection dbConn, RdbmsInfo dbi) throws java.sql.SQLException
java.sql.SQLException
protected void init(java.sql.Connection dbConn) throws java.sql.SQLException
RdbmsSupport
init
in class RdbmsSupport
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)
createAddForeignKeyStatement
in class RdbmsSupport
public int updateStatisticsFor(java.lang.String tableName)
RdbmsSupport
updateStatisticsFor
in class RdbmsSupport
public int updateStatisticsAll()
RdbmsSupport
updateStatisticsAll
in class RdbmsSupport
public java.sql.Blob getEmptyBlob()
getEmptyBlob
in class RdbmsSupport
public java.sql.Clob getEmptyClob()
getEmptyClob
in class RdbmsSupport
public java.lang.String getBooleanDef()
getBooleanDef
in class RdbmsSupport
public java.lang.String getCharDef(int length)
getCharDef
in class RdbmsSupport
public java.lang.String getIntDef()
getIntDef
in class RdbmsSupport
public java.lang.String getFloatDef()
getFloatDef
in class RdbmsSupport
public java.lang.String getLongDef()
getLongDef
in class RdbmsSupport
public java.lang.String getDoubleDef()
getDoubleDef
in class RdbmsSupport
public java.lang.String getDateDef()
getDateDef
in class RdbmsSupport
public java.lang.String getTimeDef()
getTimeDef
in class RdbmsSupport
public java.lang.String getTimestampDef()
getTimestampDef
in class RdbmsSupport
public java.lang.String getVarcharDef()
getVarcharDef
in class RdbmsSupport
public java.lang.String getVarcharDef(int length)
getVarcharDef
in class RdbmsSupport
public java.lang.String getLongVarcharDef()
getLongVarcharDef
in class RdbmsSupport
public java.lang.String getClobDef()
getClobDef
in class RdbmsSupport
public java.lang.String getBlobDef()
getBlobDef
in class RdbmsSupport
Copyright © 2014 EsprIT-Systems. All Rights Reserved.