|
|||||||||
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.PlatformOracleImpl
public class PlatformOracleImpl
This class is a concrete implementation of Platform
. Provides an implementation
that works around some issues with Oracle in general and Oracle's Thin driver in particular.
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 | |
---|---|
PlatformOracleImpl()
Default constructor. |
Method Summary | |
---|---|
void |
afterStatementCreate(java.sql.Statement stmt)
In Oracle we set escape processing explizit 'true' after a statement was created. |
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 |
java.sql.CallableStatement |
prepareNextValProcedureStatement(java.sql.Connection con,
java.lang.String procedureName,
java.lang.String sequenceName)
Method prepareNextValProcedureStatement implementation is simply copied over from PlatformMsSQLServerImpl class. |
void |
registerOutResultSet(java.sql.CallableStatement stmt,
int position)
Registers call argument at position as returning
a ResultSet value. |
void |
setObjectForStatement(java.sql.PreparedStatement ps,
int index,
java.lang.Object value,
int sqlType)
For objects beyond 4k, weird things happen in Oracle if you try to use "setBytes", so for all cases it's better to use setBinaryStream. |
Methods inherited from class org.apache.ojb.broker.platforms.PlatformDefaultImpl |
---|
addBatch, addPagingSql, afterStatementClose, beforeBatch, beforeStatementClose, bindPagingParameters, bindPagingParametersFirst, changeAutoCommitState, concatenate, executeBatch, getEscapeClause, getLastInsertIdentityQuery, initializeJdbcConnection, setNullForStatement, supportsBatchOperations, supportsMultiColumnCountDistinct, supportsPaging, useCountForResultsetSize |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public PlatformOracleImpl()
Method Detail |
---|
public java.sql.CallableStatement prepareNextValProcedureStatement(java.sql.Connection con, java.lang.String procedureName, java.lang.String sequenceName) throws PlatformException
prepareNextValProcedureStatement
in interface Platform
prepareNextValProcedureStatement
in class PlatformDefaultImpl
PlatformException
Platform.prepareNextValProcedureStatement(java.sql.Connection, java.lang.String, java.lang.String)
public void afterStatementCreate(java.sql.Statement stmt) throws PlatformException
afterStatementCreate
in interface Platform
afterStatementCreate
in class PlatformDefaultImpl
PlatformException
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
Platform.setObjectForStatement(java.sql.PreparedStatement, int, java.lang.Object, int)
public byte getJoinSyntaxType()
getJoinSyntaxType
in interface Platform
getJoinSyntaxType
in class PlatformDefaultImpl
Platform.getJoinSyntaxType()
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 registerOutResultSet(java.sql.CallableStatement stmt, int position) throws java.sql.SQLException
Platform
position
as returning
a ResultSet
value.
registerOutResultSet
in interface Platform
registerOutResultSet
in class PlatformDefaultImpl
stmt
- the statementposition
- argument position
java.sql.SQLException
Platform.registerOutResultSet(java.sql.CallableStatement, int)
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |