| <!DOCTYPE HTML> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (11.0.10) on Mon Dec 05 10:27:04 MSK 2022 --> |
| <title>SQLServerAdapter (cayenne-doc: Cayenne Documentation 4.2.RC2 API)</title> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <meta name="dc.created" content="2022-12-05"> |
| <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style"> |
| <link rel="stylesheet" type="text/css" href="../../../../../jquery/jquery-ui.css" title="Style"> |
| <script type="text/javascript" src="../../../../../script.js"></script> |
| <script type="text/javascript" src="../../../../../jquery/jszip/dist/jszip.min.js"></script> |
| <script type="text/javascript" src="../../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script> |
| <!--[if IE]> |
| <script type="text/javascript" src="../../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script> |
| <![endif]--> |
| <script type="text/javascript" src="../../../../../jquery/jquery-3.5.1.js"></script> |
| <script type="text/javascript" src="../../../../../jquery/jquery-ui.js"></script> |
| </head> |
| <body> |
| <script type="text/javascript"><!-- |
| try { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="SQLServerAdapter (cayenne-doc: Cayenne Documentation 4.2.RC2 API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var data = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10}; |
| var tabs = {65535:["t0","All Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]}; |
| var altColor = "altColor"; |
| var rowColor = "rowColor"; |
| var tableTab = "tableTab"; |
| var activeTableTab = "activeTableTab"; |
| var pathtoroot = "../../../../../"; |
| var useModuleDirectories = false; |
| loadScripts(document, 'script');</script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <header role="banner"> |
| <nav role="navigation"> |
| <div class="fixedNav"> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a id="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a id="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../index.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/SQLServerAdapter.html">Use</a></li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../help-doc.html">Help</a></li> |
| </ul> |
| <div class="aboutLanguage"><a href="http://cayenne.apache.org" target="top">Apache Cayenne</a></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../../allclasses.html">All Classes</a></li> |
| </ul> |
| <ul class="navListSearch"> |
| <li><label for="search">SEARCH:</label> |
| <input type="text" id="search" value="search" disabled="disabled"> |
| <input type="reset" id="reset" value="reset" disabled="disabled"> |
| </li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_top"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a id="skip.navbar.top"> |
| <!-- --> |
| </a></div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| </div> |
| <div class="navPadding"> </div> |
| <script type="text/javascript"><!-- |
| $('.navPadding').css('padding-top', $('.fixedNav').css("height")); |
| //--> |
| </script> |
| </nav> |
| </header> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <main role="main"> |
| <div class="header"> |
| <div class="subTitle"><span class="packageLabelInType">Package</span> <a href="package-summary.html">org.apache.cayenne.dba.sqlserver</a></div> |
| <h2 title="Class SQLServerAdapter" class="title">Class SQLServerAdapter</h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">java.lang.Object</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="../JdbcAdapter.html" title="class in org.apache.cayenne.dba">org.apache.cayenne.dba.JdbcAdapter</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="../sybase/SybaseAdapter.html" title="class in org.apache.cayenne.dba.sybase">org.apache.cayenne.dba.sybase.SybaseAdapter</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li>org.apache.cayenne.dba.sqlserver.SQLServerAdapter</li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <dl> |
| <dt>All Implemented Interfaces:</dt> |
| <dd><code><a href="../DbAdapter.html" title="interface in org.apache.cayenne.dba">DbAdapter</a></code></dd> |
| </dl> |
| <hr> |
| <pre>public class <span class="typeNameLabel">SQLServerAdapter</span> |
| extends <a href="../sybase/SybaseAdapter.html" title="class in org.apache.cayenne.dba.sybase">SybaseAdapter</a></pre> |
| <div class="block"><p> |
| Cayenne DbAdapter implementation for <a href="http://www.microsoft.com/sql/">Microsoft SQL Server </a> engine. |
| </p> |
| <h3>Microsoft Driver Settings</h3> |
| <p> |
| Sample connection settings to use with MS SQL Server are shown below: |
| |
| <pre> |
| 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 |
| </pre> |
| <p> |
| <i>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"). </i> |
| </p> |
| <h3>jTDS Driver Settings</h3> |
| <p> |
| jTDS is an open source driver that can be downloaded from <a href="http://jtds.sourceforge.net">http://jtds.sourceforge.net </a>. It supports |
| both SQLServer and Sybase. Sample SQLServer settings are the following: |
| </p> |
| |
| <pre> |
| 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 |
| </pre></div> |
| <dl> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>1.1</dd> |
| </dl> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Fields</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colSecond" scope="col">Field</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#TRIM_FUNCTION">TRIM_FUNCTION</a></span></code></th> |
| <td class="colLast"> |
| <div class="block"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2 unused</div> |
| </div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a id="fields.inherited.from.class.org.apache.cayenne.dba.JdbcAdapter"> |
| <!-- --> |
| </a> |
| <h3>Fields inherited from class org.apache.cayenne.dba.<a href="../JdbcAdapter.html" title="class in org.apache.cayenne.dba">JdbcAdapter</a></h3> |
| <code><a href="../JdbcAdapter.html#batchQueryBuilderFactory">batchQueryBuilderFactory</a>, <a href="../JdbcAdapter.html#caseInsensitiveCollations">caseInsensitiveCollations</a>, <a href="../JdbcAdapter.html#ejbqlTranslatorFactory">ejbqlTranslatorFactory</a>, <a href="../JdbcAdapter.html#extendedTypes">extendedTypes</a>, <a href="../JdbcAdapter.html#logger">logger</a>, <a href="../JdbcAdapter.html#quotingStrategy">quotingStrategy</a>, <a href="../JdbcAdapter.html#resourceLocator">resourceLocator</a>, <a href="../JdbcAdapter.html#supportsBatchUpdates">supportsBatchUpdates</a>, <a href="../JdbcAdapter.html#supportsGeneratedKeys">supportsGeneratedKeys</a>, <a href="../JdbcAdapter.html#supportsUniqueConstraints">supportsUniqueConstraints</a>, <a href="../JdbcAdapter.html#typesHandler">typesHandler</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="constructor.summary"> |
| <!-- --> |
| </a> |
| <h3>Constructor Summary</h3> |
| <table class="memberSummary"> |
| <caption><span>Constructors</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Constructor</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr class="altColor"> |
| <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E(org.apache.cayenne.configuration.RuntimeProperties,java.util.List,java.util.List,java.util.List,org.apache.cayenne.resource.ResourceLocator,org.apache.cayenne.access.types.ValueObjectTypeRegistry)">SQLServerAdapter</a></span>​(<a href="../../configuration/RuntimeProperties.html" title="interface in org.apache.cayenne.configuration">RuntimeProperties</a> runtimeProperties, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="../../access/types/ExtendedType.html" title="interface in org.apache.cayenne.access.types">ExtendedType</a>> defaultExtendedTypes, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="../../access/types/ExtendedType.html" title="interface in org.apache.cayenne.access.types">ExtendedType</a>> userExtendedTypes, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="../../access/types/ExtendedTypeFactory.html" title="interface in org.apache.cayenne.access.types">ExtendedTypeFactory</a>> extendedTypeFactories, |
| <a href="../../resource/ResourceLocator.html" title="interface in org.apache.cayenne.resource">ResourceLocator</a> resourceLocator, |
| <a href="../../access/types/ValueObjectTypeRegistry.html" title="interface in org.apache.cayenne.access.types">ValueObjectTypeRegistry</a> valueObjectTypeRegistry)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| </section> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="method.summary"> |
| <!-- --> |
| </a> |
| <h3>Method Summary</h3> |
| <table class="memberSummary"> |
| <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colSecond" scope="col">Method</th> |
| <th class="colLast" scope="col">Description</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code><a href="../../query/SQLAction.html" title="interface in org.apache.cayenne.query">SQLAction</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getAction(org.apache.cayenne.query.Query,org.apache.cayenne.access.DataNode)">getAction</a></span>​(<a href="../../query/Query.html" title="interface in org.apache.cayenne.query">Query</a> query, |
| <a href="../../access/DataNode.html" title="class in org.apache.cayenne.access">DataNode</a> node)</code></th> |
| <td class="colLast"> |
| <div class="block">Uses SQLServerActionBuilder to create the right action.</div> |
| </td> |
| </tr> |
| <tr id="i1" class="rowColor"> |
| <td class="colFirst"><code><a href="../../access/sqlbuilder/sqltree/SQLTreeProcessor.html" title="interface in org.apache.cayenne.access.sqlbuilder.sqltree">SQLTreeProcessor</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getSqlTreeProcessor()">getSqlTreeProcessor</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i2" class="altColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getSystemCatalogs()">getSystemCatalogs</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i3" class="rowColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getSystemSchemas()">getSystemSchemas</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i4" class="altColor"> |
| <td class="colFirst"><code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang" class="externalLink">Integer</a></code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getVersion()">getVersion</a></span>()</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i5" class="rowColor"> |
| <td class="colFirst"><code>void</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#setVersion(java.lang.Integer)">setVersion</a></span>​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang" class="externalLink">Integer</a> version)</code></th> |
| <td class="colLast"> </td> |
| </tr> |
| <tr id="i6" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#supportsGeneratedKeysForBatchInserts()">supportsGeneratedKeysForBatchInserts</a></span>()</code></th> |
| <td class="colLast"> |
| <div class="block">Not supported, see: <a href="https://github.com/microsoft/mssql-jdbc/issues/245">mssql-jdbc #245</a></div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.dba.sybase.SybaseAdapter"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.cayenne.dba.sybase.<a href="../sybase/SybaseAdapter.html" title="class in org.apache.cayenne.dba.sybase">SybaseAdapter</a></h3> |
| <code><a href="../sybase/SybaseAdapter.html#bindParameter(java.sql.PreparedStatement,org.apache.cayenne.access.translator.ParameterBinding)">bindParameter</a>, <a href="../sybase/SybaseAdapter.html#configureExtendedTypes(org.apache.cayenne.access.types.ExtendedTypeMap)">configureExtendedTypes</a>, <a href="../sybase/SybaseAdapter.html#createEJBQLTranslatorFactory()">createEJBQLTranslatorFactory</a>, <a href="../sybase/SybaseAdapter.html#createPkGenerator()">createPkGenerator</a>, <a href="../sybase/SybaseAdapter.html#createQuotingStrategy()">createQuotingStrategy</a>, <a href="../sybase/SybaseAdapter.html#createTableAppendColumn(java.lang.StringBuffer,org.apache.cayenne.map.DbAttribute)">createTableAppendColumn</a>, <a href="../sybase/SybaseAdapter.html#getBatchTerminator()">getBatchTerminator</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.org.apache.cayenne.dba.JdbcAdapter"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.cayenne.dba.<a href="../JdbcAdapter.html" title="class in org.apache.cayenne.dba">JdbcAdapter</a></h3> |
| <code><a href="../JdbcAdapter.html#buildAttribute(java.lang.String,java.lang.String,int,int,int,boolean)">buildAttribute</a>, <a href="../JdbcAdapter.html#createFkConstraint(org.apache.cayenne.map.DbRelationship)">createFkConstraint</a>, <a href="../JdbcAdapter.html#createTable(org.apache.cayenne.map.DbEntity)">createTable</a>, <a href="../JdbcAdapter.html#createTableAppendPKClause(java.lang.StringBuffer,org.apache.cayenne.map.DbEntity)">createTableAppendPKClause</a>, <a href="../JdbcAdapter.html#createUniqueConstraint(org.apache.cayenne.map.DbEntity,java.util.Collection)">createUniqueConstraint</a>, <a href="../JdbcAdapter.html#dropTableStatements(org.apache.cayenne.map.DbEntity)">dropTableStatements</a>, <a href="../JdbcAdapter.html#externalTypesForJdbcType(int)">externalTypesForJdbcType</a>, <a href="../JdbcAdapter.html#findResource(java.lang.String)">findResource</a>, <a href="../JdbcAdapter.html#getEjbqlTranslatorFactory()">getEjbqlTranslatorFactory</a>, <a href="../JdbcAdapter.html#getExtendedTypes()">getExtendedTypes</a>, <a href="../JdbcAdapter.html#getJdbcEventLogger()">getJdbcEventLogger</a>, <a href="../JdbcAdapter.html#getPkGenerator()">getPkGenerator</a>, <a href="../JdbcAdapter.html#getQuotingStrategy()">getQuotingStrategy</a>, <a href="../JdbcAdapter.html#getSelectTranslator(org.apache.cayenne.query.FluentSelect,org.apache.cayenne.map.EntityResolver)">getSelectTranslator</a>, <a href="../JdbcAdapter.html#getSelectTranslator(org.apache.cayenne.query.SelectQuery,org.apache.cayenne.map.EntityResolver)">getSelectTranslator</a>, <a href="../JdbcAdapter.html#getType(org.apache.cayenne.dba.DbAdapter,org.apache.cayenne.map.DbAttribute)">getType</a>, <a href="../JdbcAdapter.html#initExtendedTypes(java.util.List,java.util.List,java.util.List,org.apache.cayenne.access.types.ValueObjectTypeRegistry)">initExtendedTypes</a>, <a href="../JdbcAdapter.html#setEjbqlTranslatorFactory(org.apache.cayenne.access.translator.ejbql.EJBQLTranslatorFactory)">setEjbqlTranslatorFactory</a>, <a href="../JdbcAdapter.html#setPkGenerator(org.apache.cayenne.dba.PkGenerator)">setPkGenerator</a>, <a href="../JdbcAdapter.html#setSupportsBatchUpdates(boolean)">setSupportsBatchUpdates</a>, <a href="../JdbcAdapter.html#setSupportsGeneratedKeys(boolean)">setSupportsGeneratedKeys</a>, <a href="../JdbcAdapter.html#setSupportsUniqueConstraints(boolean)">setSupportsUniqueConstraints</a>, <a href="../JdbcAdapter.html#sizeAndPrecision(org.apache.cayenne.dba.DbAdapter,org.apache.cayenne.map.DbAttribute)">sizeAndPrecision</a>, <a href="../JdbcAdapter.html#supportsBatchUpdates()">supportsBatchUpdates</a>, <a href="../JdbcAdapter.html#supportsCatalogsOnReverseEngineering()">supportsCatalogsOnReverseEngineering</a>, <a href="../JdbcAdapter.html#supportsGeneratedKeys()">supportsGeneratedKeys</a>, <a href="../JdbcAdapter.html#supportsUniqueConstraints()">supportsUniqueConstraints</a>, <a href="../JdbcAdapter.html#tableTypeForTable()">tableTypeForTable</a>, <a href="../JdbcAdapter.html#tableTypeForView()">tableTypeForView</a>, <a href="../JdbcAdapter.html#typeSupportsLength(int)">typeSupportsLength</a>, <a href="../JdbcAdapter.html#unwrap()">unwrap</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a id="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang" class="externalLink">Object</a></h3> |
| <code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#clone()" title="class or interface in java.lang" class="externalLink">clone</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#equals(java.lang.Object)" title="class or interface in java.lang" class="externalLink">equals</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#finalize()" title="class or interface in java.lang" class="externalLink">finalize</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#getClass()" title="class or interface in java.lang" class="externalLink">getClass</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#hashCode()" title="class or interface in java.lang" class="externalLink">hashCode</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notify()" title="class or interface in java.lang" class="externalLink">notify</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notifyAll()" title="class or interface in java.lang" class="externalLink">notifyAll</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#toString()" title="class or interface in java.lang" class="externalLink">toString</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait()" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait(long)" title="class or interface in java.lang" class="externalLink">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait(long,int)" title="class or interface in java.lang" class="externalLink">wait</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ============ FIELD DETAIL =========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="field.detail"> |
| <!-- --> |
| </a> |
| <h3>Field Detail</h3> |
| <a id="TRIM_FUNCTION"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>TRIM_FUNCTION</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="class or interface in java.lang" class="externalLink">@Deprecated</a> |
| public static final <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a> TRIM_FUNCTION</pre> |
| <div class="deprecationBlock"><span class="deprecatedLabel">Deprecated.</span> |
| <div class="deprecationComment">since 4.2 unused</div> |
| </div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="../../../../../constant-values.html#org.apache.cayenne.dba.sqlserver.SQLServerAdapter.TRIM_FUNCTION">Constant Field Values</a></dd> |
| </dl> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ========= CONSTRUCTOR DETAIL ======== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="constructor.detail"> |
| <!-- --> |
| </a> |
| <h3>Constructor Detail</h3> |
| <a id="<init>(org.apache.cayenne.configuration.RuntimeProperties,java.util.List,java.util.List,java.util.List,org.apache.cayenne.resource.ResourceLocator,org.apache.cayenne.access.types.ValueObjectTypeRegistry)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>SQLServerAdapter</h4> |
| <pre>public SQLServerAdapter​(<a href="../../configuration/RuntimeProperties.html" title="interface in org.apache.cayenne.configuration">RuntimeProperties</a> runtimeProperties, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="../../access/types/ExtendedType.html" title="interface in org.apache.cayenne.access.types">ExtendedType</a>> defaultExtendedTypes, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="../../access/types/ExtendedType.html" title="interface in org.apache.cayenne.access.types">ExtendedType</a>> userExtendedTypes, |
| <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="../../access/types/ExtendedTypeFactory.html" title="interface in org.apache.cayenne.access.types">ExtendedTypeFactory</a>> extendedTypeFactories, |
| <a href="../../resource/ResourceLocator.html" title="interface in org.apache.cayenne.resource">ResourceLocator</a> resourceLocator, |
| <a href="../../access/types/ValueObjectTypeRegistry.html" title="interface in org.apache.cayenne.access.types">ValueObjectTypeRegistry</a> valueObjectTypeRegistry)</pre> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| <!-- ============ METHOD DETAIL ========== --> |
| <section role="region"> |
| <ul class="blockList"> |
| <li class="blockList"><a id="method.detail"> |
| <!-- --> |
| </a> |
| <h3>Method Detail</h3> |
| <a id="supportsGeneratedKeysForBatchInserts()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>supportsGeneratedKeysForBatchInserts</h4> |
| <pre class="methodSignature">public boolean supportsGeneratedKeysForBatchInserts()</pre> |
| <div class="block">Not supported, see: <a href="https://github.com/microsoft/mssql-jdbc/issues/245">mssql-jdbc #245</a></div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="../DbAdapter.html#supportsGeneratedKeys()"><code>DbAdapter.supportsGeneratedKeys()</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="getSqlTreeProcessor()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getSqlTreeProcessor</h4> |
| <pre class="methodSignature">public <a href="../../access/sqlbuilder/sqltree/SQLTreeProcessor.html" title="interface in org.apache.cayenne.access.sqlbuilder.sqltree">SQLTreeProcessor</a> getSqlTreeProcessor()</pre> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> |
| <dd><code><a href="../DbAdapter.html#getSqlTreeProcessor()">getSqlTreeProcessor</a></code> in interface <code><a href="../DbAdapter.html" title="interface in org.apache.cayenne.dba">DbAdapter</a></code></dd> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../sybase/SybaseAdapter.html#getSqlTreeProcessor()">getSqlTreeProcessor</a></code> in class <code><a href="../sybase/SybaseAdapter.html" title="class in org.apache.cayenne.dba.sybase">SybaseAdapter</a></code></dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd><a href="../../access/sqlbuilder/sqltree/SQLTreeProcessor.html" title="interface in org.apache.cayenne.access.sqlbuilder.sqltree"><code>SQLTreeProcessor</code></a> that can adjust SQL tree to specific database flavour</dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="getAction(org.apache.cayenne.query.Query,org.apache.cayenne.access.DataNode)"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getAction</h4> |
| <pre class="methodSignature">public <a href="../../query/SQLAction.html" title="interface in org.apache.cayenne.query">SQLAction</a> getAction​(<a href="../../query/Query.html" title="interface in org.apache.cayenne.query">Query</a> query, |
| <a href="../../access/DataNode.html" title="class in org.apache.cayenne.access">DataNode</a> node)</pre> |
| <div class="block">Uses SQLServerActionBuilder to create the right action.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> |
| <dd><code><a href="../DbAdapter.html#getAction(org.apache.cayenne.query.Query,org.apache.cayenne.access.DataNode)">getAction</a></code> in interface <code><a href="../DbAdapter.html" title="interface in org.apache.cayenne.dba">DbAdapter</a></code></dd> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../JdbcAdapter.html#getAction(org.apache.cayenne.query.Query,org.apache.cayenne.access.DataNode)">getAction</a></code> in class <code><a href="../JdbcAdapter.html" title="class in org.apache.cayenne.dba">JdbcAdapter</a></code></dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>1.2</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="getSystemCatalogs()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getSystemCatalogs</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>> getSystemCatalogs()</pre> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> |
| <dd><code><a href="../DbAdapter.html#getSystemCatalogs()">getSystemCatalogs</a></code> in interface <code><a href="../DbAdapter.html" title="interface in org.apache.cayenne.dba">DbAdapter</a></code></dd> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../JdbcAdapter.html#getSystemCatalogs()">getSystemCatalogs</a></code> in class <code><a href="../JdbcAdapter.html" title="class in org.apache.cayenne.dba">JdbcAdapter</a></code></dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>list of system catalogs</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="getSystemSchemas()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getSystemSchemas</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util" class="externalLink">List</a><<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang" class="externalLink">String</a>> getSystemSchemas()</pre> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Specified by:</span></dt> |
| <dd><code><a href="../DbAdapter.html#getSystemSchemas()">getSystemSchemas</a></code> in interface <code><a href="../DbAdapter.html" title="interface in org.apache.cayenne.dba">DbAdapter</a></code></dd> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../JdbcAdapter.html#getSystemSchemas()">getSystemSchemas</a></code> in class <code><a href="../JdbcAdapter.html" title="class in org.apache.cayenne.dba">JdbcAdapter</a></code></dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>list of system schemas</dd> |
| </dl> |
| </li> |
| </ul> |
| <a id="getVersion()"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getVersion</h4> |
| <pre class="methodSignature">public <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang" class="externalLink">Integer</a> getVersion()</pre> |
| </li> |
| </ul> |
| <a id="setVersion(java.lang.Integer)"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>setVersion</h4> |
| <pre class="methodSignature">public void setVersion​(<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang" class="externalLink">Integer</a> version)</pre> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>version</code> - of the server as provided by the JDBC driver</dd> |
| <dt><span class="simpleTagLabel">Since:</span></dt> |
| <dd>4.2</dd> |
| </dl> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </section> |
| </li> |
| </ul> |
| </div> |
| </div> |
| </main> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <footer role="contentinfo"> |
| <nav role="navigation"> |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <div class="bottomNav"><a id="navbar.bottom"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div> |
| <a id="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../index.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/SQLServerAdapter.html">Use</a></li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../help-doc.html">Help</a></li> |
| </ul> |
| <div class="aboutLanguage"><a href="http://cayenne.apache.org" target="top">Apache Cayenne</a></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../../allclasses.html">All Classes</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_bottom"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a id="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| </nav> |
| <p class="legalCopy"><small>Copyright © 2001–2022 <a href="https://cayenne.apache.org/">Apache Cayenne</a>. All rights reserved.</small></p> |
| </footer> |
| </body> |
| </html> |