Drone : Configuration Database This page last changed on Feb 15, 2005 by gbevin. Drone only needs a database if you use modules that need to store information. This setup is thus only needed when you use the faq, log or seen module. The database is configured as a RIFE datasource and it is setup in the `datasources.xml` file. Below is a sample datasource configuration file:
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <!DOCTYPE datasources SYSTEM "/dtd/datasources.dtd">
    <datasources>
        <datasource name="postgresql">
            <driver>org.postgresql.Driver</driver>
            <url>jdbc:postgresql://localhost:5432/drone</url>
            <user>drone</user>
            <password>password</password>
            <poolsize>10</poolsize>
        </datasource>
    </datasources>
It should be pretty trivial to configure this. Drone has currently been tested with PostgreSQL, MySQL, McKoiSQL, Apache Derby, HsqlDB and DaffodilDB. The JDBC drivers for PostgreSQL and Mysql are included in Drone, to be able to use the other databases you have to download the required jars from their websites and put them in your classpath. Look at the website of your favourite database for installation instructions. To activate the datasource you have to configure the global settings.

Document generated by Confluence on Feb 15, 2005 12:31