Raible's Wiki

Raible Designs
Wiki Home
News
Recent Changes

AppFuse

Homepage
  - Korean
  - Chinese
  - Italian
  - Japanese

QuickStart Guide
  - Chinese
  - French
  - German
  - Italian
  - Korean
  - Portuguese
  - Spanish
  - Japanese

User Guide
  - Korean
  - Chinese

Tutorials
  - Chinese
  - German
  - Italian
  - Korean
  - Portuguese
  - Spanish

FAQ
  - Korean

Latest Downloads

Other Applications

Struts Resume
Security Example
Struts Menu

Set your name in
UserPreferences


Referenced by
AppFuseSupport




JSPWiki v2.2.33

[RSS]


Hide Menu

MultipleDatabases


Difference between version 2 and version 1:

At line 2 added 1 line.
!!Multiple Databases
At line 3 changed 6 lines.
We use many different dbs in both test and production.. To achieve this easily we have 1 properties file for each db driver/type. Then in the properties.xml file:
<!-- DB properties setup -->
<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}"/>
* Is there an easy way in Appfuse to switch between various databases?
At line 10 changed 1 line.
so we 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.
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!

Back to MultipleDatabases, or to the Page History.