|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.ojb.broker.platforms.PlatformDefaultImpl
org.apache.ojb.broker.platforms.PlatformPostgreSQLImpl
This class extends PlatformDefaultImpl
and defines specific
behavior for the PostgreSQL platform.
Implementation configuration properties:
Property Key | Property Values |
sequenceStart |
DEPRECATED. Database sequence specific property. Specifies the first sequence number to be generated. Allowed: 1 or greater. |
seq.start |
Database sequence specific property. Specifies the first sequence number to be generated. Allowed: 1 or greater. |
seq.incrementBy |
Database sequence specific property. Specifies the interval between sequence numbers. This value can be any positive or negative integer, but it cannot be 0. |
seq.maxValue |
Database sequence specific property. Set max value for sequence numbers. |
seq.minValue |
Database sequence specific property. Set min value for sequence numbers. |
seq.cycle |
Database sequence specific property. If true, specifies that the sequence continues to generate values after reaching either its maximum or minimum value. If false, specifies that the sequence cannot generate more values after reaching its maximum or minimum value. |
seq.cache |
Database sequence specific property. Specifies how many values of the sequence Oracle preallocates and keeps in memory for faster access. Allowed values: 2 or greater. If set 0, an explicite nocache expression will be set. |
seq.order |
Database sequence specific property. If set true, guarantees that sequence numbers are generated in order of request. If false, a no order expression will be set. |
Field Summary |
Fields inherited from interface org.apache.ojb.broker.accesslayer.JoinSyntaxTypes |
ORACLE_JOIN_SYNTAX, SQL92_JOIN_SYNTAX, SQL92_NOPAREN_JOIN_SYNTAX, SYBASE_JOIN_SYNTAX |
Constructor Summary | |
PlatformPostgreSQLImpl()
|
Method Summary | |
void |
addPagingSql(java.lang.StringBuffer anSqlString)
Add the LIMIT or equivalent to the SQL SQL-Paging is not yet supported |
int |
bindPagingParameters(java.sql.PreparedStatement ps,
int index,
int startAt,
int endAt)
Bind the Paging Parameters SQL-Paging is not yet supported |
java.lang.String |
createSequenceQuery(java.lang.String sequenceName)
Override this method to enable database based sequence generation |
java.lang.String |
createSequenceQuery(java.lang.String sequenceName,
java.util.Properties prop)
Returns a query to create a sequence entry. |
java.lang.String |
dropSequenceQuery(java.lang.String sequenceName)
Override this method to enable database based sequence generation |
java.lang.String |
getEscapeClause(LikeCriteria aCriteria)
Answer the Clause used Escape wildcards in LIKE |
java.lang.String |
nextSequenceQuery(java.lang.String sequenceName)
Override this method to enable database based sequence generation |
void |
setObjectForStatement(java.sql.PreparedStatement ps,
int index,
java.lang.Object value,
int sqlType)
Called to let the Platform implementation perform any JDBC type-specific operations needed by the driver when binding positional parameters for a PreparedStatement. |
boolean |
supportsPaging()
Answer true if LIMIT or equivalent is supported SQL-Paging is not yet supported |
Methods inherited from class org.apache.ojb.broker.platforms.PlatformDefaultImpl |
addBatch, afterStatementClose, afterStatementCreate, beforeBatch, beforeStatementClose, bindPagingParametersFirst, changeAutoCommitState, concatenate, executeBatch, getJoinSyntaxType, getLastInsertIdentityQuery, initializeJdbcConnection, prepareNextValProcedureStatement, registerOutResultSet, setNullForStatement, supportsBatchOperations, supportsMultiColumnCountDistinct, useCountForResultsetSize |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public PlatformPostgreSQLImpl()
Method Detail |
public void setObjectForStatement(java.sql.PreparedStatement ps, int index, java.lang.Object value, int sqlType) throws java.sql.SQLException
Platform
setObjectForStatement
in interface Platform
setObjectForStatement
in class PlatformDefaultImpl
java.sql.SQLException
public java.lang.String createSequenceQuery(java.lang.String sequenceName)
PlatformDefaultImpl
createSequenceQuery
in interface Platform
createSequenceQuery
in class PlatformDefaultImpl
public java.lang.String createSequenceQuery(java.lang.String sequenceName, java.util.Properties prop)
Platform
createSequenceQuery
in interface Platform
createSequenceQuery
in class PlatformDefaultImpl
public java.lang.String nextSequenceQuery(java.lang.String sequenceName)
PlatformDefaultImpl
nextSequenceQuery
in interface Platform
nextSequenceQuery
in class PlatformDefaultImpl
public java.lang.String dropSequenceQuery(java.lang.String sequenceName)
PlatformDefaultImpl
dropSequenceQuery
in interface Platform
dropSequenceQuery
in class PlatformDefaultImpl
public void addPagingSql(java.lang.StringBuffer anSqlString)
Platform
addPagingSql
in interface Platform
addPagingSql
in class PlatformDefaultImpl
Platform.addPagingSql(java.lang.StringBuffer)
public boolean supportsPaging()
Platform
supportsPaging
in interface Platform
supportsPaging
in class PlatformDefaultImpl
Platform.supportsPaging()
public int bindPagingParameters(java.sql.PreparedStatement ps, int index, int startAt, int endAt) throws java.sql.SQLException
Platform
bindPagingParameters
in interface Platform
bindPagingParameters
in class PlatformDefaultImpl
java.sql.SQLException
Platform.bindPagingParameters(java.sql.PreparedStatement, int, int, int)
public java.lang.String getEscapeClause(LikeCriteria aCriteria)
Platform
getEscapeClause
in interface Platform
getEscapeClause
in class PlatformDefaultImpl
Platform.getEscapeClause(org.apache.ojb.broker.query.LikeCriteria)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |