Author: raminder
Date: Mon Jan 28 19:24:45 2013
New Revision: 1439593
URL: http://svn.apache.org/viewvc?rev=1439593&view=rev
Log:
updated location and variable name
Modified:
rave/site/trunk/content/documentation/configure-database.mdtext
Modified: rave/site/trunk/content/documentation/configure-database.mdtext
URL:
http://svn.apache.org/viewvc/rave/site/trunk/content/documentation/configure-database.mdtext?rev=1439593&r1=1439592&r2=1439593&view=diff
==============================================================================
--- rave/site/trunk/content/documentation/configure-database.mdtext (original)
+++ rave/site/trunk/content/documentation/configure-database.mdtext Mon Jan 28
19:24:45 2013
@@ -25,7 +25,7 @@ separate web applications but share data
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.
<bean id="dataSourcePopulator"
class="org.apache.rave.jdbc.util.DataSourcePopulator">
- <property name="executeScriptQuery" value="SELECT * FROM WIDGET"/>
+ <property name="executeScriptQuery" value="SELECT * FROM widget"/>
<property name="scriptLocations">
<list>
<value>classpath:initial_data.sql</value>
@@ -59,7 +59,7 @@ Make sure the JDBC driver ends up in the
If you remove the H2 JDBC driver from the classpath, you need to override the
`dataContext.xml` Spring configuration file. Remove the configuration for the
H2 Web console. This is the bean with class `org.h2.tools.Server`.
Then customize the properties for the portal and Shindig to use the database
of your choice.
-The default portal properties can be found in
`rave-portal/src/main/resources/portal.properties`, the default Shindig
properties in `rave-shindig/src/main/resource/rave.shindig.properties`.
+The default portal properties can be found in
`rave-portal-resources/src/main/resources/portal.properties`, the default
Shindig properties in
`rave-providers/rave-opensocial-provider/rave-opensocial-server/rave-shindig/src/main/resources/rave.shindig.properties`.
## Sample values
@@ -77,25 +77,25 @@ The default portal properties can be fou
#### Properties
Apache Rave portal:
- portal.dataSource.url=jdbc:mysql://localhost:3306/rave
- portal.dataSource.driver=com.mysql.jdbc.Driver
- portal.dataSource.username=rave
- portal.dataSource.password=rave
+ jpa.dataSource.url=jdbc:mysql://localhost:3306/rave
+ jpa.dataSource.driver=com.mysql.jdbc.Driver
+ jpa.dataSource.username=rave
+ jpa.dataSource.password=rave
- portal.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
-
portal.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.MySQLDictionary
- portal.jpaVendorAdapter.database=MYSQL
+ jpa.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
+
jpa.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.MySQLDictionary
+ jpa.jpaVendorAdapter.database=MYSQL
OpenSocial data (Apache Shindig):
- rave-shindig.dataSource.url=jdbc:mysql://localhost:3306/rave
- rave-shindig.dataSource.driver=com.mysql.jdbc.Driver
- rave-shindig.dataSource.username=rave
- rave-shindig.dataSource.password=rave
+ jpa.dataSource.url=jdbc:mysql://localhost:3306/rave
+ jpa.dataSource.driver=com.mysql.jdbc.Driver
+ jpa.dataSource.username=rave
+ jpa.dataSource.password=rave
- rave-shindig.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
-
rave-shindig.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.MySQLDictionary
- rave-shindig.jpaVendorAdapter.database=MYSQL
+ jpa.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
+
jpa.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.MySQLDictionary
+ jpa.jpaVendorAdapter.database=MYSQL
#### Notes
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 `allowMultiQueries=true` to the driver URL.
@@ -112,25 +112,25 @@ The DataSourcePopulator uses a single st
#### Properties
Apache Rave portal:
- portal.dataSource.url=jdbc:postgresql://localhost:5432/rave
- portal.dataSource.driver=org.postgresql.Driver
- portal.dataSource.username=rave
- portal.dataSource.password=rave
+ jpa.dataSource.url=jdbc:postgresql://localhost:5432/rave
+ jpa.dataSource.driver=org.postgresql.Driver
+ jpa.dataSource.username=rave
+ jpa.dataSource.password=rave
- portal.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
-
portal.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.PostgresDictionary
- portal.jpaVendorAdapter.database=POSTGRESQL
+ jpa.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
+
jpa.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.PostgresDictionary
+ jpa.jpaVendorAdapter.database=POSTGRESQL
OpenSocial data (Apache Shindig):
- rave-shindig.dataSource.url=jdbc:postgresql://localhost:5432/rave
- rave-shindig.dataSource.driver=org.postgresql.Driver
- rave-shindig.dataSource.username=rave
- rave-shindig.dataSource.password=rave
+ jpa.dataSource.url=jdbc:postgresql://localhost:5432/rave
+ jpa.dataSource.driver=org.postgresql.Driver
+ jpa.dataSource.username=rave
+ jpa.dataSource.password=rave
- rave-shindig.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
-
rave-shindig.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.PostgresDictionary
- rave-shindig.jpaVendorAdapter.database=POSTGRESQL
+ jpa.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
+
jpa.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.PostgresDictionary
+ jpa.jpaVendorAdapter.database=POSTGRESQL
#### Notes
- The DataSourcePopulator cannot handle a PostgreSQL database that has not
yet been initialized.
@@ -144,25 +144,25 @@ Install the [Oracle JDBC driver][5] in t
#### Properties
Apache Rave portal:
- portal.dataSource.url=jdbc:oracle:thin:@localhost:1521:rave
- portal.dataSource.driver=oracle.jdbc.OracleDriver
- portal.dataSource.username=rave
- portal.dataSource.password=rave
-
- portal.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
-
portal.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.OracleDictionary
- portal.jpaVendorAdapter.database=ORACLE
+ jpa.dataSource.url=jdbc:oracle:thin:@localhost:1521:rave
+ jpa.dataSource.driver=oracle.jdbc.OracleDriver
+ jpa.dataSource.username=rave
+ jpa.dataSource.password=rave
+
+ jpa.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
+
jpa.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.OracleDictionary
+ jpa.jpaVendorAdapter.database=ORACLE
OpenSocial data (Apache Shindig):
- rave-shindig.dataSource.url=jdbc:oracle:thin:@localhost:1521:rave
- rave-shindig.dataSource.driver=oracle.jdbc.OracleDriver
- rave-shindig.dataSource.username=rave
- rave-shindig.dataSource.password=rave
-
- rave-shindig.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
-
rave-shindig.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.OracleDictionary
- rave-shindig.jpaVendorAdapter.database=ORACLE
+ jpa.dataSource.url=jdbc:oracle:thin:@localhost:1521:rave
+ jpa.dataSource.driver=oracle.jdbc.OracleDriver
+ jpa.dataSource.username=rave
+ jpa.dataSource.password=rave
+
+ jpa.jpaDialect=org.springframework.orm.jpa.DefaultJpaDialect
+
jpa.jpaVendorAdapter.databasePlatform=org.apache.openjpa.jdbc.sql.OracleDictionary
+ jpa.jpaVendorAdapter.database=ORACLE
#### Initial data
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.
