Author: reschke
Date: Tue Mar 19 12:51:03 2019
New Revision: 1855822
URL: http://svn.apache.org/viewvc?rev=1855822&view=rev
Log:
OAK-8083: RDB*Store: add SQLServer specific documentation (ported to 1.10)
Modified:
jackrabbit/oak/branches/1.10/ (props changed)
jackrabbit/oak/branches/1.10/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
Propchange: jackrabbit/oak/branches/1.10/
------------------------------------------------------------------------------
--- svn:mergeinfo (original)
+++ svn:mergeinfo Tue Mar 19 12:51:03 2019
@@ -1,3 +1,3 @@
/jackrabbit/oak/branches/1.0:1665962
-/jackrabbit/oak/trunk:1850874,1850882,1851236,1851253,1851451,1851533-1851535,1851619,1852052,1852084,1852120,1852451,1852492-1852493,1852528,1852582,1852584,1852601,1852920,1853141,1853229,1853393,1853429,1853433,1853441,1853866,1853868,1853870,1853893,1853969,1853997,1854034,1854044,1854058,1854113,1854373,1854377,1854380,1854385,1854401,1854403,1854455,1854461-1854462,1854466,1854468,1854515,1854533,1854701,1854773,1854827,1854848,1854859,1854930,1854990-1854991,1855032,1855221,1855477-1855478
+/jackrabbit/oak/trunk:1850874,1850882,1851236,1851253,1851451,1851533-1851535,1851619,1852052,1852084,1852120,1852451,1852492-1852493,1852528,1852582,1852584,1852601,1852920,1853141,1853229,1853393,1853429,1853433,1853441,1853866,1853868,1853870,1853893,1853969,1853997,1854034,1854044,1854058,1854113,1854373,1854377,1854380,1854385,1854401,1854403,1854455,1854461-1854462,1854466,1854468,1854515,1854533,1854701,1854773-1854774,1854827,1854848,1854859,1854930,1854990-1854991,1855032,1855221,1855477-1855478
/jackrabbit/trunk:1345480
Modified:
jackrabbit/oak/branches/1.10/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
URL:
http://svn.apache.org/viewvc/jackrabbit/oak/branches/1.10/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md?rev=1855822&r1=1855821&r2=1855822&view=diff
==============================================================================
---
jackrabbit/oak/branches/1.10/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
(original)
+++
jackrabbit/oak/branches/1.10/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
Tue Mar 19 12:51:03 2019
@@ -124,6 +124,20 @@ upon startup. For example:
~~~
+### <a name="database-creation-sqlserver"></a> SQL Server
+
+Creating a database called `OAK`:
+~~~
+create database OAK;
+~~~
+
+To verify, check that INFO level log message written by `RDBDocumentStore`
+upon startup. For example:
+
+~~~
+16:59:12.726 INFO [main] RDBDocumentStore.java:1067 RDBDocumentStore
(SNAPSHOT) instantiated for database Microsoft SQL Server 13.00.5081 (13.0),
using driver: Microsoft JDBC Driver 7.2 for SQL Server 7.2.1.0 (7.2),
connecting to:
jdbc:sqlserver://localhost:1433;useBulkCopyForBatchInsert=false;cancelQueryTimeout=-1;sslProtocol=TLS;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=0;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=OAK;colu
mnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL
Server;applicationIntent=readwrite;, properties:
{collation_name=Latin1_General_CI_AS}, transaction isolation level:
TRANSACTION_READ_COMMITTED (2), .: ID varbinary(512), MODIFIED bigint,
HASBINARY smallint, DELETEDONCE smallint, MODCOUNT bigint, CMODCOUNT bigint,
DSIZE bigint, VERSION smallint, SDTYPE smallint, SDMAXREVTIME bigint, DATA
nvarchar(4000), BDATA varbinary(2147483647) /* {bigint=-5, nvarchar=-9,
smallint=5, varbinary=-3} */ /* index NODES.NODES_MOD on dbo.NODES (MODIFIED
ASC) other (#0, p0), unique index NODES.NODES_PK on dbo.NODES (ID ASC)
clustered (#0, p0), index NODES.NODES_SDM on dbo.NODES (SDMAXREVTIME ASC) other
(#0, p0), index NODES.NODES_SDT on dbo.NODES (SDTYPE ASC) other (#0, p0), index
NODES.NODES_VSN on dbo.NODES (VERSION ASC) other (#0, p0) */
+~~~
+
## <a name="table-creation"></a> Table Creation
