Database Configuration For Jetspeed

The default Jetspeed deployment uses its own security model to authorize users and persist minimal user information. Turbine security should work with any JDBC 2.0 compliant driver. The following databases are tested:

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

Jetspeed is distributed with a populated Hypersonic-SQL database. This database is selected as the default database in the Torque.properties file. To configure Jetspeed with a different database, modify BOTH the project.properties in the root directory and the webapp/WEB-INF/conf/Torque.properties file. Here is an example for MySQL:

• torque.database.default.adapter=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 =

Another example for Oracle:

• torque.database.default.adapter=oracle
• torque.dsfactory.default.connection.driver = oracle.jdbc.driver.OracleDriver
• torque.dsfactory.default.connection.url = jdbc:oracle:thin:@<host>:1521:<sid>
• torque.dsfactory.default.connection.user = <username>
• torque.dsfactory.default.connection.password = <password>

You will need to replace:

<host>	the host of the Oracle instance, such as localhost
<sid>	the name of Oracle database sid at the host
<username>	the oracle user(schema) name

The Torque.properties file can be found in /webapp/WEB-INF/conf.

The database scripts for setting up the database are included with the source code distribution, under the src/sql/external folder. Run the appropriate script, such as turbine-db2.sql for DB2, to create the database tables. This step is not necessary with Hypersonic SQL.

To populate the database, scripts are provided: /src/sql/external/populate*.sql. Only run the statements for your specific database as commented.

The script will create two database users:

• Login: turbine Password: turbine
• Login: admin Password: jetspeed

If you would also like to store your PSML resources in the database, see the instructions here.