public class PlatformSapdbImpl extends PlatformDefaultImpl
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. |
ORACLE_JOIN_SYNTAX, SQL92_JOIN_SYNTAX, SQL92_NOPAREN_JOIN_SYNTAX, SYBASE_JOIN_SYNTAX
Constructor and Description |
---|
PlatformSapdbImpl() |
Modifier and Type | Method and Description |
---|---|
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
|
byte |
getJoinSyntaxType()
Get join syntax type for this RDBMS - one on of the constants from JoinSyntaxType interface
|
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
|
boolean |
useCountForResultsetSize()
Override default ResultSet size determination (rs.last();rs.getRow())
with select count(*) operation
SAP db doesn't let you use the .last, .getRow() mechanism (.getRow() will return -1)
|
addBatch, afterStatementClose, afterStatementCreate, beforeBatch, beforeStatementClose, bindPagingParametersFirst, changeAutoCommitState, concatenate, executeBatch, getEscapeClause, getLastInsertIdentityQuery, initializeJdbcConnection, prepareNextValProcedureStatement, registerOutResultSet, setNullForStatement, supportsBatchOperations, supportsMultiColumnCountDistinct
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 byte getJoinSyntaxType()
getJoinSyntaxType
in interface Platform
getJoinSyntaxType
in class PlatformDefaultImpl
Platform.getJoinSyntaxType()
public boolean useCountForResultsetSize()
useCountForResultsetSize
in interface Platform
useCountForResultsetSize
in class PlatformDefaultImpl
Platform.useCountForResultsetSize()
public java.lang.String createSequenceQuery(java.lang.String sequenceName)
PlatformDefaultImpl
createSequenceQuery
in interface Platform
createSequenceQuery
in class PlatformDefaultImpl
sequenceName
- The name of the sequence to create.public java.lang.String createSequenceQuery(java.lang.String sequenceName, java.util.Properties prop)
Platform
createSequenceQuery
in interface Platform
createSequenceQuery
in class PlatformDefaultImpl
sequenceName
- The name of the sequence to create.prop
- The database specific sequence properties.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 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
index
- parameter indexjava.sql.SQLException
Platform.bindPagingParameters(java.sql.PreparedStatement, int, int, int)
public boolean supportsPaging()
Platform
supportsPaging
in interface Platform
supportsPaging
in class PlatformDefaultImpl
Platform.supportsPaging()
(C) 2002 - 2005 Apache Software Foundation
All rights reserved. Published under the Apache License 2.0.
http://db.apache.org/ojb
Version: 1.0.4, 2005-12-30