public interface Platform
Modifier and Type | Method and Description |
---|---|
void |
addBatch(java.sql.PreparedStatement stmt)
Called when adding statements to current batch.
|
void |
addPagingSql(java.lang.StringBuffer anSqlString)
Add the LIMIT or equivalent to the SQL
SQL-Paging is not yet supported
|
void |
afterStatementClose(java.sql.Statement stmt,
java.sql.ResultSet rs)
Called by
StatementManagerIF implementation
after invoking stmt.close() method. |
void |
afterStatementCreate(java.sql.Statement stmt)
Called after a statement has been created.
|
void |
beforeBatch(java.sql.PreparedStatement stmt)
Called before batching operations on a statement.
|
void |
beforeStatementClose(java.sql.Statement stmt,
java.sql.ResultSet rs)
Called by
StatementManagerIF implementation
before invoking stmt.close() method. |
int |
bindPagingParameters(java.sql.PreparedStatement ps,
int index,
int startAt,
int endAt)
Bind the Paging Parameters
SQL-Paging is not yet supported
|
boolean |
bindPagingParametersFirst()
Answer true if the LIMIT parameters are bound before the query parameters
SQL-Paging is not yet supported
|
void |
changeAutoCommitState(JdbcConnectionDescriptor jcd,
java.sql.Connection con,
boolean newState)
Used to do a temporary change of the m_connection autoCommit state.
|
java.lang.String |
concatenate(java.lang.String[] theColumns)
Concatenate the columns
ie: col1 || col2 || col3 (ANSI)
ie: col1 + col2 + col3 (MS SQL-Server)
ie: concat(col1, col2, col3) (MySql)
|
java.lang.String |
createSequenceQuery(java.lang.String sequenceName)
Deprecated.
use
createSequenceQuery(String) instead. |
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)
Returns a query to drop a sequence entry.
|
int[] |
executeBatch(java.sql.PreparedStatement stmt)
Executes current batch.
|
java.lang.String |
getEscapeClause(LikeCriteria aCriteria)
Answer the Clause used Escape wildcards in LIKE
|
byte |
getJoinSyntaxType()
Get join syntax type for this RDBMS - one of the constants from JoinSyntaxTypes interface.
|
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.
|
void |
initializeJdbcConnection(JdbcConnectionDescriptor jcd,
java.sql.Connection conn)
Called immediately after a JDBC connection has been created by a
ConnectionFactory implementation (not used for DataSource connections).
|
java.lang.String |
nextSequenceQuery(java.lang.String sequenceName)
Returns a query to obtain the next sequence key.
|
java.sql.CallableStatement |
prepareNextValProcedureStatement(java.sql.Connection con,
java.lang.String procedureName,
java.lang.String sequenceName)
Create stored procedure call for a special sequence manager implementation
SequenceManagerStoredProcedureImpl ,
because it seems that jdbc-driver differ in handling of CallableStatement. |
void |
registerOutResultSet(java.sql.CallableStatement stmt,
int position)
Registers call argument at
position as returning
a ResultSet value. |
void |
setNullForStatement(java.sql.PreparedStatement ps,
int index,
int sqlType)
Called to let the Platform implementation perform any JDBC type-specific operations
needed by the driver when binding null parameters for a PreparedStatement.
|
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 |
supportsBatchOperations()
If this platform supports the batch operations jdbc 2.0 feature.
|
boolean |
supportsMultiColumnCountDistinct()
Whether the platform supports a COUNT DISTINCT across multiple columns.
|
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.
|
void afterStatementCreate(java.sql.Statement stmt) throws PlatformException
PlatformException
void beforeStatementClose(java.sql.Statement stmt, java.sql.ResultSet rs) throws PlatformException
StatementManagerIF
implementation
before invoking stmt.close() method.PlatformException
void afterStatementClose(java.sql.Statement stmt, java.sql.ResultSet rs) throws PlatformException
StatementManagerIF
implementation
after invoking stmt.close() method.PlatformException
void beforeBatch(java.sql.PreparedStatement stmt) throws PlatformException
stmt
- the statement you want to batch onPlatformException
void addBatch(java.sql.PreparedStatement stmt) throws PlatformException
stmt
- the statement you are adding to the batchPlatformException
int[] executeBatch(java.sql.PreparedStatement stmt) throws PlatformException
stmt
- the statement you want to execute the batch onPlatformException
void initializeJdbcConnection(JdbcConnectionDescriptor jcd, java.sql.Connection conn) throws PlatformException
conn
- the Connection to be initializedPlatformException
void changeAutoCommitState(JdbcConnectionDescriptor jcd, java.sql.Connection con, boolean newState)
JdbcConnectionDescriptor.getUseAutoCommit()
was set to
JdbcConnectionDescriptor.AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
the change of the autoCommit state take effect.void setObjectForStatement(java.sql.PreparedStatement ps, int index, java.lang.Object value, int sqlType) throws java.sql.SQLException
java.sql.SQLException
void setNullForStatement(java.sql.PreparedStatement ps, int index, int sqlType) throws java.sql.SQLException
java.sql.SQLException
byte getJoinSyntaxType()
boolean useCountForResultsetSize()
boolean supportsBatchOperations()
java.lang.String createSequenceQuery(java.lang.String sequenceName, java.util.Properties prop)
sequenceName
- The name of the sequence to create.prop
- The database specific sequence properties.java.lang.String createSequenceQuery(java.lang.String sequenceName)
createSequenceQuery(String)
instead.sequenceName
- The name of the sequence to create.java.lang.String nextSequenceQuery(java.lang.String sequenceName)
java.lang.String dropSequenceQuery(java.lang.String sequenceName)
java.sql.CallableStatement prepareNextValProcedureStatement(java.sql.Connection con, java.lang.String procedureName, java.lang.String sequenceName) throws PlatformException
SequenceManagerStoredProcedureImpl
,
because it seems that jdbc-driver differ in handling of CallableStatement.
Connection con = broker.serviceConnectionManager().getConnection(); cs = getPlatform().prepareNextValProcedureStatement(con, PROCEDURE_NAME, sequenceName); cs.executeUpdate(); return cs.getLong(1);
PlatformException
java.lang.String getLastInsertIdentityQuery(java.lang.String tableName)
boolean supportsPaging()
void addPagingSql(java.lang.StringBuffer anSqlString)
boolean bindPagingParametersFirst()
int bindPagingParameters(java.sql.PreparedStatement ps, int index, int startAt, int endAt) throws java.sql.SQLException
ps
- index
- parameter indexstartAt
- endAt
- java.sql.SQLException
boolean supportsMultiColumnCountDistinct()
true
if it is supportedjava.lang.String concatenate(java.lang.String[] theColumns)
theColumns
- java.lang.String getEscapeClause(LikeCriteria aCriteria)
aCriteria
- void registerOutResultSet(java.sql.CallableStatement stmt, int position) throws java.sql.SQLException
position
as returning
a ResultSet
value.stmt
- the statementposition
- argument positionjava.sql.SQLException
(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