|
| |
|
| java.lang.Object
 org.apache.torque.adapter.AbstractDBAdapter
org.apache.torque.adapter.DBPostgres
| Constructor Summary | |
| protected | DBPostgres()
Empty constructor. |
| DBPostgres | | protected DBPostgres()(Code) | | Empty constructor.
|
| generateLimits | | public void generateLimits(Query query, int offset, int limit)(Code) | | Generate a LIMIT limit OFFSET offset clause if offset > 0
or an LIMIT limit clause if limit is > 0 and offset
is 0.
Parameters:
query - The query to modify
Parameters:
offset - the offset Value
Parameters:
limit - the limit Value |
| getDateString | | public String getDateString(Date date)(Code) | | This method overrides the JDBC escapes used to format dates
using a DateFormat.
This generates the timedate format defined in
http://www.postgresql.org/docs/7.3/static/datatype-datetime.html
which defined PostgreSQL dates as YYYY-MM-DD hh:mm:ss
Parameters:
date - the date to format The properly formatted date String. |
| getLimitStyle | | public int getLimitStyle()(Code) | | This method is used to chek whether the database supports
limiting the size of the resultset.
LIMIT_STYLE_POSTGRES. |
| ignoreCase | | public String ignoreCase(String in)(Code) | | This method is used to ignore case.
Parameters:
in - The string whose case to ignore. The string in a case that can be ignored. |
| lockTable | | public void lockTable(Connection con, String table) throws SQLException(Code) | | Locks the specified table.
Parameters:
con - The JDBC connection to use.
Parameters:
table - The name of the table to lock.
exception:
SQLException - No Statement could be created or executed. |
| toUpperCase | | public String toUpperCase(String in)(Code) | | This method is used to ignore case.
Parameters:
in - The string to transform to upper case. The upper case string. |
| unlockTable | | public void unlockTable(Connection con, String table) throws SQLException(Code) | | Unlocks the specified table.
Parameters:
con - The JDBC connection to use.
Parameters:
table - The name of the table to unlock.
exception:
SQLException - No Statement could be created or executed. |
| useIlike | | public boolean useIlike()(Code) | | Whether ILIKE should be used for case insensitive like clauses.
As postgres uses ILIKE, this mimplementation returns true.
true if ilike should be used for case insensitive likes,false if ignoreCase should be applied to the compared strings. |
|
|
|