Package org.apache.cayenne.dba.sqlserver
Class SQLServerAdapter
- java.lang.Object
-
- org.apache.cayenne.dba.JdbcAdapter
-
- org.apache.cayenne.dba.sybase.SybaseAdapter
-
- org.apache.cayenne.dba.sqlserver.SQLServerAdapter
-
- All Implemented Interfaces:
DbAdapter
public class SQLServerAdapter extends SybaseAdapter
Cayenne DbAdapter implementation for Microsoft SQL Server engine.
Microsoft Driver Settings
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.SQLServerDriverNote 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 Driver Settings
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- Since:
- 1.1
-
-
Field Summary
Fields Modifier and Type Field Description static StringTRIM_FUNCTION-
Fields inherited from class org.apache.cayenne.dba.JdbcAdapter
batchQueryBuilderFactory, caseInsensitiveCollations, ejbqlTranslatorFactory, extendedTypes, logger, quotingStrategy, resourceLocator, supportsBatchUpdates, supportsGeneratedKeys, supportsUniqueConstraints, typesHandler
-
-
Constructor Summary
Constructors Constructor Description SQLServerAdapter(RuntimeProperties runtimeProperties, List<ExtendedType> defaultExtendedTypes, List<ExtendedType> userExtendedTypes, List<ExtendedTypeFactory> extendedTypeFactories, ResourceLocator resourceLocator, ValueObjectTypeRegistry valueObjectTypeRegistry)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description SQLActiongetAction(Query query, DataNode node)Uses SQLServerActionBuilder to create the right action.QualifierTranslatorgetQualifierTranslator(QueryAssembler queryAssembler)Returns a trimming translator.SelectTranslatorgetSelectTranslator(SelectQuery<?> query, EntityResolver entityResolver)Returns a SelectTranslator that works with the adapter target database.List<String>getSystemSchemas()-
Methods inherited from class org.apache.cayenne.dba.sybase.SybaseAdapter
bindParameter, configureExtendedTypes, createEJBQLTranslatorFactory, createPkGenerator, createQuotingStrategy, createTableAppendColumn, getBatchTerminator
-
Methods inherited from class org.apache.cayenne.dba.JdbcAdapter
buildAttribute, createFkConstraint, createTable, createTableAppendPKClause, createUniqueConstraint, dropTableStatements, externalTypesForJdbcType, findResource, getEjbqlTranslatorFactory, getExtendedTypes, getJdbcEventLogger, getPkGenerator, getQuotingStrategy, getSystemCatalogs, getType, initExtendedTypes, setEjbqlTranslatorFactory, setPkGenerator, setSupportsBatchUpdates, setSupportsGeneratedKeys, setSupportsUniqueConstraints, sizeAndPrecision, supportsBatchUpdates, supportsCatalogsOnReverseEngineering, supportsGeneratedKeys, supportsUniqueConstraints, tableTypeForTable, tableTypeForView, typeSupportsLength, unwrap
-
-
-
-
Field Detail
-
TRIM_FUNCTION
public static final String TRIM_FUNCTION
- See Also:
- Constant Field Values
-
-
Constructor Detail
-
SQLServerAdapter
public SQLServerAdapter(RuntimeProperties runtimeProperties, List<ExtendedType> defaultExtendedTypes, List<ExtendedType> userExtendedTypes, List<ExtendedTypeFactory> extendedTypeFactories, ResourceLocator resourceLocator, ValueObjectTypeRegistry valueObjectTypeRegistry)
-
-
Method Detail
-
getSelectTranslator
public SelectTranslator getSelectTranslator(SelectQuery<?> query, EntityResolver entityResolver)
Description copied from interface:DbAdapterReturns a SelectTranslator that works with the adapter target database.- Specified by:
getSelectTranslatorin interfaceDbAdapter- Overrides:
getSelectTranslatorin classSybaseAdapter- Since:
- 4.0
-
getAction
public SQLAction getAction(Query query, DataNode node)
Uses SQLServerActionBuilder to create the right action.- Specified by:
getActionin interfaceDbAdapter- Overrides:
getActionin classJdbcAdapter- Since:
- 1.2
-
getQualifierTranslator
public QualifierTranslator getQualifierTranslator(QueryAssembler queryAssembler)
Returns a trimming translator.- Specified by:
getQualifierTranslatorin interfaceDbAdapter- Overrides:
getQualifierTranslatorin classSybaseAdapter
-
getSystemSchemas
public List<String> getSystemSchemas()
- Specified by:
getSystemSchemasin interfaceDbAdapter- Overrides:
getSystemSchemasin classJdbcAdapter- Returns:
- list of system schemas
-
-