configure-database.html

buildbot Sat, 02 Mar 2013 21:36:53 -0800

Author: buildbot
Date: Sun Mar  3 05:36:10 2013
New Revision: 852760

Log:
Staging update by buildbot for rave


Modified:
    websites/staging/rave/trunk/content/   (props changed)
    websites/staging/rave/trunk/content/documentation/configure-database.html

Propchange: websites/staging/rave/trunk/content/
------------------------------------------------------------------------------
--- cms:source-revision (original)
+++ cms:source-revision Sun Mar  3 05:36:10 2013
@@ -1 +1 @@
-1446170
+1452003

Modified: 
websites/staging/rave/trunk/content/documentation/configure-database.html
==============================================================================
--- websites/staging/rave/trunk/content/documentation/configure-database.html 
(original)
+++ websites/staging/rave/trunk/content/documentation/configure-database.html 
Sun Mar  3 05:36:10 2013
@@ -90,6 +90,14 @@
 <p>In the default setup, Apache Rave uses a file-based <a 
href="http://www.h2database.com/";>H2 database</a>. Apache Rave and Apache 
Shindig run in the same Apache Tomcat server as
 separate web applications but share data, so we use H2's <a 
href="http://www.h2database.com/html/features.html#auto_mixed_mode";>Automatic 
Mixed Mode</a>.<br />
 </p>
+<h2 id="notice-upgrading-to-rave-021">NOTICE upgrading to Rave 0.21+</h2>
+<p>As of Rave 0.21 the database access configuration has been changed and 
moved to application container provided JNDI resources.
+When upgrading to 0.21+ make sure to update and merge with the default 
provided portal.properties and rave.shindig.properties files, which now define
+the new and required JNDI resource lookup names to use:</p>
+<h4 id="portalproperties">portal.properties</h4>
+<p>rave.dataSource.name=jdbc/ravePortalDB</p>
+<h4 id="raveshindigproperties">rave.shindig.properties</h4>
+<p>rave.dataSource.name=jdbc/raveShindigDB</p>
 <h3 id="filling-the-default-database">Filling the default database</h3>
 <p>All schemes are generated using JPA annotations. The H2 database is 
populated with low level SQL queries using the DataSourcePopulator which is 
configured as Spring bean. These queries are not guaranteed to work for a 
different database.</p>
 <div class="codehilite"><pre><span class="nt">&lt;bean</span> <span 
class="na">id=</span><span class="s">&quot;dataSourcePopulator&quot;</span> 
<span class="na">class=</span><span 
class="s">&quot;org.apache.rave.jdbc.util.DataSourcePopulator&quot;</span><span 
class="nt">&gt;</span>
@@ -121,10 +129,38 @@ username is <code>sa</code>, password is
 value.</p>
 <h2 id="setup-a-different-database">Setup a different database</h2>
 <p>First start with <a href="rave-extensions.html">extending Rave</a>.</p>
-<p>Make sure the JDBC driver ends up in the classpath. Either add it to a 
common lib directory of the application container or add its dependency to the 
pom of the several modules.</p>
+<p>Make sure the JDBC driver ends up in the container classpath as the 
database access is provided by the application container through JNDI resource 
lookup, so add it to a common lib directory of the application container.
+If you use the Cargo plugin to run or package your application container 
setup, replace the dependencies for the com.h2database.h2:jar with your own 
JDBC driver jar like in the rave-portal pom.xml (note: 2 times!).</p>
 <p>If you remove the H2 JDBC driver from the classpath, you need to override 
