Database Configuration

Jetspeed should work with any JDBC 2.0 complaint driver. The following databases have been tested:

• DB2
• Hypersonic SQL
• MySQL
• Oracle
• Postgres
• Sybase

Scripts for setting up the database are included with the source code distribution, under the src/sql/external folder. To change the database connection, you will also need to have the source code since Jetspeed uses Torque. Torque generates Java bindings specific to the backend database, requiring that the source be rebuilt. The war file installation automatically configures Hypersonic SQL as the default database.

Steps to configure Jetspeed with another database:

• 1. Edit project.properties (or your $HOME/build.properties), and set the 'database' property to one of these values [db2,hypersonic,mysql,oracle,postgresql,mssql,sybase]
• 2. Edit webapp/WEB-INF/conf/Torque.properties. Uncomment and change the following properties for your database:

  ### MySQL
  ### torque.dsfactory.default.connection.driver = org.gjt.mm.mysql.Driver
  ### torque.dsfactory.default.connection.url = jdbc:mysql://localhost:3306/jetspeed
  ### torque.dsfactory.default.connection.user =  root
  ### torque.dsfactory.default.connection.password = 
  ### Oracle
  ### torque.dsfactory.default.connection.driver = oracle.jdbc.driver.OracleDriver
  ### torque.dsfactory.default.connection.url = jdbc:oracle:thin:@nirvana:1521:bluesun3
  ### torque.dsfactory.default.connection.user =  jetspeed
  ### torque.dsfactory.default.connection.password = jetspeed
  ### Microsoft SQL
  ### torque.dsfactory.default.connection.driver = net.avenir.jdbc3.Driver
  ### torque.dsfactory.default.connection.url = jdbc: AvenirDriver://localhost:1433/jetspeed
  ### torque.dsfactory.default.connection.user =  jetspeed
  ### torque.dsfactory.default.connection.password = jetspeed
  

• 3. Rebuild the source: maven dist
• 4. Run the database 2 turbine- and populate- scripts for your particular database found in src/sql/external