Edit the four bedework*-ds.xml files 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: need to edit these four configuration files:
- bwbuild/myconfig/bedework-ds.xml: contains information about how to access your Bedework calendar server database
- bwbuild/myconfig/bedework-tz-ds.xml: contains information about how to access your Bedework timezone server database
- bwbuild/myconfig/bedework-synch-ds.xml: contains information about how to access your Bedework synchronization server database
- bwbuild/myconfig/bedework-card-ds.xml: contains information about how to access your Bedework carddav server database
In each case, within the <datasource> stanza:
- edit <connection-url> to set the database host, port number, and database name.
...
- 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 bwbuild/myconfig/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 bwbuild/myconfig/lib/server, then rebuild.
...
Non-standard configurations
The following steps will help you configure a non-standard
...
/ unsupported database with Bedework.
Configure Hibernate to work with your database
...
's SQL dialect
Configuring Hibernate to use the appropriate dialect is done in bwbuild/myconfig/cal.properties. You need to set a few properties
...
For example, the global property if using MySQL5 would be
| Code Block |
|---|
org.bedework.global.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
|
...