org.apache.torque.adapter
Class DBHypersonicSQL

java.lang.Object
  org.apache.torque.adapter.AbstractDBAdapter
      org.apache.torque.adapter.DBHypersonicSQL

All Implemented Interfaces:

java.io.Serializable, DB, IDMethod

public class DBHypersonicSQL
extends AbstractDBAdapter

This is used to connect to Hypersonic SQL databases. http://hsqldb.org/

Version:

$Id: DBHypersonicSQL.java 476550 2006-11-18 16:08:37Z tfischer $

Author:

Christopher Elkins

See Also:

Serialized Form

Field Summary

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

ADAPTER_KEY, DRIVER_KEY, 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

DBHypersonicSQL() Constructor.

Method Summary

boolean	escapeText() This method is for the SqlExpression.quoteAndEscape rules.
java.lang.String	getIDMethodSQL(java.lang.Object obj) Returns SQL used to get the most recently inserted primary key.
java.lang.String	getIDMethodType() Returns the constant from the IDMethod interface denoting which type of primary key generation method this type of RDBMS uses.
java.lang.String	ignoreCase(java.lang.String in) This method is used to ignore case.
java.lang.String	ignoreCaseInOrderBy(java.lang.String in) This method is used to ignore case in an ORDER BY clause.
void	lockTable(java.sql.Connection con, java.lang.String table) Locks the specified table.
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.
boolean	useEscapeClauseForLike() Whether an escape clause in like should be used.

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

generateLimits, getBooleanString, getDateString, getFunctionClass, getLimitStyle, getStringDelimiter, supportsNativeLimit, supportsNativeOffset, useIlike

Methods inherited from class java.lang.Object

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

Constructor Detail

DBHypersonicSQL

protected DBHypersonicSQL()

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 DB

Specified by:

toUpperCase in class AbstractDBAdapter

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 DB

Specified by:

ignoreCase in class AbstractDBAdapter

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: AbstractDBAdapter

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

Specified by:

getIDMethodType in interface DB

Specified by:

getIDMethodType in class AbstractDBAdapter

Returns:

IDMethod constant

See Also:

DB.getIDMethodType()

ignoreCaseInOrderBy

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

Description copied from class: AbstractDBAdapter

This method is used to ignore case in an ORDER BY clause. Usually it is the same as ignoreCase, but some databases (Interbase for example) does not use the same SQL in ORDER BY and other clauses.

Specified by:

ignoreCaseInOrderBy in interface DB

Overrides:

ignoreCaseInOrderBy in class AbstractDBAdapter

Parameters:

in - The string whose case to ignore.

Returns:

The string in a case that can be ignored.

See Also:

DB.ignoreCaseInOrderBy(String)

getIDMethodSQL

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

Description copied from class: AbstractDBAdapter

Returns SQL used to get the most recently inserted primary key. Databases which have no support for this return null.

Specified by:

getIDMethodSQL in interface DB

Specified by:

getIDMethodSQL in class AbstractDBAdapter

Parameters:

obj - 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 interface DB

Specified by:

lockTable in class AbstractDBAdapter

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

Specified by:

unlockTable in class AbstractDBAdapter

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.

escapeText

public boolean escapeText()

This method is for the SqlExpression.quoteAndEscape rules. The rule is, any string in a SqlExpression with a BACKSLASH will either be changed to "\\" or left as "\".

Specified by:

escapeText in interface DB

Overrides:

escapeText in class AbstractDBAdapter

Returns:

false.

useEscapeClauseForLike

public boolean useEscapeClauseForLike()

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

Specified by:

useEscapeClauseForLike in interface DB

Overrides:

useEscapeClauseForLike in class AbstractDBAdapter

Returns:

whether the escape clause should be appended or not.