Wednesday, July 27, 2011

GCE11 Workshop Scheduled

The Gateway Computing Environments 2011 workshop will be at Supercomputing 2011.  Submissions are open and welcome.  See http://www.collab-ogce.org/gce11/index.php/Main_Page  for more information.

Changing Apache Rave's backing database

Apache Rave provides software for running a social networking portal. The default download uses the H2 in-memory relational database on the backend. To change this to MySQL, PostgreSQL or another external database, you need to do the following:
  • Edit the file rave-portal/src/main/webapp/WEB-INF/dataContext.xml to use the desired JDBC driver; and
  • Download the appropriate database driver jar file and place it in the WEB-INF/lib directory of your portal's tomcat server.
    • If you are starting the server with "mvn cargo:start", this is rave-portal/target/tomcat6x/webapps/portal/WEB-INF/lib/|
    • You probably will want to install the JDBC driver jar in your local Maven repository and put the dependency in rave-portal/pom.xml.
It is also worth reviewing the dataContext.xml file.  The H2 database default user name and password are here (you may want to update) and has a console running on port 11111.  You can point your browser to http://localhost:1111/ and login.  You can also change the default behavior of H2 to use files for persistence.