|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.apache.torque.adapter.AbstractAdapter
org.apache.torque.adapter.PostgresAdapter
public class PostgresAdapter
This is used to connect to PostgresQL databases. http://www.postgresql.org/
| Field Summary |
|---|
| Fields inherited from interface org.apache.torque.adapter.Adapter |
|---|
ADAPTER_KEY, AUTODETECT_ADAPTER, DRIVER_KEY |
| Constructor Summary | |
|---|---|
protected |
PostgresAdapter()
Empty constructor. |
| Method Summary | |
|---|---|
void |
generateLimits(Query query,
long offset,
int limit)
Generate a LIMIT limit OFFSET offset clause if offset > 0 or an LIMIT limit clause if limit is > 0 and offset is 0. |
String |
getIDMethodSQL(Object name)
Returns SQL used to get the most recently inserted primary key. |
IDMethod |
getIDMethodType()
Returns the constant from the IDMethod interface denoting which
type of primary key generation method this type of RDBMS uses. |
String |
ignoreCase(String in)
This method is used to ignore case. |
void |
lockTable(Connection con,
String table)
Locks the specified table. |
boolean |
supportsNativeLimit()
Return true for PostgreSQL |
boolean |
supportsNativeOffset()
Return true for PostgreSQL |
String |
toUpperCase(String in)
This method is used to ignore case. |
void |
unlockTable(Connection con,
String table)
Unlocks the specified table. |
boolean |
useIlike()
Whether ILIKE should be used for case insensitive like clauses. |
| Methods inherited from class org.apache.torque.adapter.AbstractAdapter |
|---|
escapeText, getStringDelimiter, getUpdateLockClause, ignoreCaseInOrderBy, useEscapeClauseForLike |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
protected PostgresAdapter()
| Method Detail |
|---|
public String toUpperCase(String in)
toUpperCase in interface AdaptertoUpperCase in class AbstractAdapterin - The string to transform to upper case.
public String ignoreCase(String in)
ignoreCase in interface AdapterignoreCase in class AbstractAdapterin - The string whose case to ignore.
public IDMethod getIDMethodType()
AbstractAdapterIDMethod interface denoting which
type of primary key generation method this type of RDBMS uses.
getIDMethodType in interface AdaptergetIDMethodType in class AbstractAdapterAdapter.getIDMethodType()public String getIDMethodSQL(Object name)
AbstractAdapternull.
getIDMethodSQL in interface AdaptergetIDMethodSQL in class AbstractAdaptername - The name of the field (should be of type
String).
Adapter.getIDMethodSQL(Object)
public void lockTable(Connection con,
String table)
throws SQLException
lockTable in interface AdapterlockTable in class AbstractAdaptercon - The JDBC connection to use.table - The name of the table to lock.
SQLException - No Statement could be created or executed.
public void unlockTable(Connection con,
String table)
throws SQLException
unlockTable in interface AdapterunlockTable in class AbstractAdaptercon - The JDBC connection to use.table - The name of the table to unlock.
SQLException - No Statement could be created or executed.public boolean supportsNativeLimit()
supportsNativeLimit in interface AdaptersupportsNativeLimit in class AbstractAdapterAbstractAdapter.supportsNativeLimit()public boolean supportsNativeOffset()
supportsNativeOffset in interface AdaptersupportsNativeOffset in class AbstractAdapterAbstractAdapter.supportsNativeOffset()
public void generateLimits(Query query,
long offset,
int limit)
generateLimits in interface AdaptergenerateLimits in class AbstractAdapterquery - The query to modifyoffset - the offset Valuelimit - the limit Valuepublic boolean useIlike()
useIlike in interface AdapteruseIlike in class AbstractAdapter
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||