the <code>dataContext.xml</code> Spring configuration file. Remove the 
configuration for the H2 Web console. This is the bean with class 
<code>org.h2.tools.Server</code>.</p>
-<p>Then customize the properties for the portal and Shindig to use the 
database of your choice.
-The default portal properties can be found in 
<code>rave-portal-resources/src/main/resources/portal.properties</code>, the 
default Shindig properties in 
<code>rave-providers/rave-opensocial-provider/rave-opensocial-server/rave-shindig/src/main/resources/rave.shindig.properties</code>.</p>
+<p>Then customize the properties for the portal and Shindig to use the type of 
database of your choice.
+The default portal properties can be found in 
<code>rave-portal-resources/src/main/resources/portal.properties</code>, the 
default Shindig properties in 
<code>rave-providers/rave-opensocial-provider/rave-opensocial-server/rave-shindig/src/main/resources/rave.shindig.properties</code>.
+Note: only the database type specific properties, like the 
jpa.jpaVendorAdapter.database can be configured in these properties files.</p>
+<p>The database connection parameters itself need to be configured in your 
project pom.xml (accessible by the Cargo plugin for its run or package 
goal).</p>
+<p>The default connection properties are configured in the main Rave project 
pom.xml as follows:</p>
+<div class="codehilite"><pre>    <span class="c">&lt;!-- Rave default jdbc 
datasource configuration --&gt;</span>
+
+    <span class="c">&lt;!-- The location of Rave&#39;s H2 file DB. No trailing 
/ --&gt;</span>
+    <span class="nt">&lt;rave</span><span 
class="err">.database.location</span><span 
class="nt">&gt;</span>/tmp/rave_db<span 
class="nt">&lt;/rave.database.location&gt;</span>
+    <span class="nt">&lt;rave</span><span 
class="err">.dataSource.driver</span><span 
class="nt">&gt;</span>org.h2.Driver<span 
class="nt">&lt;/rave.dataSource.driver&gt;</span>
+    <span class="nt">&lt;rave</span><span 
class="err">.dataSource.username</span><span class="nt">&gt;</span>sa<span 
class="nt">&lt;/rave.dataSource.username&gt;</span>
+    <span class="nt">&lt;rave</span><span 
class="err">.dataSource.password</span><span class="nt">&gt;</span>local<span 
class="nt">&lt;/rave.dataSource.password&gt;</span>
+    <span class="nt">&lt;rave</span><span 
class="err">.dataSource.url</span><span class="nt">&gt;</span>jdbc:h2:<span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">database</span><span class="o">.</span><span 
class="n">location</span><span class="cp">}</span>;AUTO_SERVER=TRUE<span 
class="nt">&lt;/rave.dataSource.url&gt;</span>
+
+    <span class="c">&lt;!-- Rave Portal default jdbc datasource configuration: 
using rave default configuration shared with Shindig --&gt;</span>
+    <span class="nt">&lt;portal</span><span 
class="err">.dataSource.driver</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="cp">}</span><span 
class="nt">&lt;/portal.dataSource.driver&gt;</span>
+    <span class="nt">&lt;portal</span><span 
class="err">.dataSource.url</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">url</span><span class="cp">}</span><span 
class="nt">&lt;/portal.dataSource.url&gt;</span>
+    <span class="nt">&lt;portal</span><span 
class="err">.dataSource.username</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="cp">}</span><span 
class="nt">&lt;/portal.dataSource.username&gt;</span>
+    <span class="nt">&lt;portal</span><span 
class="err">.dataSource.password</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="cp">}</span><span 
class="nt">&lt;/portal.dataSource.password&gt;</span>
+
+  <span class="c">&lt;!-- Rave Shindig default jdbc datasource configuration: 
using rave default configuration shared with Portal --&gt;</span>
+    <span class="nt">&lt;shindig</span><span 
class="err">.dataSource.driver</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="cp">}</span><span 
class="nt">&lt;/shindig.dataSource.driver&gt;</span>
+    <span class="nt">&lt;shindig</span><span 
class="err">.dataSource.url</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">url</span><span class="cp">}</span><span 
class="nt">&lt;/shindig.dataSource.url&gt;</span>
+    <span class="nt">&lt;shindig</span><span 
class="err">.dataSource.username</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="cp">}</span><span 
class="nt">&lt;/shindig.dataSource.username&gt;</span>
+    <span class="nt">&lt;shindig</span><span 
class="err">.dataSource.password</span><span class="nt">&gt;</span><span 
class="cp">${</span><span class="n">rave</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="cp">}</span><span 
class="nt">&lt;/shindig.dataSource.password&gt;</span>
+</pre></div>
+
+
+<p>As you can see from above, you can provide separate configurations for Rave 
Portal or Rave Shindig, although in the default configuration both use the 
same.</p>
 <h2 id="sample-values">Sample values</h2>
 <h3 id="mysql">MySQL</h3>
 <h4 id="jdbc-driver">JDBC driver</h4>
@@ -138,29 +174,27 @@ The default portal properties can be fou
 
 <h4 id="properties">Properties</h4>
 <p>Apache Rave portal:</p>
-<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">dataSource</span><span 
class="o">.</span><span class="n">url</span><span class="o">=</span><span 
class="n">jdbc:mysql:</span><span class="sr">//</span><span 
class="n">localhost:3306</span><span class="o">/</span><span 
class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="o">=</span><span class="n">com</span><span 
class="o">.</span><span class="n">mysql</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">Driver</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="o">=</span><span class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="o">=</span><span class="n">rave</span>
-
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaDialect</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
+<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">jpaDialect</span><span 
class="o">=</span><span class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">databasePlatform</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span class="n">apache</span><span 
class="o">.</span><span class="n">openjpa</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">sql</span><span 
class="o">.</span><span class="n">MySQLDictionary</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">database</span><span class="o">=</span><span class="n">MYSQL</span>
 </pre></div>
 
 
 <p>OpenSocial data (Apache Shindig):</p>
