org.apache.torque.adapter
Class DBSybase

java.lang.Object
  org.apache.torque.adapter.DB
      org.apache.torque.adapter.DBSybase

All Implemented Interfaces:

IDMethod, java.io.Serializable

Direct Known Subclasses:

DBMSSQL

public class DBSybase

extends DB

This is used to connect to a Sybase database using Sybase's JConnect JDBC driver. NOTE:Currently JConnect does not implement the required methods for ResultSetMetaData, and therefore the village API's may not function. For connection pooling, everything works.

Version:

$Id: DBSybase.java,v 1.8.4.2 2004/05/20 04:35:15 seade Exp $

Author:

Jeff Brekke

See Also:

Serialized Form

Field Summary

Fields inherited from class org.apache.torque.adapter.DB

LIMIT_STYLE_DB2, LIMIT_STYLE_MYSQL, LIMIT_STYLE_NONE, LIMIT_STYLE_ORACLE, LIMIT_STYLE_POSTGRES, LIMIT_STYLE_SYBASE

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

AUTO_INCREMENT, ID_BROKER, NATIVE, NO_ID_METHOD, SEQUENCE

Constructor Summary

protected

DBSybase() Empty constructor.

Method Summary

java.lang.String	getDateString(java.util.Date date) This method overrides the JDBC escapes used to format dates using a DateFormat.
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).
java.lang.String	getIDMethodType() Returns the constant from the IDMethod interface denoting which type of primary key generation method this type of RDBMS uses.
int	getLimitStyle() This method is used to chek whether the database supports limiting the size of the resultset.
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() This method is used to chek whether the database natively supports limiting the size of the resultset.
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) Unlocks the specified table.

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

escapeText, getBooleanString, getStringDelimiter, ignoreCaseInOrderBy, supportsNativeOffset

Methods inherited from class java.lang.Object

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

Constructor Detail

DBSybase

protected DBSybase()

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 class DB

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 class DB

Parameters:

in - The string whose case to ignore.

Returns:

The string in a case that can be ignored.

getIDMethodType

public java.lang.String getIDMethodType()

Description copied from class: DB

Returns the constant from the IDMethod interface denoting which type of primary key generation method this type of RDBMS uses.

Specified by:

getIDMethodType in class DB

Returns:

IDMethod constant

See Also:

DB.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 class DB

Parameters:

unused - Information used for key generation.

Returns:

The most recently inserted database key.

See Also:

DB.getIDMethodSQL(Object obj)

lockTable

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

Locks the specified table.

Specified by:

lockTable in class DB

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

Unlocks the specified table.

Specified by:

unlockTable in class DB

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()

This method is used to chek whether the database natively supports limiting the size of the resultset.

Overrides:

supportsNativeLimit in class DB

Returns:

True.

getLimitStyle

public int getLimitStyle()

This method is used to chek whether the database supports limiting the size of the resultset.

Overrides:

getLimitStyle in class DB

Returns:

LIMIT_STYLE_SYBASE.

getDateString

public java.lang.String getDateString(java.util.Date date)

This method overrides the JDBC escapes used to format dates using a DateFormat. As of version 11, the Sybase JDBC driver does not implement JDBC 3.0 escapes.

Overrides:

getDateString in class DB

Parameters:

date - the date to format

Returns:

The properly formatted date String.