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="[email protected]" />
- <person name="David Le Strat"
email="[email protected]" />
- <person name="Ron Wheeler"
- email="[email protected]" />
</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>
