BW 3. 7 Link to Your Database

Edit bedework-ds.xml to connect Bedework to your database

If you have based your configuration on one of the samples, you should already have a mostly-correct <datasource> stanza inside bedework-ds.xml.  Within that stanza, edit <connection-url> which includes three parts you need to adjust: database host, port number, and database name.   You'll also need to edit <user-name> (the database user) and <password> (the database user's password).

Add JDBC Drivers to JBoss (in most cases, done for you)

Again, if you've based your configuration on one of the samples, you should have an appropriate JDBC driver in lib/server.   During the build, that driver will be copied into <quickstart>/jboss-5.1.0.GA/server/default/lib.   If you'd like to update that driver, replace the one in lib/server, then rebuild.

For non-standard configurations only: Configure Hibernate to work with your database

Setting your SQL dialect

Configuring Hibernate to use the appropriate dialect is done in cal.properties. You need to set a few properties

org.bedework.global.hibernate.dialect=yourDialect

The value yourDialect is a defined Hibernate SQL dialect such as org.hibernate.dialect.HSQLDialect or org.hibernate.dialect.MySQL5Dialect. The dialect is a class defined on the class path. Hibernate defines a number of ‘standard’ dialects.

For example, the global property if using MySQL5 would be

org.bedework.global.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

A list of dialects understood by Hibernate can be found at:

http://www.hibernate.org/hib_docs/v3/reference/en/html/session-configuration.html#configuration-optional-dialects

You can also look at the org.hibernate.dialect classes in the Hibernate jar file (for example, to use MySQL 5 which is not currently listed in the on-line Hibernate documentation, use org.hibernate.dialect.MySQL5Dialect ).