|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.torque.adapter.DB
org.apache.torque.adapter.DBPostgres
This is used to connect to PostgresQL databases. http://www.postgresql.org/
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 |
DBPostgres()
Empty constructor. |
Method Summary | |
java.lang.String |
getBooleanString(java.lang.Boolean b)
Override the default behavior to associate b with null? |
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 name)
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. |
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. |
boolean |
supportsNativeOffset()
This method is used to chek whether the database natively supports returning results starting at an offset position other than 0. |
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, getStringDelimiter, ignoreCaseInOrderBy |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
protected DBPostgres()
Method Detail |
public java.lang.String toUpperCase(java.lang.String in)
toUpperCase
in class DB
in
- The string to transform to upper case.
public java.lang.String ignoreCase(java.lang.String in)
ignoreCase
in class DB
in
- The string whose case to ignore.
public java.lang.String getIDMethodType()
DB
IDMethod
interface denoting which
type of primary key generation method this type of RDBMS uses.
getIDMethodType
in class DB
DB.getIDMethodType()
public java.lang.String getIDMethodSQL(java.lang.Object name)
DB
null
.
getIDMethodSQL
in class DB
name
- The name of the field (should be of type
String
).
DB.getIDMethodSQL(Object)
public void lockTable(java.sql.Connection con, java.lang.String table) throws java.sql.SQLException
lockTable
in class DB
con
- The JDBC connection to use.table
- The name of the table to lock.
java.sql.SQLException
- No Statement could be created or executed.public void unlockTable(java.sql.Connection con, java.lang.String table) throws java.sql.SQLException
unlockTable
in class DB
con
- The JDBC connection to use.table
- The name of the table to unlock.
java.sql.SQLException
- No Statement could be created or executed.public boolean supportsNativeLimit()
supportsNativeLimit
in class DB
public boolean supportsNativeOffset()
supportsNativeOffset
in class DB
public int getLimitStyle()
getLimitStyle
in class DB
public java.lang.String getBooleanString(java.lang.Boolean b)
getBooleanString
in class DB
b
- the Boolean to format
DB.getBooleanString(Boolean)
public java.lang.String getDateString(java.util.Date date)
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
getDateString
in class DB
date
- the date to format
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |