public class PlatformDb2Impl extends PlatformDefaultImpl
PlatformDefaultImpl
and defines specific
behavior for the DB2 platform.
Many of the database sequence specific properties can be specified using
custom attributes within the sequence-manager element.
Supported properties on sequence creation:
Property Key | Property Values |
seq.as |
Database sequence specific property. Specifies the datatype used for the sequence. Allowed: all numeric datatypes? e.g. INTEGER |
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 |
---|
PlatformDb2Impl() |
Modifier and Type | Method and Description |
---|---|
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 |
getLastInsertIdentityQuery(java.lang.String tableName)
If database supports native key generation via identity column, this
method should return the sql-query to obtain the last generated id.
|
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)
Patch provided by Avril Kotzen (hi001@webmail.co.za)
DB2 handles TINYINT (for mapping a byte).
|
addBatch, addPagingSql, afterStatementClose, afterStatementCreate, beforeBatch, beforeStatementClose, bindPagingParameters, bindPagingParametersFirst, changeAutoCommitState, concatenate, executeBatch, getEscapeClause, getJoinSyntaxType, initializeJdbcConnection, prepareNextValProcedureStatement, registerOutResultSet, setNullForStatement, supportsBatchOperations, supportsMultiColumnCountDistinct, supportsPaging, useCountForResultsetSize
public void setObjectForStatement(java.sql.PreparedStatement ps, int index, java.lang.Object value, int sqlType) throws java.sql.SQLException
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
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 java.lang.String getLastInsertIdentityQuery(java.lang.String tableName)
Platform
getLastInsertIdentityQuery
in interface Platform
getLastInsertIdentityQuery
in class PlatformDefaultImpl
(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