com.solarmetric.rd.kodo.impl.jdbc.schema.dict
Class SQLServerDictionary

java.lang.Object
  |
  +--com.solarmetric.rd.kodo.impl.jdbc.schema.DBDictionary
        |
        +--com.solarmetric.rd.kodo.impl.jdbc.schema.dict.SQLServerDictionary

public class SQLServerDictionary

extends DBDictionary

Dictionary for MS SQLServer.

Field Summary

Fields inherited from class com.solarmetric.rd.kodo.impl.jdbc.schema.DBDictionary

CENTI, DECI, MICRO, MILLI, NANO, SEC

Constructor Summary

SQLServerDictionary()

Method Summary

java.lang.String[]	getDropIndexSQL(com.solarmetric.rd.kodo.impl.jdbc.schema.Index idx) Return a series of SQL statements to drop the given index.
java.lang.String	getPlatform() Return the database platform for this dictionary.
int	getPreferredType(int type) Return the preferred Types type for the given one.
protected java.lang.String	getTypeName(com.solarmetric.rd.kodo.impl.jdbc.schema.Column col) Return the preferred database type for the given column's type from Types.
void	setNull(java.sql.PreparedStatement stmnt, int idx, int colType) Set the given value as a parameters to the statement.
boolean	supportsDeferredConstraints() Return true if the database supports deferred constraints.
com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer	toSelect(com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer select, java.lang.String tables, com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer where, com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer order, boolean distinct, boolean forUpdate) Create a SELECT statement for this database.

Methods inherited from class com.solarmetric.rd.kodo.impl.jdbc.schema.DBDictionary

addSystemSchema, addSystemTable, generateForeignKeys, generateIndexes, generatePrimaryKeys, generateTables, getAddColumnSQL, getAddForeignKeySQL, getAddPrimaryKeySQL, getArray, getAsciiStream, getBigDecimal, getBigInteger, getBinaryStream, getBlob, getBlobObject, getBoolean, getByte, getBytes, getChar, getCharacterStream, getClob, getClobString, getConfiguration, getCreateIndexSQL, getCreateTableSQL, getDate, getDate, getDatePrecision, getDBMetaData, getDeclareColumnSQL, getDouble, getDropColumnSQL, getDropForeignKeySQL, getDropPrimaryKeySQL, getDropTableSQL, getFloat, getForeignKeyActionName, getForeignKeyConstraintSQL, getInt, getJDBCType, getJDBCType, getLocale, getLong, getObject, getPrimaryKeyConstraintSQL, getRef, getShort, getSimulateLocking, getStoreCharsAsNumbers, getStoreLargeNumbersAsStrings, getString, getSystemSchemas, getSystemTables, getTime, getTimestamp, getValidColumnName, getValidForeignKeyName, getValidIndexName, getValidPrimaryKeyName, getValidTableName, isSystemIndex, isSystemTable, makeNameValid, replaceMapping, replaceMappingFactory, replaceSchemaFactory, setArray, setAsciiStream, setBigDecimal, setBigInteger, setBinaryStream, setBlob, setBlobObject, setBoolean, setByte, setBytes, setChar, setCharacterStream, setClob, setClobString, setConfiguration, setDate, setDate, setDBMetaData, setDouble, setFloat, setInt, setLocale, setLong, setObject, setRef, setShort, setSimulateLocking, setStoreCharsAsNumbers, setStoreLargeNumbersAsStrings, setString, setSystemSchemas, setSystemTables, setTime, setTimestamp, supportsForeignKeyDeleteAction, supportsSelectForUpdate, supportsUpdateCountsForBatch, wrapConnection

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLServerDictionary

public SQLServerDictionary()

Method Detail

getPlatform

public java.lang.String getPlatform()

Description copied from class: DBDictionary

Return the database platform for this dictionary.

Overrides:

getPlatform in class DBDictionary

supportsDeferredConstraints

public boolean supportsDeferredConstraints()

Description copied from class: DBDictionary

Return true if the database supports deferred constraints. Returns true by default.

Overrides:

supportsDeferredConstraints in class DBDictionary

setNull

public void setNull(java.sql.PreparedStatement stmnt,
                    int idx,
                    int colType)
             throws java.sql.SQLException

Description copied from class: DBDictionary

Set the given value as a parameters to the statement. The column type will come from Types.

Overrides:

setNull in class DBDictionary

java.sql.SQLException

getPreferredType

public int getPreferredType(int type)

Description copied from class: DBDictionary

Return the preferred Types type for the given one. Returns the given type by default.

Overrides:

getPreferredType in class DBDictionary

getTypeName

protected java.lang.String getTypeName(com.solarmetric.rd.kodo.impl.jdbc.schema.Column col)

Description copied from class: DBDictionary

Return the preferred database type for the given column's type from Types. Defaults to using the DBMetaData.

Overrides:

getTypeName in class DBDictionary

toSelect

public com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer toSelect(com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer select,
                                                                   java.lang.String tables,
                                                                   com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer where,
                                                                   com.solarmetric.rd.kodo.impl.jdbc.schema.SQLBuffer order,
                                                                   boolean distinct,
                                                                   boolean forUpdate)

Description copied from class: DBDictionary

Create a SELECT statement for this database.

Overrides:

toSelect in class DBDictionary

getDropIndexSQL

public java.lang.String[] getDropIndexSQL(com.solarmetric.rd.kodo.impl.jdbc.schema.Index idx)

Description copied from class: DBDictionary

Return a series of SQL statements to drop the given index. Returns DROP INDEX <index name> by default.

Overrides:

getDropIndexSQL in class DBDictionary