-<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">dataSource</span><span 
class="o">.</span><span class="n">url</span><span class="o">=</span><span 
class="n">jdbc:mysql:</span><span class="sr">//</span><span 
class="n">localhost:3306</span><span class="o">/</span><span 
class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="o">=</span><span class="n">com</span><span 
class="o">.</span><span class="n">mysql</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">Driver</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="o">=</span><span class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="o">=</span><span class="n">rave</span>
-
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaDialect</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
+<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">jpaDialect</span><span 
class="o">=</span><span class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">databasePlatform</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span class="n">apache</span><span 
class="o">.</span><span class="n">openjpa</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">sql</span><span 
class="o">.</span><span class="n">MySQLDictionary</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">database</span><span class="o">=</span><span class="n">MYSQL</span>
 </pre></div>
 
 
+<p>pom.xml properties:</p>
+<div class="codehilite"><pre>    <span 
class="nt">&lt;rave.dataSource.driver&gt;</span>com.mysql.jdbc.Driver<span 
class="nt">&lt;/rave.dataSource.driver&gt;</span>
+    <span class="nt">&lt;rave.dataSource.username&gt;</span>rave<span 
class="nt">&lt;/rave.dataSource.username&gt;</span>
+    <span class="nt">&lt;rave.dataSource.password&gt;</span>rave<span 
class="nt">&lt;/rave.dataSource.password&gt;</span>
+    <span 
class="nt">&lt;rave.dataSource.url&gt;</span>jdbc:mysql://localhost:3306/rave<span
 class="nt">&lt;/rave.dataSource.url&gt;</span>
+</pre></div>
+
+
 <h4 id="notes">Notes</h4>
 <p>The DataSourcePopulator uses a single statement to execute all queries in 
the configured SQL files. The MySQL JDBC driver does not allow this by default, 
unless you add <code>allowMultiQueries=true</code> to the driver URL.</p>
 <h3 id="postgresql">PostgreSQL</h3>
@@ -175,29 +209,27 @@ The default portal properties can be fou
 
 <h4 id="properties_1">Properties</h4>
 <p>Apache Rave portal:</p>
-<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">dataSource</span><span 
class="o">.</span><span class="n">url</span><span class="o">=</span><span 
class="n">jdbc:postgresql:</span><span class="sr">//</span><span 
class="n">localhost:5432</span><span class="o">/</span><span 
class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="o">=</span><span class="n">org</span><span 
class="o">.</span><span class="n">postgresql</span><span 
class="o">.</span><span class="n">Driver</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="o">=</span><span class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="o">=</span><span class="n">rave</span>
-
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaDialect</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
+<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">jpaDialect</span><span 
class="o">=</span><span class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">databasePlatform</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span class="n">apache</span><span 
class="o">.</span><span class="n">openjpa</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">sql</span><span 
class="o">.</span><span class="n">PostgresDictionary</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">database</span><span class="o">=</span><span 
class="n">POSTGRESQL</span>
 </pre></div>
 
 
 <p>OpenSocial data (Apache Shindig):</p>
-<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">dataSource</span><span 
class="o">.</span><span class="n">url</span><span class="o">=</span><span 
class="n">jdbc:postgresql:</span><span class="sr">//</span><span 
class="n">localhost:5432</span><span class="o">/</span><span 
class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="o">=</span><span class="n">org</span><span 
class="o">.</span><span class="n">postgresql</span><span 
class="o">.</span><span class="n">Driver</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="o">=</span><span class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="o">=</span><span class="n">rave</span>
-
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaDialect</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
+<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">jpaDialect</span><span 
class="o">=</span><span class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">databasePlatform</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span class="n">apache</span><span 
class="o">.</span><span class="n">openjpa</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">sql</span><span 
class="o">.</span><span class="n">PostgresDictionary</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">database</span><span class="o">=</span><span 
class="n">POSTGRESQL</span>
 </pre></div>
 
 
+<p>pom.xml properties:</p>
+<div class="codehilite"><pre>    <span 
class="nt">&lt;rave.dataSource.driver&gt;</span>org.postgresql.Driver<span 
class="nt">&lt;/rave.dataSource.driver&gt;</span>
+    <span class="nt">&lt;rave.dataSource.username&gt;</span>rave<span 
class="nt">&lt;/rave.dataSource.username&gt;</span>
+    <span class="nt">&lt;rave.dataSource.password&gt;</span>rave<span 
class="nt">&lt;/rave.dataSource.password&gt;</span>
+    <span 
class="nt">&lt;rave.dataSource.url&gt;</span>jdbc:postgresql://localhost:5432/rave<span
 class="nt">&lt;/rave.dataSource.url&gt;</span>
