public class SDriverSybase extends SDriver
SDriver.OffsetStrategy
Constructor and Description |
---|
SDriverSybase() |
Modifier and Type | Method and Description |
---|---|
protected java.lang.String |
columnTypeSQL(SFieldScalar field,
java.lang.String defalt)
Sybase only understands DATETIME (and SMALLDATETIME) and timestamp (must
be lc!)
|
protected java.lang.String |
driverName()
The driver name to be compared to getMetaData().getDriverName()
|
protected java.lang.String |
forUpdateSQL(boolean forUpdate)
Returns update clause, may not be valid in certain lock modes etc.
|
protected java.lang.String |
postFromSQL(boolean forUpdate)
MSSQL and Sybase do not support FOR UPDATE.
|
addNull, alterTableAddColumnSQL, alterTableDropColumnSQL, appendColumnName, appendQuotedIdentifier, appendQuotedIdentifier, appendTableName, clauseSeparator, createSequenceDDL, createTableSQL, deleteSQL, dropSequenceDDL, dropTableNoError, foreignKeysSQL, fromSQL, generateKeySelectMax, generateKeySequence, getLogger, getOffsetStrategy, getSession, indexKeySQL, insertSQL, joinSQL, limitSQL, makeForeignKeyIndexSQL, mapForeignKeys, maxIdentNameLength, postColumnSQL, postTablePostParenSQL, postTablePreParenSQL, primaryKeySQL, queryExecuteFactory, registerDriver, selectSQL, selectSQL, supportsKeySequences, supportsLocking, updateSQL, whereSQL, wholeColumnSQL
protected java.lang.String driverName()
SDriver
driverName
in class SDriver
protected java.lang.String columnTypeSQL(SFieldScalar field, java.lang.String defalt)
columnTypeSQL
in class SDriver
protected java.lang.String forUpdateSQL(boolean forUpdate)
SDriver
Oracle, Postgresql, and new in MS SQL 2005 support data versioning or snapshots. This means that repeatable read is achieved by caching the previous value read instead of using read locks. This approach makes it critical to add FOR UPDATE where appropriate or there is effectively no locking.
Indeed, in Oracle, you are guaranteed that several SELECTS will return the same value, but a subsequent SELECT FOR UPDATE in the same transaction may return a different value.
forUpdateSQL
in class SDriver
protected java.lang.String postFromSQL(boolean forUpdate)
postFromSQL
in class SDriver