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 Feb 7 21:02:46 2016 @@ -29,6 +29,7 @@ </head> <body> + <div style="background: red"><h1>2016/02/07 - Apache Rave has been retired. </h1><h2>For more information, please explore the <a href="http://attic.apache.org/";>Attic</a>. </h2></div> <div class="navbar navbar-inverse navbar-fixed-top"> <div class="navbar-inner"> @@ -87,19 +88,29 @@ </header> <section id="content" class="row"> <article class="span12"> - <h2 id="default-setup">Default setup</h2> + <style type="text/css"> +/* The following code is added by mdx_elementid.py + It was originally lifted from http://subversion.apache.org/style/site.css */ +/* + * Hide class="elementid-permalink", except when an enclosing heading + * has the :hover property. + */ +.headerlink, .elementid-permalink { + visibility: hidden; +} +h2:hover > .headerlink, h3:hover > .headerlink, h1:hover > .headerlink, h6:hover > .headerlink, h4:hover > .headerlink, h5:hover > .headerlink, dt:hover > .elementid-permalink { visibility: visible }</style> +<h2 id="default-setup">Default setup<a class="headerlink" href="#default-setup" title="Permanent link">¶</a></h2> <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> +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>. </p> +<h2 id="notice-upgrading-to-rave-021">NOTICE upgrading to Rave 0.21+<a class="headerlink" href="#notice-upgrading-to-rave-021" title="Permanent link">¶</a></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> +<h4 id="portalproperties">portal.properties<a class="headerlink" href="#portalproperties" title="Permanent link">¶</a></h4> <p>rave.dataSource.name=jdbc/ravePortalDB</p> -<h4 id="raveshindigproperties">rave.shindig.properties</h4> +<h4 id="raveshindigproperties">rave.shindig.properties<a class="headerlink" href="#raveshindigproperties" title="Permanent link">¶</a></h4> <p>rave.dataSource.name=jdbc/raveShindigDB</p> -<h3 id="filling-the-default-database">Filling the default database</h3> +<h3 id="filling-the-default-database">Filling the default database<a class="headerlink" href="#filling-the-default-database" title="Permanent link">¶</a></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"><bean</span> <span class="na">id=</span><span class="s">"dataSourcePopulator"</span> <span class="na">class=</span><span class="s">"org.apache.rave.jdbc.util.DataSourcePopulator"</span><span class="nt">></span> <span class="nt"><property</span> <span class="na">name=</span><span class="s">"executeScriptQuery"</span> <span class="na">value=</span><span class="s">"SELECT * FROM widget"</span><span class="nt">/></span> @@ -113,7 +124,7 @@ the new and required JNDI resource looku <p>If the query in <code>executeScriptQuery</code> returns no error and no results, the database will be populated with the contents of <code>scriptLocations</code>.</p> -<h3 id="access-the-default-database">Access the default database</h3> +<h3 id="access-the-default-database">Access the default database<a class="headerlink" href="#access-the-default-database" title="Permanent link">¶</a></h3> <p>When the application is running, the H2 databases can be accessed through a web interface. In the default setup this is configured using a Spring bean:</p> <div class="codehilite"><pre><span class="nt"><bean</span> <span class="na">id=</span><span class="s">"org.h2.tools.Server-WebServer"</span> <span class="na">class=</span><span class="s">"org.h2.tools.Server"</span> <span class="na">factory-method=</span><span class="s">"createWebServer"</span> <span class="na">depends-on=</span><span class="s">"dataSource"</span> @@ -124,11 +135,10 @@ the new and required JNDI resource looku <p>Both Apache Rave and Apache Shindig are accessible from the database: <a href="http://localhost:11111";>http://localhost:11111</a>. The default -username is <code>sa</code>, password is <code>local</code>, and JDBC URL is <code>jdbc:h2:file:///tmp/rave_db</code>. In Windows the JDBC URL is <code>jdbc:h2:file://c:/tmp/rave_db</code> if you run Apache Rave from the c: drive.<br /> -</p> +username is <code>sa</code>, password is <code>local</code>, and JDBC URL is <code>jdbc:h2:file:///tmp/rave_db</code>. In Windows the JDBC URL is <code>jdbc:h2:file://c:/tmp/rave_db</code> if you run Apache Rave from the c: drive. </p> <p>You can change the file location for both databases by editing Apache Rave's top level pom.xml file. Change the property <code>rave.database.location</code> to the desired value.</p> -<h2 id="setup-a-different-database">Setup a different database</h2> +<h2 id="setup-a-different-database">Setup a different database<a class="headerlink" href="#setup-a-different-database" title="Permanent link">¶</a></h2> <p>First start with <a href="rave-extensions.html">extending Rave</a>.</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> @@ -162,9 +172,9 @@ Note: only the database type specific pr <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> +<h2 id="sample-values">Sample values<a class="headerlink" href="#sample-values" title="Permanent link">¶</a></h2> +<h3 id="mysql">MySQL<a class="headerlink" href="#mysql" title="Permanent link">¶</a></h3> +<h4 id="jdbc-driver">JDBC driver<a class="headerlink" href="#jdbc-driver" title="Permanent link">¶</a></h4> <div class="codehilite"><pre><span class="nt"><dependency></span> <span class="nt"><groupId></span>mysql<span class="nt"></groupId></span> <span class="nt"><artifactId></span>mysql-connector-java<span class="nt"></artifactId></span> @@ -173,18 +183,18 @@ Note: only the database type specific pr </pre></div> -<h4 id="properties">Properties</h4> +<h4 id="properties">Properties<a class="headerlink" href="#properties" title="Permanent link">¶</a></h4> <p>Apache Rave portal:</p> -<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> +<div class="codehilite"><pre><span class="n">jpa</span><span class="p">.</span><span class="n">jpaDialect</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">springframework</span><span class="p">.</span><span class="n">orm</span><span class="p">.</span><span class="n">jpa</span><span class="p">.</span><span class="n">DefaultJpaDialect</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">databasePlatform</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">apache</span><span class="p">.</span><span class="n">openjpa</span><span class="p">.</span><span class="n">jdbc</span><span class="p">.</span><span class="n">sql</span><span class="p">.</span><span class="n">MySQLDictionary</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">database</span><span class="p">=</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">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> +<div class="codehilite"><pre><span class="n">jpa</span><span class="p">.</span><span class="n">jpaDialect</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">springframework</span><span class="p">.</span><span class="n">orm</span><span class="p">.</span><span class="n">jpa</span><span class="p">.</span><span class="n">DefaultJpaDialect</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">databasePlatform</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">apache</span><span class="p">.</span><span class="n">openjpa</span><span class="p">.</span><span class="n">jdbc</span><span class="p">.</span><span class="n">sql</span><span class="p">.</span><span class="n">MySQLDictionary</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">database</span><span class="p">=</span><span class="n">MYSQL</span> </pre></div> @@ -196,10 +206,10 @@ Note: only the database type specific pr </pre></div> -<h4 id="notes">Notes</h4> +<h4 id="notes">Notes<a class="headerlink" href="#notes" title="Permanent link">¶</a></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> -<h4 id="jdbc-driver_1">JDBC driver</h4> +<h3 id="postgresql">PostgreSQL<a class="headerlink" href="#postgresql" title="Permanent link">¶</a></h3> +<h4 id="jdbc-driver_1">JDBC driver<a class="headerlink" href="#jdbc-driver_1" title="Permanent link">¶</a></h4> <div class="codehilite"><pre><span class="nt"><dependency></span> <span class="nt"><groupId></span>postgresql<span class="nt"></groupId></span> <span class="nt"><artifactId></span>postgresql<span class="nt"></artifactId></span> @@ -208,18 +218,18 @@ Note: only the database type specific pr </pre></div> -<h4 id="properties_1">Properties</h4> +<h4 id="properties_1">Properties<a class="headerlink" href="#properties_1" title="Permanent link">¶</a></h4> <p>Apache Rave portal:</p> -<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> +<div class="codehilite"><pre><span class="n">jpa</span><span class="p">.</span><span class="n">jpaDialect</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">springframework</span><span class="p">.</span><span class="n">orm</span><span class="p">.</span><span class="n">jpa</span><span class="p">.</span><span class="n">DefaultJpaDialect</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">databasePlatform</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">apache</span><span class="p">.</span><span class="n">openjpa</span><span class="p">.</span><span class="n">jdbc</span><span class="p">.</span><span class="n">sql</span><span class="p">.</span><span class="n">PostgresDictionary</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">database</span><span class="p">=</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">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> +<div class="codehilite"><pre><span class="n">jpa</span><span class="p">.</span><span class="n">jpaDialect</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">springframework</span><span class="p">.</span><span class="n">orm</span><span class="p">.</span><span class="n">jpa</span><span class="p">.</span><span class="n">DefaultJpaDialect</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">databasePlatform</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">apache</span><span class="p">.</span><span class="n">openjpa</span><span class="p">.</span><span class="n">jdbc</span><span class="p">.</span><span class="n">sql</span><span class="p">.</span><span class="n">PostgresDictionary</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">database</span><span class="p">=</span><span class="n">POSTGRESQL</span> </pre></div> @@ -231,26 +241,26 @@ Note: only the database type specific pr </pre></div> -<h4 id="notes_1">Notes</h4> +<h4 id="notes_1">Notes<a class="headerlink" href="#notes_1" title="Permanent link">¶</a></h4> <ul> <li>The DataSourcePopulator cannot handle a PostgreSQL database that has not yet been initialized.</li> <li>The syntax for setting variables in SQL queries in PostgreSQL is different from the syntax in H2 databases. Therefore the default data cannot be loaded using the initial_data.sql file.</li> </ul> -<h3 id="oracle-10g">Oracle 10g</h3> -<h4 id="jdbc-driver_2">JDBC driver</h4> +<h3 id="oracle-10g">Oracle 10g<a class="headerlink" href="#oracle-10g" title="Permanent link">¶</a></h3> +<h4 id="jdbc-driver_2">JDBC driver<a class="headerlink" href="#jdbc-driver_2" title="Permanent link">¶</a></h4> <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> +<h4 id="properties_2">Properties<a class="headerlink" href="#properties_2" title="Permanent link">¶</a></h4> <p>Apache Rave portal:</p> -<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> +<div class="codehilite"><pre><span class="n">jpa</span><span class="p">.</span><span class="n">jpaDialect</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">springframework</span><span class="p">.</span><span class="n">orm</span><span class="p">.</span><span class="n">jpa</span><span class="p">.</span><span class="n">DefaultJpaDialect</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">databasePlatform</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">apache</span><span class="p">.</span><span class="n">openjpa</span><span class="p">.</span><span class="n">jdbc</span><span class="p">.</span><span class="n">sql</span><span class="p">.</span><span class="n">OracleDictionary</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">database</span><span class="p">=</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">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> +<div class="codehilite"><pre><span class="n">jpa</span><span class="p">.</span><span class="n">jpaDialect</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">springframework</span><span class="p">.</span><span class="n">orm</span><span class="p">.</span><span class="n">jpa</span><span class="p">.</span><span class="n">DefaultJpaDialect</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">databasePlatform</span><span class="p">=</span><span class="n">org</span><span class="p">.</span><span class="n">apache</span><span class="p">.</span><span class="n">openjpa</span><span class="p">.</span><span class="n">jdbc</span><span class="p">.</span><span class="n">sql</span><span class="p">.</span><span class="n">OracleDictionary</span> +<span class="n">jpa</span><span class="p">.</span><span class="n">jpaVendorAdapter</span><span class="p">.</span><span class="n">database</span><span class="p">=</span><span class="n">ORACLE</span> </pre></div> @@ -262,49 +272,49 @@ Note: only the database type specific pr </pre></div> -<h4 id="initial-data">Initial data</h4> +<h4 id="initial-data">Initial data<a class="headerlink" href="#initial-data" title="Permanent link">¶</a></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> <div class="codehilite"><pre><span class="n">SET</span> <span class="n">serveroutput</span> <span class="n">ON</span> <span class="n">SET</span> <span class="n">echo</span> <span class="n">OFF</span> <span class="n">DECLARE</span> - <span class="n">page_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'page'</span><span class="p">;</span> - <span class="n">page_layout_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'page_layout'</span><span class="p">;</span> - <span class="n">region_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'region'</span><span class="p">;</span> - <span class="n">region_widget_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'region_widget'</span><span class="p">;</span> - <span class="n">user_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'person'</span><span class="p">;</span> - <span class="n">person_association_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'person_association'</span><span class="p">;</span> - <span class="n">groups_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'groups'</span><span class="p">;</span> - <span class="n">group_members_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'group_members'</span><span class="p">;</span> - <span class="n">widget_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'widget'</span><span class="p">;</span> - <span class="n">granted_authority_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'granted_authority'</span><span class="p">;</span> - <span class="n">widget_comment_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'widget_comment'</span><span class="p">;</span> - <span class="n">widget_rating_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'widget_rating'</span><span class="p">;</span> - <span class="n">portal_preference_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'portal_preference'</span><span class="p">;</span> - <span class="n">tag_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'tag'</span><span class="p">;</span> - <span class="n">widget_tag_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'widget_tag'</span><span class="p">;</span> - <span class="n">category_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'category'</span><span class="p">;</span> - <span class="n">page_type_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">128</span><span class="p">)</span> <span class="p">:</span><span class="o">=</span> <span class="s">'page_type'</span><span class="p">;</span> + <span class="n">page_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'page'</span><span class="p">;</span> + <span class="n">page_layout_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'page_layout'</span><span class="p">;</span> + <span class="n">region_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'region'</span><span class="p">;</span> + <span class="n">region_widget_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'region_widget'</span><span class="p">;</span> + <span class="n">user_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'person'</span><span class="p">;</span> + <span class="n">person_association_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'person_association'</span><span class="p">;</span> + <span class="n">groups_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'groups'</span><span class="p">;</span> + <span class="n">group_members_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'group_members'</span><span class="p">;</span> + <span class="n">widget_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'widget'</span><span class="p">;</span> + <span class="n">granted_authority_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'granted_authority'</span><span class="p">;</span> + <span class="n">widget_comment_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'widget_comment'</span><span class="p">;</span> + <span class="n">widget_rating_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'widget_rating'</span><span class="p">;</span> + <span class="n">portal_preference_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'portal_preference'</span><span class="p">;</span> + <span class="n">tag_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'tag'</span><span class="p">;</span> + <span class="n">widget_tag_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'widget_tag'</span><span class="p">;</span> + <span class="n">category_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'category'</span><span class="p">;</span> + <span class="n">page_type_seq</span> <span class="n">VARCHAR2</span><span class="p">(</span>128<span class="p">)</span> <span class="p">:=</span> <span class="s">'page_type'</span><span class="p">;</span> <span class="n">user_authority_id</span> <span class="n">NUMBER</span><span class="p">;</span> <span class="n">col_id</span> <span class="n">NUMBER</span><span class="p">;</span> -<span class="k">BEGIN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Apache Rave Initialisation script starting'</span><span class="p">);</span> - <span class="k">BEGIN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Dropping table RAVE_PORTAL_SEQUENCES'</span><span class="p">);</span> +<span class="n">BEGIN</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Apache Rave Initialisation script starting'</span><span class="p">);</span> + <span class="n">BEGIN</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Dropping table RAVE_PORTAL_SEQUENCES'</span><span class="p">);</span> <span class="n">EXECUTE</span> <span class="n">IMMEDIATE</span> <span class="s">'DROP TABLE RAVE_PORTAL_SEQUENCES'</span><span class="p">;</span> <span class="n">EXCEPTION</span> <span class="n">WHEN</span> <span class="n">OTHERS</span> <span class="n">THEN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Error '</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span><span class="p">);</span> - <span class="k">END</span><span class="p">;</span> - <span class="k">BEGIN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Creating table RAVE_PORTAL_SEQUENCES'</span><span class="p">);</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Error '</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span><span class="p">);</span> + <span class="n">END</span><span class="p">;</span> + <span class="n">BEGIN</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Creating table RAVE_PORTAL_SEQUENCES'</span><span class="p">);</span> <span class="n">EXECUTE</span> <span class="n">IMMEDIATE</span> <span class="s">'CREATE TABLE RAVE_PORTAL_SEQUENCES (seq_name VARCHAR(255) PRIMARY KEY NOT NULL,seq_count NUMBER(19))'</span><span class="p">;</span> <span class="n">EXCEPTION</span> <span class="n">WHEN</span> <span class="n">OTHERS</span> <span class="n">THEN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Error'</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span><span class="p">);</span> - <span class="k">END</span><span class="p">;</span> - <span class="k">BEGIN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Inserting RAVE_PORTAL_SEQUENCES values'</span><span class="p">);</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Error'</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span><span class="p">);</span> + <span class="n">END</span><span class="p">;</span> + <span class="n">BEGIN</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Inserting RAVE_PORTAL_SEQUENCES values'</span><span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> <span class="p">(</span> @@ -314,7 +324,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">page_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -325,7 +335,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">page_layout_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -336,7 +346,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">region_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -347,7 +357,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">region_widget_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -358,7 +368,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="s">'region_widget_preference'</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -369,7 +379,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">user_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -380,7 +390,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">person_association_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -391,7 +401,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">groups_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -402,7 +412,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">group_members_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -413,7 +423,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">widget_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -424,7 +434,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">widget_comment_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -435,7 +445,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">widget_rating_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -446,7 +456,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">granted_authority_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -457,12 +467,12 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">portal_preference_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> <span class="p">(</span><span class="n">seq_name</span><span class="p">,</span> <span class="n">seq_count</span> <span class="p">)</span> <span class="n">VALUES</span> - <span class="p">(</span><span class="n">tag_seq</span><span class="p">,</span> <span class="mi">1</span> + <span class="p">(</span><span class="n">tag_seq</span><span class="p">,</span> 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -473,7 +483,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">widget_tag_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -484,7 +494,7 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">category_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> @@ -495,19 +505,19 @@ OpenJPA can create the schema. With help <span class="n">VALUES</span> <span class="p">(</span> <span class="n">page_type_seq</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">EXCEPTION</span> <span class="n">WHEN</span> <span class="n">OTHERS</span> <span class="n">THEN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span> <span class="p">(</span> <span class="s">'Error'</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span> <span class="p">)</span> <span class="p">;</span> - <span class="k">END</span><span class="p">;</span> - <span class="k">BEGIN</span> - <span class="sr">/* USER */</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span> + <span class="n">END</span><span class="p">;</span> + <span class="n">BEGIN</span> + <span class="o">/*</span> <span class="n">USER</span> <span class="o">*/</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span> <span class="p">(</span> <span class="s">'Inserting granted_authority USER value'</span> <span class="p">)</span> @@ -515,7 +525,7 @@ OpenJPA can create the schema. With help <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">user_authority_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">granted_authority</span> <span class="p">(</span> @@ -527,17 +537,17 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">user_authority_id</span><span class="p">,</span> <span class="s">'ROLE_USER'</span><span class="p">,</span> - <span class="mi">1</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Inserting granted_authority ADMIN value'</span><span class="p">);</span> - <span class="sr">/* ADMIN */</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Inserting granted_authority ADMIN value'</span><span class="p">);</span> + <span class="o">/*</span> <span class="n">ADMIN</span> <span class="o">*/</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">user_authority_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">granted_authority</span> <span class="p">(</span> @@ -549,21 +559,21 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">user_authority_id</span><span class="p">,</span> <span class="s">'ROLE_ADMIN'</span><span class="p">,</span> - <span class="mi">0</span> + 0 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">granted_authority_seq</span><span class="p">;</span> <span class="n">EXCEPTION</span> <span class="n">WHEN</span> <span class="n">OTHERS</span> <span class="n">THEN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span> <span class="p">(</span> <span class="s">'Error'</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span> <span class="p">)</span> <span class="p">;</span> - <span class="k">END</span><span class="p">;</span> - <span class="k">BEGIN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Inserting page_layout values'</span><span class="p">);</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span> <span class="p">(</span> <span class="s">'Error'</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span> <span class="p">)</span> <span class="p">;</span> + <span class="n">END</span><span class="p">;</span> + <span class="n">BEGIN</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span><span class="p">(</span><span class="s">'Inserting page_layout values'</span><span class="p">);</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -576,16 +586,16 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_1'</span><span class="p">,</span> - <span class="mi">1</span><span class="p">,</span> - <span class="mi">0</span> + 1<span class="p">,</span> + 0 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -599,17 +609,17 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_2'</span><span class="p">,</span> - <span class="mi">2</span><span class="p">,</span> - <span class="mi">1</span><span class="p">,</span> - <span class="mi">1</span> + 2<span class="p">,</span> + 1<span class="p">,</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -623,17 +633,17 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_2wn'</span><span class="p">,</span> - <span class="mi">2</span><span class="p">,</span> - <span class="mi">2</span><span class="p">,</span> - <span class="mi">1</span> + 2<span class="p">,</span> + 2<span class="p">,</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -647,17 +657,17 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_3'</span><span class="p">,</span> - <span class="mi">3</span><span class="p">,</span> - <span class="mi">3</span><span class="p">,</span> - <span class="mi">1</span> + 3<span class="p">,</span> + 3<span class="p">,</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -671,17 +681,17 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_3nwn'</span><span class="p">,</span> - <span class="mi">3</span><span class="p">,</span> - <span class="mi">4</span><span class="p">,</span> - <span class="mi">1</span> + 3<span class="p">,</span> + 4<span class="p">,</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -695,17 +705,17 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_3_newuser'</span><span class="p">,</span> - <span class="mi">3</span><span class="p">,</span> - <span class="mi">5</span><span class="p">,</span> - <span class="mi">1</span> + 3<span class="p">,</span> + 5<span class="p">,</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -719,17 +729,17 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_4'</span><span class="p">,</span> - <span class="mi">4</span><span class="p">,</span> - <span class="mi">6</span><span class="p">,</span> - <span class="mi">1</span> + 4<span class="p">,</span> + 6<span class="p">,</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">SELECT</span> <span class="n">seq_count</span> <span class="n">INTO</span> <span class="n">col_id</span> <span class="n">FROM</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">INSERT</span> <span class="n">INTO</span> <span class="n">page_layout</span> <span class="p">(</span> @@ -743,18 +753,18 @@ OpenJPA can create the schema. With help <span class="p">(</span> <span class="n">col_id</span><span class="p">,</span> <span class="s">'columns_3nwn_1_bottom'</span><span class="p">,</span> - <span class="mi">4</span><span class="p">,</span> - <span class="mi">7</span><span class="p">,</span> - <span class="mi">1</span> + 4<span class="p">,</span> + 7<span class="p">,</span> + 1 <span class="p">);</span> <span class="n">UPDATE</span> <span class="n">RAVE_PORTAL_SEQUENCES</span> - <span class="n">SET</span> <span class="n">seq_count</span> <span class="o">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> <span class="mi">1</span><span class="p">)</span> - <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="o">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> + <span class="n">SET</span> <span class="n">seq_count</span> <span class="p">=</span> <span class="p">(</span><span class="n">seq_count</span> <span class="o">+</span> 1<span class="p">)</span> + <span class="n">WHERE</span> <span class="n">seq_name</span> <span class="p">=</span> <span class="n">page_layout_seq</span><span class="p">;</span> <span class="n">EXCEPTION</span> <span class="n">WHEN</span> <span class="n">OTHERS</span> <span class="n">THEN</span> - <span class="n">dbms_output</span><span class="o">.</span><span class="n">put_line</span> <span class="p">(</span> <span class="s">'Error'</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span> <span class="p">)</span> <span class="p">;</span> - <span class="k">END</span><span class="p">;</span> -<span class="k">END</span><span class="p">;</span> + <span class="n">dbms_output</span><span class="p">.</span><span class="n">put_line</span> <span class="p">(</span> <span class="s">'Error'</span> <span class="o">||</span> <span class="n">SQLCODE</span> <span class="o">||</span> <span class="s">' - '</span> <span class="o">||</span> <span class="n">SQLERRM</span> <span class="p">)</span> <span class="p">;</span> + <span class="n">END</span><span class="p">;</span> +<span class="n">END</span><span class="p">;</span> </pre></div> </article> </section>
Modified: websites/staging/rave/trunk/content/documentation/configure-locked-domain.html ============================================================================== --- websites/staging/rave/trunk/content/documentation/configure-locked-domain.html (original) +++ websites/staging/rave/trunk/content/documentation/configure-locked-domain.html Sun Feb 7 21:02:46 2016 @@ -29,6 +29,7 @@ </head> <body> + <div style="background: red"><h1>2016/02/07 - Apache Rave has been retired. </h1><h2>For more information, please explore the <a href="http://attic.apache.org/";>Attic</a>. </h2></div> <div class="navbar navbar-inverse navbar-fixed-top"> <div class="navbar-inner"> @@ -87,22 +88,33 @@ </header> <section id="content" class="row"> <article class="span12"> - <h2 id="prerequisites">Prerequisites</h2> + <style type="text/css"> +/* The following code is added by mdx_elementid.py + It was originally lifted from http://subversion.apache.org/style/site.css */ +/* + * Hide class="elementid-permalink", except when an enclosing heading + * has the :hover property. + */ +.headerlink, .elementid-permalink { + visibility: hidden; +} +h2:hover > .headerlink, h3:hover > .headerlink, h1:hover > .headerlink, h6:hover > .headerlink, h4:hover > .headerlink, h5:hover > .headerlink, dt:hover > .elementid-permalink { visibility: visible }</style> +<h2 id="prerequisites">Prerequisites<a class="headerlink" href="#prerequisites" title="Permanent link">¶</a></h2> <p>To follow these instructions you'll need a working copy of Apache Rave up and running under Tomcat 6. Please see the <a href="installing.html">Installing Rave</a> page for instructions on how to get up and running.</p> -<h2 id="enabling-locked-domain-support-in-apache-rave">Enabling Locked Domain Support in Apache Rave</h2> +<h2 id="enabling-locked-domain-support-in-apache-rave">Enabling Locked Domain Support in Apache Rave<a class="headerlink" href="#enabling-locked-domain-support-in-apache-rave" title="Permanent link">¶</a></h2> <p>These instructions demonstrate how to get Apache Shindig locked domain support up and running in Apache Rave. Locked domains take advantage of the web browsers domain-based sandboxing policies to isolate gadgets from each other and the main container page. The Shindig mailing list is a good source of information for more details regarding locked domains.</p> <p>Enabling locked domain support within Apache Rave is achieved via a combination of DNS and Shindig configuration changes. To fully support locked domain in a production environment you'll likely need to setup and configure your locked domain with wildcard DNS (otherwise you'd have to create manual DNS entries for every single gadget that you want to run on a locked domain). For the purposes of experimenting with locked domain however just adding entries to the "hosts" file for the gadgets on a default Apache Rave page should be sufficient. The Shindig configuration changes required are enabling locked domain support in the top level Shindig configuration and then configuring the individual Shindig container via the container.js file.</p> <p>The sample locked domain we'll use here will be "-locked.gadgets.example.com".</p> <p>The default locked domain implementation within Shindig generates locked domain URL's by taking a hash of the gadget specification URL and pre-pending it onto the configured locked domain suffix. Here are the locked domain entries that were added to my local "hosts" file to support the default gadgets on an Apache Rave page at the time this documentation was written:</p> -<div class="codehilite"><pre> <span class="mf">127.0.0.1</span> <span class="n">v6fvvlv3hm7kt7oj96mug1uvrdke6kpg</span><span class="o">-</span><span class="n">locked</span><span class="o">.</span><span class="n">gadgets</span><span class="o">.</span><span class="n">example</span><span class="o">.</span><span class="n">com</span> - <span class="mf">127.0.0.1</span> <span class="mi">76</span><span class="n">r748j1k68i8t7v35r0oakjtb0uvpr3</span><span class="o">-</span><span class="n">locked</span><span class="o">.</span><span class="n">gadgets</span><span class="o">.</span><span class="n">example</span><span class="o">.</span><span class="n">com</span> - <span class="mf">127.0.0.1</span> <span class="n">tqfbbnhq7v3nah5ifshpfrg5i9elegum</span><span class="o">-</span><span class="n">locked</span><span class="o">.</span><span class="n">gadgets</span><span class="o">.</span><span class="n">example</span><span class="o">.</span><span class="n">com</span> - <span class="mf">127.0.0.1</span> <span class="n">fdtj4i7cslo8149tjpt9778jodkds1is</span><span class="o">-</span><span class="n">locked</span><span class="o">.</span><span class="n">gadgets</span><span class="o">.</span><span class="n">example</span><span class="o">.</span><span class="n">com</span> +<div class="codehilite"><pre> 127<span class="p">.</span>0<span class="p">.</span>0<span class="p">.</span>1 <span class="n">v6fvvlv3hm7kt7oj96mug1uvrdke6kpg</span><span class="o">-</span><span class="n">locked</span><span class="p">.</span><span class="n">gadgets</span><span class="p">.</span><span class="n">example</span><span class="p">.</span><span class="n">com</span> + 127<span class="p">.</span>0<span class="p">.</span>0<span class="p">.</span>1 76<span class="n">r748j1k68i8t7v35r0oakjtb0uvpr3</span><span class="o">-</span><span class="n">locked</span><span class="p">.</span><span class="n">gadgets</span><span class="p">.</span><span class="n">example</span><span class="p">.</span><span class="n">com</span> + 127<span class="p">.</span>0<span class="p">.</span>0<span class="p">.</span>1 <span class="n">tqfbbnhq7v3nah5ifshpfrg5i9elegum</span><span class="o">-</span><span class="n">locked</span><span class="p">.</span><span class="n">gadgets</span><span class="p">.</span><span class="n">example</span><span class="p">.</span><span class="n">com</span> + 127<span class="p">.</span>0<span class="p">.</span>0<span class="p">.</span>1 <span class="n">fdtj4i7cslo8149tjpt9778jodkds1is</span><span class="o">-</span><span class="n">locked</span><span class="p">.</span><span class="n">gadgets</span><span class="p">.</span><span class="n">example</span><span class="p">.</span><span class="n">com</span> </pre></div> <p>For the Shindig configuration changes please refer to the patch generated from my local changes below. With these changes in place you should be able to fire up Apache Rave, access the default page as one of the sample users and see the locked domains being utilized in the gadget iframe URL's.</p> -<h2 id="complete-diff-of-modified-files-follows">Complete diff of modified files follows</h2> +<h2 id="complete-diff-of-modified-files-follows">Complete diff of modified files follows<a class="headerlink" href="#complete-diff-of-modified-files-follows" title="Permanent link">¶</a></h2> <div class="codehilite"><pre> Index: rave-project/rave-shindig/src/main/webapp/WEB-INF/classes/containers/default/container.js =================================================================== --- rave-project/rave-shindig/src/main/webapp/WEB-INF/classes/containers/default/container.js (revision 1228369)
