Author: reschke
Date: Wed Mar 20 13:44:35 2019
New Revision: 1855905
URL: http://svn.apache.org/viewvc?rev=1855905&view=rev
Log:
OAK-8150: RDB*Store: add Oracle specific documentation
Modified:
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
Modified:
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
URL:
http://svn.apache.org/viewvc/jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md?rev=1855905&r1=1855904&r2=1855905&view=diff
==============================================================================
---
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
(original)
+++
jackrabbit/oak/trunk/oak-doc/src/site/markdown/nodestore/document/rdb-document-store.md
Wed Mar 20 13:44:35 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`:
+
+(to be done)
+
+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:
~~~
