portals-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tay...@apache.org
Subject svn commit: r1742487 - in /portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site: site.xml xdoc/guide-tables.xml
Date Thu, 05 May 2016 22:53:45 GMT
Author: taylor
Date: Thu May  5 22:53:45 2016
New Revision: 1742487

URL: http://svn.apache.org/viewvc?rev=1742487&view=rev
Log:
adding tables docs

Added:
    portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-tables.xml
      - copied, changed from r1733415, portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-database.xml
Modified:
    portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/site.xml

Modified: portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/site.xml
URL: http://svn.apache.org/viewvc/portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/site.xml?rev=1742487&r1=1742486&r2=1742487&view=diff
==============================================================================
--- portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/site.xml (original)
+++ portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/site.xml Thu May  5 22:53:45
2016
@@ -89,6 +89,7 @@
      </menu>
      <menu name="Database" collapse='true' >
 	           <item name="Database Guide" href="guide-database.html" />
+	           <item name="Tables" href="guide-tables.html" />
 	           <item name="Data Access" href="dao.html" />
 	           <item name="RDBMS" href="dev-rdbms.html" />
 	</menu>	

Copied: portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-tables.xml
(from r1733415, portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-database.xml)
URL: http://svn.apache.org/viewvc/portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-tables.xml?p2=portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-tables.xml&p1=portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-database.xml&r1=1733415&r2=1742487&rev=1742487&view=diff
==============================================================================
--- portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-database.xml
(original)
+++ portals/site/jetspeed/jetspeed-2.3/jetspeed-guide-dev/src/site/xdoc/guide-tables.xml Thu
May  5 22:53:45 2016
@@ -17,257 +17,543 @@
 -->
 <document>
 	<properties>
-		<title>Jetspeed 2 Database Configuration</title>
-		<subtitle>Welcome to Jetspeed 2</subtitle>
+		<title>Jetspeed 2 Tables</title>
+		<subtitle>Tables Reference </subtitle>
 		<authors>
 			<person name="David Sean Taylor" email="taylor@apache.org" />
-			<person name="David Le Strat" email="dlestrat@apache.org" />
-			<person name="Ron Wheeler"
-				email="rwheeler@artifact-software.com" />
 		</authors>
 	</properties>
 	<body>
-		<section name="Default Database">
-			<p>
-				The default database distributed with Jetspeed-2 is the
-				Apache Derby database. To move on to a more robust
-				database, follow the instructions in the next section.
-			</p>
-		</section>
-        <section name='Supported Databases'> 
-        <p>List of supported databases:</p>
+        <section name='Audit Tables'>
         <table>
             <tr>
-                <th>Database Name</th>
-                <th>Build Constant</th>                
-                <th>Tested Versions</th>
+                <th>Table Name</th>
+                <th>Description</th>
             </tr>
             <tr>
-                <td>IBM DB2</td>
-                <td>db2</td>                
-                <td>9.1</td>
+                <td>ADMIN_ACTIVITY</td>
+                <td>Tracks administrative auditing activities by the admin users. Activities
like adding and deleting users from User Manager</td>
             </tr>