+</pre></div>
+
+
 <h4 id="notes_1">Notes</h4>
 <ul>
 <li>The DataSourcePopulator cannot handle a PostgreSQL database that has not 
yet been initialized.</li>
@@ -205,32 +237,30 @@ The default portal properties can be fou
 </ul>
 <h3 id="oracle-10g">Oracle 10g</h3>
 <h4 id="jdbc-driver_2">JDBC driver</h4>
-<p>Install the <a 
href="http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html";>Oracle
 JDBC driver</a> in the lib directory of your Apache Tomcat instance. This 
driver is not available in a public Maven repository.</p>
+<p>Install the <a 
href="http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html";>Oracle
 JDBC driver</a> in the common/lib directory of your Apache Tomcat instance. 
This driver is not available in a public Maven repository.</p>
 <h4 id="properties_2">Properties</h4>
 <p>Apache Rave portal:</p>
-<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">dataSource</span><span 
class="o">.</span><span class="n">url</span><span class="o">=</span><span 
class="n">jdbc:oracle:thin:</span><span class="nv">@localhost:1521:rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="o">=</span><span 
class="n">oracle</span><span class="o">.</span><span class="n">jdbc</span><span 
class="o">.</span><span class="n">OracleDriver</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="o">=</span><span class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="o">=</span><span class="n">rave</span>
-
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaDialect</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
+<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">jpaDialect</span><span 
class="o">=</span><span class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">databasePlatform</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span class="n">apache</span><span 
class="o">.</span><span class="n">openjpa</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">sql</span><span 
class="o">.</span><span class="n">OracleDictionary</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">database</span><span class="o">=</span><span class="n">ORACLE</span>
 </pre></div>
 
 
 <p>OpenSocial data (Apache Shindig):</p>
-<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">dataSource</span><span 
class="o">.</span><span class="n">url</span><span class="o">=</span><span 
class="n">jdbc:oracle:thin:</span><span class="nv">@localhost:1521:rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">driver</span><span class="o">=</span><span 
class="n">oracle</span><span class="o">.</span><span class="n">jdbc</span><span 
class="o">.</span><span class="n">OracleDriver</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">username</span><span class="o">=</span><span class="n">rave</span>
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">dataSource</span><span class="o">.</span><span 
class="n">password</span><span class="o">=</span><span class="n">rave</span>
-
-<span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaDialect</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
+<div class="codehilite"><pre><span class="n">jpa</span><span 
class="o">.</span><span class="n">jpaDialect</span><span 
class="o">=</span><span class="n">org</span><span class="o">.</span><span 
class="n">springframework</span><span class="o">.</span><span 
class="n">orm</span><span class="o">.</span><span class="n">jpa</span><span 
class="o">.</span><span class="n">DefaultJpaDialect</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">databasePlatform</span><span class="o">=</span><span 
class="n">org</span><span class="o">.</span><span class="n">apache</span><span 
class="o">.</span><span class="n">openjpa</span><span class="o">.</span><span 
class="n">jdbc</span><span class="o">.</span><span class="n">sql</span><span 
class="o">.</span><span class="n">OracleDictionary</span>
 <span class="n">jpa</span><span class="o">.</span><span 
class="n">jpaVendorAdapter</span><span class="o">.</span><span 
class="n">database</span><span class="o">=</span><span class="n">ORACLE</span>
 </pre></div>
 
 
+<p>pom.xml properties:</p>
+<div class="codehilite"><pre>    <span 
class="nt">&lt;rave.dataSource.driver&gt;</span>oracle.jdbc.OracleDriver<span 
class="nt">&lt;/rave.dataSource.driver&gt;</span>
+    <span class="nt">&lt;rave.dataSource.username&gt;</span>rave<span 
class="nt">&lt;/rave.dataSource.username&gt;</span>
+    <span class="nt">&lt;rave.dataSource.password&gt;</span>rave<span 
class="nt">&lt;/rave.dataSource.password&gt;</span>
+    <span 
class="nt">&lt;rave.dataSource.url&gt;</span>jdbc:oracle:thin:@localhost:1521:rave<span
 class="nt">&lt;/rave.dataSource.url&gt;</span>
+</pre></div>
+
+
 <h4 id="initial-data">Initial data</h4>
 <p>The syntax for setting variables in SQL queries in Oracle is different from 
the syntax in H2 databases. Therefore the default data cannot be loaded using 
the initial_data.sql file.
 OpenJPA can create the schema. With help from <a 
href="http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html";>Oracle
 SQL Developer</a> the minimal set of necessary data can be inserted. The 
script below inserts the Apache Rave portal sequences, the page layouts and 
granted permissions:</p>

svn commit: r852760 - in /websites/staging/rave/trunk/content: ./ documentation/configure-database.html

Reply via email to