Author: reschke
Date: Fri Jul 26 09:54:32 2019
New Revision: 1863796
URL: http://svn.apache.org/viewvc?rev=1863796&view=rev
Log:
OAK-8150: RDB*Store: add Oracle specific documentation (merged r1855905 and
r1863540 into 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 Fri Jul 26 09:54:32 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,1852135,1852451,1852492-1852493,1852528,1852582,1852584,1852601,1852920,1853083,1853141,1853229,1853393,1853429,1853433,1853441,1853866,1853868,1853870,1853893,1853969,1853997,1854034,1854044,1854055,1854058,1854113,1854373,1854377,1854380,1854385,1854401,1854403,1854455,1854461-1854462,1854466,1854468,1854515,1854533,1854539,1854701,1854773-1854774,1854827,1854848,1854859,1854930,1854990-1854991,1855032,1855221,1855477-1855478,1855776,1855993,1856049,1856056,1856538,1856545,1857000,1857010,1857104,1857159,1857212,1857221,1857238,1857242,1857247,1857253,1857294,1857314,1857332,1857463,1857480,1857577,1857589,1857592,1857627,1857634-1857635,1857638,1857640,1857687,1857936,1858032,1858053,1858123,1858139,1858385,1858424,1858571,1858578,1858810,1858926,1858931,1859020,1859231,1859292,1859294,1859350-1859351,1859359,1859365,1859533,1859609,1859612,1859619,1859711,1859716,1859772
,1859776,1859780,1859843,1859854,1859881,1860120,1860131,1860137,1860202,1860278,1860328,1860330,1860355,1860393,1860442,1860548,1860564-1860565,1860931,1861114,1861270,1861626,1861743,1862044,1862093,1862448,1862531,1862728,1862881
+/jackrabbit/oak/trunk:1850874,1850882,1851236,1851253,1851451,1851533-1851535,1851619,1852052,1852084,1852120,1852135,1852451,1852492-1852493,1852528,1852582,1852584,1852601,1852920,1853083,1853141,1853229,1853393,1853429,1853433,1853441,1853866,1853868,1853870,1853893,1853969,1853997,1854034,1854044,1854055,1854058,1854113,1854373,1854377,1854380,1854385,1854401,1854403,1854455,1854461-1854462,1854466,1854468,1854515,1854533,1854539,1854701,1854773-1854774,1854827,1854848,1854859,1854930,1854990-1854991,1855032,1855221,1855477-1855478,1855776,1855905,1855993,1856049,1856056,1856538,1856545,1857000,1857010,1857104,1857159,1857212,1857221,1857238,1857242,1857247,1857253,1857294,1857314,1857332,1857463,1857480,1857577,1857589,1857592,1857627,1857634-1857635,1857638,1857640,1857687,1857936,1858032,1858053,1858123,1858139,1858385,1858424,1858571,1858578,1858810,1858926,1858931,1859020,1859231,1859292,1859294,1859350-1859351,1859359,1859365,1859533,1859609,1859612,1859619,1859711,1859716
,1859772,1859776,1859780,1859843,1859854,1859881,1860120,1860131,1860137,1860202,1860278,1860328,1860330,1860355,1860393,1860442,1860548,1860564-1860565,1860931,1861114,1861270,1861626,1861743,1862044,1862093,1862448,1862531,1862728,1862881,1863540
/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=1863796&r1=1863795&r2=1863796&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
Fri Jul 26 09:54:32 2019
@@ -83,7 +83,7 @@ Creating a database called `OAK`:
create database oak USING CODESET UTF-8 TERRITORY DEFAULT COLLATE USING
IDENTITY;
~~~
-To verify, check that INFO level log message written by `RDBDocumentStore`
+To verify, check the INFO level log message written by `RDBDocumentStore`
upon startup. For example:
~~~
@@ -101,7 +101,7 @@ create database oak DEFAULT CHARACTER SE
Also make sure to configure the `max_allowed_packet` parameter
for the server (mysqld) to a value greater than 4M (such as 8388608).
-To verify, check that INFO level log message written by `RDBDocumentStore`
+To verify, check the INFO level log message written by `RDBDocumentStore`
upon startup. For example:
~~~
@@ -109,6 +109,20 @@ upon startup. For example:
~~~
+### <a name="database-creation-oracle"></a> Oracle
+
+Creating a database called `OAK`:
+
+...is different compared to other databases. See
https://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm for more
information. Defaults should work.
+
+To verify, check the INFO level log message written by `RDBDocumentStore`
+upon startup. For example:
+
+~~~
+13:26:37.073 INFO [main] RDBDocumentStore.java:1067 RDBDocumentStore
(SNAPSHOT) instantiated for database Oracle Oracle Database 12c Enterprise
Edition Release 12.2.0.1.0 - 64bit Production (12.2), using driver: Oracle JDBC
driver 12.2.0.1.0 (12.2), connecting to: jdbc:oracle:thin:@localhost:1521:orcl,
properties: {NLS_CHARACTERSET=AL32UTF8, NLS_COMP=BINARY}, transaction isolation
level: TRANSACTION_READ_COMMITTED (2), .: ID VARCHAR2(512), MODIFIED NUMBER,
HASBINARY NUMBER, DELETEDONCE NUMBER, MODCOUNT NUMBER, CMODCOUNT NUMBER, DSIZE
NUMBER, VERSION NUMBER, SDTYPE NUMBER, SDMAXREVTIME NUMBER, DATA
VARCHAR2(4000), BDATA BLOB(-1) /* {BLOB=2004, NUMBER=2, VARCHAR2=12} */ /*
index NODES_MOD on SYSTEM.NODES (MODIFIED) clustered (#0, p0), index NODES_SDM
on SYSTEM.NODES (SDMAXREVTIME) clustered (#0, p0), index NODES_SDT on
SYSTEM.NODES (SDTYPE) clustered (#0, p0), index NODES_VSN on SYSTEM.NODES
(VERSION) clustered (#0, p0), unique index SYS_C008093 on SYSTEM.NODES (ID)
clustered
(#0, p0) */
+~~~
+
+
### <a name="database-creation-postgresql"></a> PostgreSQL
Creating a database called `OAK`:
@@ -116,7 +130,7 @@ Creating a database called `OAK`:
CREATE DATABASE "oak" TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'C'
LC_CTYPE = 'C';
~~~
-To verify, check that INFO level log message written by `RDBDocumentStore`
+To verify, check the INFO level log message written by `RDBDocumentStore`
upon startup. For example:
~~~
@@ -131,7 +145,7 @@ Creating a database called `OAK`:
create database OAK;
~~~
-To verify, check that INFO level log message written by `RDBDocumentStore`
+To verify, check the INFO level log message written by `RDBDocumentStore`
upon startup. For example:
~~~