-            <tr>
-                <td>Apache Derby, IBM Cloudscape</td>
-                <td>derby</td>
-                <td>10.1</td>
-            </tr>
-            <tr>
-                <td>Hypersonic SQL (HSQL)</td>
-                <td>hsql</td>
-                <td>1.8</td>
-            </tr>
-            <tr>
-                <td>Microsoft SQL Server</td>
-                <td>mssql</td>
-                <td>2000, 2005</td>
-            </tr>
-            <tr>
-                <td>MySQL</td>
-                <td>mysql</td>
-                <td>4.*, 5.*</td>
-            </tr>
-            <tr>
-                <td>Oracle</td>
-                <td>oracle</td>
-                <td>9i, 10g</td>
-            </tr>
-            <tr>
-                <td>PostgreSQL</td>
-                <td>postgres</td>
-                <td>8.*</td>
-            </tr>                            
-            <tr>
-                <td>SAP DB, MaxDB</td>
-                <td>sapdb</td>
-                <td>7.5</td>
-            </tr>
-        </table>            
+			<tr>
+				<td>USER_ACTIVITY</td>
+				<td>Tracks user activity. Tracks User activities like logging on and off, changing
password, updating user profile</td>
+			</tr>
+        </table>
+            <h4>Configuration</h4>
+            <source><![CDATA[
+            #-------------------------------------------------------------------------
+            # jetspeed.properties
+            #-------------------------------------------------------------------------
+            portal.audit.enable=true
+            ]]></source>
+        </section>
+
+        <section name='Statistics Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>PAGE_STATISTICS</td>
+                    <td>Counts page accesses and min, max and average page render times
system wide</td>
+                </tr>
+                <tr>
+                    <td>USER_STATISTICS</td>
+                    <td>Counts user total sessions and session max, min and average
session times</td>
+                </tr>
+                <tr>
+                    <td>PORTLET_STATISTICS</td>
+                    <td>Counts portlet accesses and min, max and average portlet render
times system wide</td>
+                </tr>
+            </table>
+            <h4>Configuration</h4>
+            <source><![CDATA[
+            #-------------------------------------------------------------------------
+            # jetspeed.properties
+            #-------------------------------------------------------------------------
+            portal.statistics.logToLogger=false
+            portal.statistics.logToDatabase=true
+            # Number of records
+            portal.statistics.MaxPortalRecordToFlush=300
+            portal.statistics.MaxUserUserRecordToFlush=50
+            portal.statistics.MaxPagePageRecordToFlush=100
+            # Flush time in in Millisecond
+            portal.statistics.MaxTimePortalToFlush=300000
+            portal.statistics.MaxTimeUserToFlush=5000
+            portal.statistics.MaxTimePageToFlush=60000
+            ]]></source>
+        </section>
+
+        <section name='Profiler Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>PROFILING_RULE</td>
+                    <td>Defines a profiling rule name and class</td>
+                </tr>
+                <tr>
+                    <td>RULE_CRITERION</td>
+                    <td>Defines a Profiling Rule Criterion and associates it with a
Profiling Rule(RULE_ID) with a RULE CRITERIA(CRITERIA_ID)</td>
+                </tr>
+                <tr>
+                    <td>PRINCIPAL_RULE_ASSOC</td>
+                    <td>Associates a user (PRINCIPAL_NAME) to a profiling rule (RULE_ID).
Determines which profiling rule is used per user.</td>
+                </tr>
+                <tr>
+                    <td>PROFILE_PAGE_ASSOC</td>
+                    <td>Deprecated</td>
+                </tr>
+            </table>
+            <h3>Configuration</h3>
+            <source><![CDATA[
+            #-------------------------------------------------------------------------
+            # jetspeed.properties
+            #-------------------------------------------------------------------------
+            # default profiling rule names assigned to a new user
+            profiler.rule.names.default = page
+            # default profiling rule values assigned to a new user
+            profiler.rule.values.default = j2
+            # Registration default profiling rules assigned during registration or new user
creation
+            # comma separated list
+            registration.rules.default = j2
+            ]]></source>
+        </section>
+
+        <section name='Security Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>SECURITY_DOMAIN</td>
+                    <td>Multi-tenant domain identifier. Currently modeled in database,
but not used by Jetspeed</td>
+                </tr>
+                <tr>
+                    <td>SECURITY_PRINCIPAL</td>
+                    <td>Defines a Security Principal of type User, Role, Group. Users
are stored in this table.
+                        Usernames stored in PRINCIPAL_NAME column, unique by DTYPE + PRINCIPAL_NAME</td>
+                </tr>
+                <tr>
+                    <td>SECURITY_PRINCIPAL_ASSOC</td>
+                    <td>Associates a principal to another principal by FROM_PRINCIPAL
to TO_PRINCIPAL. This is how we represent user's group and role membership.
+                        Valid association types are: isMemberOf, isChildOf, isA, isPartOf,
belongsTo</td>
+                </tr>
+                <tr>
+                    <td>SECURITY_PERMISSION</td>
+                    <td>Java Security Policy permission definitions. Supported permissions:
Folder, Page, Portlet, Fragment.
+                    </td>
+                </tr>
+                <tr>
+                    <td>SECURITY_CREDENTIAL</td>
+                    <td>Defines a credential associated with a Security Principal.
Also defines credential/password rules and expirations</td>
+                </tr>
+                <tr>
+                    <td>SECURITY_ATTRIBUTE</td>
+                    <td>An attribute name value pair associated (one-to-many attributes)
with a Security Principal. Typically used for dynamic user attributes per user</td>
+                </tr>
+                <tr>
+                    <td>PRINCIPAL_PERMISSION</td>
+                    <td>Association(join) table joining a Security Principal(SECURITY_PRINCIPAL)
to a Permission(SECURITY_PERMISSION)</td>
+                </tr>
+            </table>
+            <h3>Configuration</h3>
+            <source><![CDATA[
+            ]]></source>
+        </section>
+
+		<section name='PSML Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>FOLDER</td>
+                    <td>PSML Folder</td>
+                </tr>
+                <tr>
+                    <td>FOLDER_CONSTRAINT</td>
+                    <td>PSML Folder Security</td>
+                </tr>
+                <tr>
+                    <td>FOLDER_CONSTRAINTS_REF</td>
+                    <td>PSML Folder Security</td>
+                </tr>
+                <tr>
+                    <td>FOLDER_MENU</td>
+                    <td>PSML Folder Menu</td>
+                </tr>
+                <tr>
+                    <td>FOLDER_MENU_METADATA</td>
+                    <td>PSML Folder Menu</td>
+                </tr>
+                <tr>
+                    <td>FOLDER_METADATA</td>
+                    <td>PSML Folder Menu</td>
+                </tr>
+                <tr>
+                    <td>FOLDER_ORDER</td>
+                    <td>PSML Folder Menu</td>
+                </tr>
+                <tr>
+                    <td>FRAGMENT</td>
+                    <td>PSML Fragment (Portlet Instance)</td>
+                </tr>
+                <tr>
+                    <td>FRAGMENT_CONSTRAINT</td>
+                    <td>PSML Fragment (Portlet Instance) Security</td>
+                </tr>
+                <tr>
+                    <td>FRAGMENT_CONSTRAINTS_REF</td>
+                    <td>PSML Fragment (Portlet Instance) Security</td>
+                </tr>
+                <tr>
+                    <td>FRAGMENT_PREF</td>
+                    <td>Entity (Page Fragment) level preferences</td>
+                </tr>
+                <tr>
+                    <td>FRAGMENT_PREF_VALUE</td>
+                    <td>Entity (Page Fragment) level preferences</td>
+                </tr>
+                <tr>
+                    <td>FRAGMENT_PROP</td>
+                    <td>Fragment properties like number of columns, row/column positioning</td>
+                </tr>
+                <tr>
+                    <td>LINK</td>
+                    <td>PSML Links</td>
+                </tr>
+                <tr>
+                    <td>LINK_CONSTRAINT</td>
+                    <td>PSML Link security</td>
+                </tr>
+                <tr>
+                    <td>LINK_CONSTRAINT_REF</td>
+                    <td>PSML Link Security</td>
+                </tr>
+                <tr>
+                    <td>LINK_METADATA</td>
+                    <td>PSML Links</td>
+                </tr>
+                <tr>
+                    <td>PAGE</td>
+                    <td>PSML Pages</td>
+                </tr>
+                <tr>
+                    <td>PAGE_CONSTRAINT</td>
+                    <td>PSML Page Security</td>
+                </tr>
+                <tr>
+                    <td>PAGE_CONSTRAINT_REF</td>
+                    <td>PSML Page Security</td>
+                </tr>
+                <tr>
+                    <td>PAGE_MENU</td>
+                    <td>PSML Page Menu</td>
+                </tr>
+                <tr>
+                    <td>PAGE_MENU_METADATA</td>
+                    <td>PSML Page Menu</td>
+                </tr>
+                <tr>
+                    <td>PAGE_METADATA</td>
+                    <td>PSML Page Metadata</td>
+                </tr>
+                <tr>
+                    <td>PAGE_SECURITY</td>
+                    <td>PSML Page Security definitions and references</td>
+                </tr>
+                <tr>
+                    <td>PAGE_SEC_CONSTRAINTS_DEF</td>
+                    <td>PSML Global Security Constraints collection definitions</td>
+                </tr>
+                <tr>
+                    <td>PAGE_SEC_CONSTRAINTS_REF</td>
+                    <td>PSML Global Security Constraints references</td>
+                </tr>
+                <tr>
+                    <td>PAGE_SEC_CONSTRAINT_DEF</td>
+                    <td>PSML Global Security Constraints definition</td>
+                </tr>
+            </table>
+            <h3>Configuration</h3>
+            <source><![CDATA[
+            #-------------------------------------------------------------------------
+            # jetspeed.properties
+            #-------------------------------------------------------------------------
+            # defaults for page manager security
+            page.manager.permissions.security = false
+            page.manager.constraints.security = true
+            db.page.manager.cache.size=128
+            #- folder/page/link cache expires seconds, default=-1 (default then is 150 seconds),
infinite=0, min=30
+            db.page.manager.cache.expire=-1
+            ]]></source>
+        </section>
+
+        <section name='Preferences Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>PORTLET_PREFERENCE</td>
+                    <td>Primary Portlet and User Preferences definitions</td>
+                </tr>
+                <tr>
+                    <td>PORTLET_PREFERENCE_VALUE</td>
+                    <td>Primary Portlet and User Preferences values associated to PORTLET_PREFERENCE
by PREF_ID</td>
+                </tr>
+            </table>
+            <source><![CDATA[
+            #-------------------------------------------------------------------------
+            # jetspeed.properties
+            #-------------------------------------------------------------------------
+            preferences.session.cache.enabled = true
+            ]]></source>
+        </section>
+
+        <section name='Registry Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>CUSTOM_PORTLET_MODE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>CUSTOM_WINDOW_STATE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>EVENT_ALIAS</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>EVENT_DEFINITION</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>FILTERED_PORTLET</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>FILTER_LIFECYCLE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>FILTER_MAPPING</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>JETSPEED_SERVICE</td>
+                    <td>jetspeed-portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>LANGUAGE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>LOCALE_ENCODING_MAPPING</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>LOCALIZED_DESCRIPTION</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>LOCALIZED_DISPLAY_NAME</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>NAMED_PARAMETER</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PARAMETER</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PARAMETER_ALIAS</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PA_METADATA_FIELDS</td>
+                    <td>jetspeed-portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PA_SECURITY_CONSTRAINT</td>
+                    <td>jetspeed-portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PD_METADATA_FIELDS</td>
+                    <td>jetspeed-portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PORTLET_APPLICATION</td>
+                    <td>Primary Portlet Application definition from portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PORTLET_DEFINITION</td>
+                    <td>Primary Portlet Definition definition from portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PORTLET_FILTER</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PORTLET_LISTENER</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PORTLET_SUPPORTS</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PROCESSING_EVENT</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PUBLIC_PARAMETER</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>PUBLISHING_EVENT</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>RUNTIME_OPTION</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>RUNTIME_VALUE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>SECURED_PORTLET</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>SECURITY_ROLE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>SECURITY_ROLE_REFERENCE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>USER_ATTRIBUTE</td>
+                    <td>portlet.xml</td>
+                </tr>
+                <tr>
+                    <td>USER_ATTRIBUTE_REF</td>
+                    <td>portlet.xml</td>
+                </tr>
+
+            </table>
+            <h3>Configuration</h3>
+            <source><![CDATA[
+            #-------------------------------------------------------------------------
+            # jetspeed.properties
+            #-------------------------------------------------------------------------
+            #1 = Permissions = use Jetspeed Java Security Policy
+            #2 = Constraints = use Jetspeed (PageManager) Constraint-based Security
+            portal.core.security.type=2
+
+            # jetspeed security persistence manager cache size:
+            org.apache.jetspeed.ehcache.jspm.maxelements=128
+            # jetspeed security persistence manager cache element expiration in seconds,
(infinite = 0):
+            org.apache.jetspeed.ehcache.jspm.element.ttl=150
+
+            # if no user has been setup, default.user.principal will be
+            # automatically added via HttpRequestContext.setUserPrincpal()
+            default.user.principal=guest
+            default.admin.user=admin
+            default.admin.role=admin
+            default.manager.role=manager
+            default.user.role=user
+            default.guest.role=guest
+
+            ]]></source>
+        </section>
+
+        <section name='Capability Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>CAPABILITY</td>
+                    <td>A device capability</td>
+                </tr>
+                <tr>
+                    <td>CLIENT</td>
+                    <td>Defines a device</td>
+                </tr>
+                <tr>
+                    <td>CLIENT_TO_CAPABILITY</td>
+                    <td>Association table: a device(client) can have many capabilities</td>
+                </tr>
+                <tr>
+                    <td>CLIENT_TO_MIMETYPE</td>
+                    <td>Association table: a device(client) can have many mimetypes</td>
+                </tr>
+                <tr>
+                    <td>MEDIATYPE_TO_CAPABILITY</td>
+                    <td>Association table: a mediatype can have many capabilities</td>
+                </tr>
+                <tr>
+                    <td>MEDIATYPE_TO_MIMETYPE</td>
+                    <td>Assocation table: media type to mime type</td>
+                </tr>
+                <tr>
+                    <td>MEDIA_TYPE</td>
+                    <td>A generalized media type such as HTML or XML</td>
+                </tr>
+                <tr>
+                    <td>MIMETYPE</td>
+                    <td>A Internet Standard Mime Type such as text/html</td>
+                </tr>
+            </table>
+        </section>
+
+        <section name='ObjectRelational Mapping Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>OJB_HL_SEQ</td>
+                    <td>High Low Sequence tables for all primary keys (Native database
sequences are not used)</td>
+                </tr>
+                <tr>
+                    <td>OJB_*</td>
+                    <td>Not used</td>
+                </tr>
+            </table>
+        </section>
+
+        <section name='Jetspeed SSO Tables'>
+            <table>
+                <tr>
+                    <th>Table Name</th>
+                    <th>Description</th>
+                </tr>
+                <tr>
+                    <td>SSO_SITE</td>
+                    <td>Secure Signon Site definition with credentials and Form-based
security parameters</td>
+                </tr>
+            </table>
         </section>
