Wednesday, July 27, 2011

GCE11 Workshop Scheduled

The Gateway Computing Environments 2011 workshop will be at Supercomputing 2011.  Submissions are open and welcome.  See  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.