com.konakart.db

Class MssqlAdapter

java.lang.Object

org.apache.torque.adapter.AbstractAdapter

com.konakart.db.MssqlAdapter

All Implemented Interfaces:

java.io.Serializable, org.apache.torque.adapter.Adapter

public class MssqlAdapter
extends org.apache.torque.adapter.AbstractAdapter

This is used to connect to a MSSQL database. This is tested with the jtds driver from sourceforge.

Version:

$Id: MssqlAdapter.java 1450486 2013-02-26 22:18:00Z tfischer $

Author:

Gonzalo Diethelm

See Also:

Serialized Form

Field Summary

Fields inherited from interface org.apache.torque.adapter.Adapter

ADAPTER_KEY, AUTODETECT_ADAPTER, DRIVER_KEY

Constructor Summary

Constructors

Constructor and Description
MssqlAdapter() Empty constructor.

Method Summary

Modifier and Type	Method and Description
boolean	escapeText() Determines whether backslashes (\) should be escaped in explicit SQL strings.
void	generateLimits(org.apache.torque.sql.Query query, long offset, int limit) Modify a query to add limit and offset values for Sybase.
java.lang.String	getIDMethodSQL(java.lang.Object unused) Returns the last value from an identity column (available on a per-session basis from the global variable @@identity).
org.apache.torque.adapter.IDMethod	getIDMethodType()
java.lang.String	getUpdateLockClause() Returns the clause which acquires a write lock on a row when doing a select.
java.lang.String	ignoreCase(java.lang.String in) This method is used to ignore case.
void	lockTable(java.sql.Connection con, java.lang.String table) Locks the specified table.
boolean	supportsNativeLimit() Return true for Sybase
boolean	supportsNativeOffset() Return true for MS SQL Server
java.lang.String	toUpperCase(java.lang.String in) This method is used to ignore case.
void	unlockTable(java.sql.Connection con, java.lang.String table) Tries to unlock the specified table.
boolean	useEscapeClauseForLike() Whether an escape clause in like should be used.

Methods inherited from class org.apache.torque.adapter.AbstractAdapter

getStringDelimiter, ignoreCaseInOrderBy, useIlike

Methods inherited from class java.lang.Object

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

Constructor Detail

MssqlAdapter

public MssqlAdapter()

Empty constructor.

Method Detail

toUpperCase

public java.lang.String toUpperCase(java.lang.String in)

This method is used to ignore case.

Specified by:

toUpperCase in interface org.apache.torque.adapter.Adapter

Specified by:

toUpperCase in class org.apache.torque.adapter.AbstractAdapter

Parameters:

in - The string to transform to upper case.

Returns:

The upper case string.

ignoreCase

public java.lang.String ignoreCase(java.lang.String in)

This method is used to ignore case.

Specified by:

ignoreCase in interface org.apache.torque.adapter.Adapter

Specified by:

ignoreCase in class org.apache.torque.adapter.AbstractAdapter

Parameters:

in - The string whose case to ignore.

Returns:

The string in a case that can be ignored.

getIDMethodType

public org.apache.torque.adapter.IDMethod getIDMethodType()

Specified by:

getIDMethodType in interface org.apache.torque.adapter.Adapter

Specified by:

getIDMethodType in class org.apache.torque.adapter.AbstractAdapter

See Also:

Adapter.getIDMethodType()

getIDMethodSQL

public java.lang.String getIDMethodSQL(java.lang.Object unused)

Returns the last value from an identity column (available on a per-session basis from the global variable @@identity).

Specified by:

getIDMethodSQL in interface org.apache.torque.adapter.Adapter

Specified by:

getIDMethodSQL in class org.apache.torque.adapter.AbstractAdapter

See Also:

Adapter.getIDMethodSQL(Object obj)

getUpdateLockClause

public java.lang.String getUpdateLockClause()

Returns the clause which acquires a write lock on a row when doing a select.

Specified by:

getUpdateLockClause in interface org.apache.torque.adapter.Adapter

Overrides:

getUpdateLockClause in class org.apache.torque.adapter.AbstractAdapter

Returns:

the SQL clause to acquire a write lock. This implementation returns "WITH (UPDLOCK)";

lockTable

public void lockTable(java.sql.Connection con,
                      java.lang.String table)
               throws java.sql.SQLException

Locks the specified table.

Specified by:

lockTable in interface org.apache.torque.adapter.Adapter

Specified by:

lockTable in class org.apache.torque.adapter.AbstractAdapter

Parameters:

con - The JDBC connection to use.

table - The name of the table to lock.

Throws:

java.sql.SQLException - No Statement could be created or executed.

unlockTable

public void unlockTable(java.sql.Connection con,
                        java.lang.String table)
                 throws java.sql.SQLException

Tries to unlock the specified table. This implementation does nothing as tables in MSSQL are unlocked when a commit or rollback is issued. This has unintended side effects, as well as we do not know whether to use commit or rollback. The lock will go away automatically when the transaction is ended.

Specified by:

unlockTable in interface org.apache.torque.adapter.Adapter

Specified by:

unlockTable in class org.apache.torque.adapter.AbstractAdapter

Parameters:

con - The JDBC connection to use.

table - The name of the table to unlock.

Throws:

java.sql.SQLException - No Statement could be created or executed.

supportsNativeLimit

public boolean supportsNativeLimit()

Return true for Sybase

Specified by:

supportsNativeLimit in interface org.apache.torque.adapter.Adapter

Overrides:

supportsNativeLimit in class org.apache.torque.adapter.AbstractAdapter

See Also:

AbstractAdapter.supportsNativeLimit()

supportsNativeOffset

public boolean supportsNativeOffset()

Return true for MS SQL Server

Specified by:

supportsNativeOffset in interface org.apache.torque.adapter.Adapter

Overrides:

supportsNativeOffset in class org.apache.torque.adapter.AbstractAdapter

See Also:

AbstractAdapter.supportsNativeOffset()

generateLimits

public void generateLimits(org.apache.torque.sql.Query query,
                           long offset,
                           int limit)
                    throws org.apache.torque.TorqueException

Modify a query to add limit and offset values for Sybase.

Specified by:

generateLimits in interface org.apache.torque.adapter.Adapter

Overrides:

generateLimits in class org.apache.torque.adapter.AbstractAdapter

Parameters:

query - The query to modify

offset - the offset Value

limit - the limit Value

Throws:

org.apache.torque.TorqueException - if any error occurs when building the query

escapeText

public boolean escapeText()

Determines whether backslashes (\) should be escaped in explicit SQL strings. If true is returned, a BACKSLASH will be changed to "\\". If false is returned, a BACKSLASH will be left as "\". Sybase (and MSSQL) doesn't define a default escape character, so false is returned.

Specified by:

escapeText in interface org.apache.torque.adapter.Adapter

Overrides:

escapeText in class org.apache.torque.adapter.AbstractAdapter

Returns:

false

See Also:

Adapter.escapeText()

useEscapeClauseForLike

public boolean useEscapeClauseForLike()

Whether an escape clause in like should be used. Example : select * from AUTHOR where AUTHOR.NAME like '\_%' ESCAPE '\'; Sybase needs this, so this implementation always returns true.

Specified by:

useEscapeClauseForLike in interface org.apache.torque.adapter.Adapter

Overrides:

useEscapeClauseForLike in class org.apache.torque.adapter.AbstractAdapter

Returns:

whether the escape clause should be appended or not.