public class SQLServerAdapter extends SybaseAdapter
Cayenne DbAdapter implementation for Microsoft SQL Server engine.
Sample connection settings to use with MS SQL Server are shown below:
sqlserver.jdbc.username = test
sqlserver.jdbc.password = secret
sqlserver.jdbc.url = jdbc:sqlserver://192.168.0.65;databaseName=cayenne;SelectMethod=cursor
sqlserver.jdbc.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
Note on case-sensitive LIKE: if your application requires case-sensitive LIKE support, ask your DBA to configure the database to use a case-senstitive collation (one with "CS" in symbolic collation name instead of "CI", e.g. "SQL_Latin1_general_CP1_CS_AS").
jTDS is an open source driver that can be downloaded from http://jtds.sourceforge.net . It supports both SQLServer and Sybase. Sample SQLServer settings are the following:
sqlserver.jdbc.username = test
sqlserver.jdbc.password = secret
sqlserver.jdbc.url = jdbc:jtds:sqlserver://192.168.0.65/cayenne
sqlserver.jdbc.driver = net.sourceforge.jtds.jdbc.Driver
| Modifier and Type | Field and Description |
|---|---|
static String |
TRIM_FUNCTION |
batchQueryBuilderFactory, caseInsensitiveCollations, ejbqlTranslatorFactory, extendedTypes, logger, quotingStrategy, resourceLocator, supportsBatchUpdates, supportsGeneratedKeys, supportsUniqueConstraints, typesHandler| Constructor and Description |
|---|
SQLServerAdapter(RuntimeProperties runtimeProperties,
List<ExtendedType> defaultExtendedTypes,
List<ExtendedType> userExtendedTypes,
List<ExtendedTypeFactory> extendedTypeFactories,
ResourceLocator resourceLocator,
ValueObjectTypeRegistry valueObjectTypeRegistry) |
| Modifier and Type | Method and Description |
|---|---|
void |
createTableAppendColumn(StringBuffer sqlBuffer,
DbAttribute column)
Overrides super implementation to correctly set up identity columns.
|
SQLAction |
getAction(Query query,
DataNode node)
Uses SQLServerActionBuilder to create the right action.
|
QualifierTranslator |
getQualifierTranslator(QueryAssembler queryAssembler)
Returns a trimming translator.
|
SelectTranslator |
getSelectTranslator(SelectQuery<?> query,
EntityResolver entityResolver)
Returns a SelectTranslator that works with the adapter target database.
|
bindParameter, configureExtendedTypes, createEJBQLTranslatorFactory, createPkGenerator, createQuotingStrategy, getBatchTerminatorbuildAttribute, createFkConstraint, createTable, createTableAppendPKClause, createUniqueConstraint, dropTableStatements, externalTypesForJdbcType, findResource, getBatchQueryBuilderFactory, getEjbqlTranslatorFactory, getExtendedTypes, getJdbcEventLogger, getPkGenerator, getQuotingStrategy, getQuotingStrategy, getType, initExtendedTypes, setBatchQueryBuilderFactory, setEjbqlTranslatorFactory, setPkGenerator, setSupportsBatchUpdates, setSupportsGeneratedKeys, setSupportsUniqueConstraints, sizeAndPrecision, supportsBatchUpdates, supportsCatalogsOnReverseEngineering, supportsGeneratedKeys, supportsUniqueConstraints, tableTypeForTable, tableTypeForView, typeSupportsLength, unwrappublic static final String TRIM_FUNCTION
public SQLServerAdapter(RuntimeProperties runtimeProperties, List<ExtendedType> defaultExtendedTypes, List<ExtendedType> userExtendedTypes, List<ExtendedTypeFactory> extendedTypeFactories, ResourceLocator resourceLocator, ValueObjectTypeRegistry valueObjectTypeRegistry)
public SelectTranslator getSelectTranslator(SelectQuery<?> query, EntityResolver entityResolver)
DbAdaptergetSelectTranslator in interface DbAdaptergetSelectTranslator in class SybaseAdapterpublic SQLAction getAction(Query query, DataNode node)
getAction in interface DbAdaptergetAction in class JdbcAdapterpublic QualifierTranslator getQualifierTranslator(QueryAssembler queryAssembler)
getQualifierTranslator in interface DbAdaptergetQualifierTranslator in class SybaseAdapterpublic void createTableAppendColumn(StringBuffer sqlBuffer, DbAttribute column)
createTableAppendColumn in interface DbAdaptercreateTableAppendColumn in class JdbcAdaptersqlBuffer - the StringBuffer to append the column type tocolumn - the DbAttribute defining the column to append type forCopyright © 2001–2023 Apache Cayenne. All rights reserved.