Databases
Borg will create an H2 database in a default location when started after the first install. Most users should never alter the database settings. Some users may want to alter the location of the database, for example to be on a removable drive.
For those users that want to change the default settings, the available choices are:
HSQLDB
H2
MySQL
There is also a Generic JDBC option, which takes a jdbc url. This can be used by more advanced users if non-standard URL options are needed. It is not guaranteed to work in all cases.
H2
Support for H2 is new in release 1.7.5 and is the default as of 1.7.7. BORG will manage the H2 files without any actions from the user. No pre-requisite software is needed.
HSQLDB
BORG continues to support HSQLDB. No pre-requisite software is needed.
MySQL
Using MySQL with BORG requires the user to download at setup the MySQL software. In addition, the user must also download and install a JDBC database driver for MySQL.
Some familiarity with MYSQL is assumed in the instructions below.
To use RDBMS support with MYSQL:
1.Install MYSQL and make it accessible on your machine or network. See www.mysql.com for the software (which is free).
2. Create a database for BORG data in MYSQL. Name it whatever you like.
3. Create a user with at least select/insert/update/delete access to your database
4. Create the BORG
database tables in your database. This is done by running the SQL
contained in the borg_mysql.sql file that comes with BORG. From the
mysql command line you would do this:
mysql>use
your-database-name
mysql>source borg_mysql.sql <=== you need
the full path to borg_mysql.sql if it is not in your current folder.
5.BORG looks for a database driver for MYSQL in the CLASSPATH. The driver is ** NOT ** shipped with BORG. You have to download and install this separately. As with H2, you can enable the dynamic loading option and then put the mysql driver JAR in the BORG lib/ext folder. You can also put it elsewhere in the Java CLASSPATH.
6. Run BORG and set the MySQL database parameters from the database options screen.