MultipleDatabases

Multiple Databases

• Is there an easy way in Appfuse to switch between various databases?

If you use many different Databases, you can point AppFuse to the various instances by having 1 properties file for each db driver/type. Then in the properties.xml file:

    <property name="db.driver" value="mysql"/>
    <property file="${db.driver}.properties"/>
    <propertycopy name="database.jar.path" from="${database.type}.jar" silent="true"/>
    <property name="database.jar" location="${database.jar.path}"/>

So you can do builds with -Ddb.driver=mysql or -Ddb.driver=db2.typeII and the builds will load mysql.properties or db2.typeII.properties as the database configuration file.

Great tip from Matthew Fleming!

mysql.properties

541 bytes