-		<section name="MySQL">
-			<p>
-				To run with My SQL, add the following properties to your
-				$HOME/build.properties:
-			</p>
-			<source test="">
-				<![CDATA[
-
-# -------------------------------------------------------------------------
-# configure MySQL Test DB (only needed when running unit tests)
-# -------------------------------------------------------------------------
-org.apache.jetspeed.test.database.default.name=mysql
-org.apache.jetspeed.test.database.url = jdbc:mysql://j2-server/j2test
-org.apache.jetspeed.test.database.driver = com.mysql.jdbc.Driver
-org.apache.jetspeed.test.database.user = jetspeed2
-org.apache.jetspeed.test.database.password = whatever
-# -------------------------------------------------------------------------
-# configure MySQL Production DB
-# -------------------------------------------------------------------------
-org.apache.jetspeed.production.database.default.name=mysql
-org.apache.jetspeed.production.database.url = jdbc:mysql://j2-server/j2
-org.apache.jetspeed.production.database.driver = com.mysql.jdbc.Driver
-org.apache.jetspeed.production.database.user = jetspeed2
-org.apache.jetspeed.production.database.password = whatever
-# -------------------------------------------------------------------------
-
-]]>
-			</source>
-			<p>
-				In the example above, you will need to have a MySQL
-				server running on a host named 'j2-server' with a
-				database called 'j2' for production.
-				<br />
-				If you are going to run the unit tests you will also
-				need an additional test database called 'j2test'.
-				<br />
-				A user named 'jetspeed2' should be granted access to
-				both the 'j2' and 'j2test' databases.
-			</p>
-
-			<subsection name="MySQL Known Issues">
-				<p>None</p>
-			</subsection>
-
-		</section>
-        
-		<section name="Oracle">
-			<p>
-				To run with Oracle, add the following properties to your
-				$HOME/build.properties:
-			</p>
-
-			<source test="">
-				<![CDATA[
-
-# -------------------------------------------------------------------------
-# configure Oracle Test DB (only needed when running unit tests)
-# -------------------------------------------------------------------------
-# org.apache.jetspeed.test.database.default.name=oracle
-# org.apache.jetspeed.test.database.ojb.platform=oracle9i
-# org.apache.jetspeed.test.database.url = jdbc:oracle:thin:@j2-sever:1521:j2db
-# org.apache.jetspeed.test.database.driver = oracle.jdbc.driver.OracleDriver
-# org.apache.jetspeed.test.database.user = j2test
-# org.apache.jetspeed.test.database.password = whatever
-# -------------------------------------------------------------------------
-# configure Oracle Production DB
-# -------------------------------------------------------------------------
-# org.apache.jetspeed.production.database.default.name=oracle
-# org.apache.jetspeed.production.database.ojb.platform=oracle9i
-# org.apache.jetspeed.production.database.url = jdbc:oracle:thin:@j2-server:1521:j2db
-# org.apache.jetspeed.production.database.driver = oracle.jdbc.driver.OracleDriver
-# org.apache.jetspeed.production.database.user = j2
-# org.apache.jetspeed.production.database.password = whatever
-# -------------------------------------------------------------------------
-
-]]>
-			</source>
-			<p>
-				In the example above, you will need to have a Oracle
-				server running on a host named 'j2-server' and have an
-				Oracle database SID named 'j2db' installed on that
-				server. Also, you will need a database user (schema)
-				called 'j2' for production usage.
-				<br />
-				If you are going to run the unit tests you will need an
-				additional user called 'j2test'.
-			</p>
-
-			<subsection name="Oracle Known Issues">
-				<p>
-					Only for the first time you create the database for
-					Oracle, there is an issue with the drop statements.
-					To get around this problem, set your properties as
-					above in your $HOME/build.properties, and then run
-					these commands using the
-					<a href="j2-maven-plugin.html">
-						Jetspeed 2 Maven plugin
-					</a>
-					:
-				</p>
-				<source test="">
-					<![CDATA[
-
-maven j2:db.scripts.gen
-maven j2:dropdrops
-maven j2:db.create.test (only when running unit tests)
-maven j2:db.create.production
-
-]]>
-				</source>
-			</subsection>
-
-		</section>
-
-		<section name="Drivers">
-			<p>
-				JDBC drivers are configured to work with the Maven build
-				by adding your specified JDBC driver jars to the Maven
-				class path. Specify the jars with the
-				<b>org.apache.jetspeed.test.jdbc.drivers.path</b>
-				and
-				<b>org.apache.jetspeed.production.jdbc.drivers.path</b>
-				properties in your $HOME/build.properties.
-			</p>
-			<p>
-				NOTE: The Derby JDBC driver is distributed with
-				Jetspeed and require no configuration.
-			</p>
-			<source test="">
-				<![CDATA[
-
-# My SQL Driver Path Example, test and production
-org.apache.jetspeed.test.jdbc.drivers.path=
-     /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar
-org.apache.jetspeed.production.jdbc.drivers.path=
-     /Portal/lib/MySQL/mysql-connector-java-3.0.8-stable-bin.jar
-
-# Oracle 9i Driver Path Example, test and production
-org.apache.jetspeed.test.jdbc.drivers.path=
-     /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar
-org.apache.jetspeed.production.jdbc.drivers.path=
-     /Portal/lib/oracle/ojdbc14.jar;/Portal/lib/oracle/nls_charset12.jar
-
-# Oracle 8i Driver Path Example, test and production
-org.apache.jetspeed.test.jdbc.drivers.path=
-     /Portal/lib/oracle/classes12.jar;
-org.apache.jetspeed.production.jdbc.drivers.path=
-     /Portal/lib/oracle/classes12.jar;
-
-]]>
-			</source>
-
-			<subsection name="Distributing Drivers">
-				<p>
-					When Jetspeed is deployed to an application server
-					using the maven deploy target, only the Derby
-					JDBC driver is copied into the web application. To
-					distribute a specific driver (i.e. Oracle, MySQL),
-					you will need to copy the driver into the
-					application server's common class path for shared
-					code.
-				</p>
-				<table>
-					<tr>
-						<th>Application Server</th>
-						<th>Procedure</th>
-					</tr>
-					<tr>
-						<td>Tomcat 6+</td>
-						<td>
-							copy driver(s) to ${TOMCAT_HOME}/lib/
-						</td>
-					</tr>
-
-				</table>
-
-			</subsection>
-			<subsection name="Datasource Configuration with Jetspeed-2">
-			<p>
-			Jetspeed-2 requires a datasource to be configured in the application server on which it
is being deployed.
-			For more information, see the <a href="dev-rdbms.html">RDBMS component documentation</a>.
-			</p>
-			</subsection>
 
-		</section>
-	</body>
+    </body>
 </document>



Mime
View raw message