public class PlatformMsSQLServerImpl extends PlatformDefaultImpl
PlatformDefaultImpl
and defines specific behavior for the
Microsoft SQL Server platform.ORACLE_JOIN_SYNTAX, SQL92_JOIN_SYNTAX, SQL92_NOPAREN_JOIN_SYNTAX, SYBASE_JOIN_SYNTAX
Constructor and Description |
---|
PlatformMsSQLServerImpl() |
Modifier and Type | Method and Description |
---|---|
byte |
getJoinSyntaxType()
Get join syntax type for this RDBMS - one on of the constants from JoinSyntaxType interface
MBAIRD: MS SQL Server 2000 actually supports both types, but due to a problem with the sql
generator, we opt to have no parens.
|
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.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. |
addBatch, addPagingSql, afterStatementClose, afterStatementCreate, beforeBatch, beforeStatementClose, bindPagingParameters, bindPagingParametersFirst, changeAutoCommitState, concatenate, createSequenceQuery, createSequenceQuery, dropSequenceQuery, executeBatch, getEscapeClause, initializeJdbcConnection, nextSequenceQuery, registerOutResultSet, setNullForStatement, setObjectForStatement, supportsBatchOperations, supportsMultiColumnCountDistinct, supportsPaging, useCountForResultsetSize
public byte getJoinSyntaxType()
getJoinSyntaxType
in interface Platform
getJoinSyntaxType
in class PlatformDefaultImpl
Platform.getJoinSyntaxType()
public java.sql.CallableStatement prepareNextValProcedureStatement(java.sql.Connection con, java.lang.String procedureName, java.lang.String sequenceName) throws PlatformException
Platform
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);
prepareNextValProcedureStatement
in interface Platform
prepareNextValProcedureStatement
in class PlatformDefaultImpl
PlatformException
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