Upgrade MySQL Client Lib

Upgrade MySQL Client Lib

The Problem

Chico Charlesworth noticed a problem with the MySQL client library (Connector/J) currently in use with Mifos.

Proposed Solution

Upgrade to Connector/J 5.1.

Due Diligence

Please share your results of trying out the new JAR.

  1. Update your trunk working copy to the latest revision

  2. Remove mysql-connector-java-3.1.13-bin.jar from the lib dir of the Mifos source tree

  3. Add mysql-connector-java-5.1.5-bin.jar to the lib dir of the Mifos source tree. SHA-1 checksum of the JAR should be c8000ccd9e6b1d99beca369c715ec5151dabadfb

  4. Change database.driver.jar property in toplevel build.xml to point to ./lib/mysql-connector-java-5.1.5-bin.jar

  5. Run unit tests

  6. Deploy WAR, try out Mifos Web UI by, for instance, creating a loan instance

  7. Record your findings in the table below
    csv-table:: Due Diligence Tests:header: Date, Your Name, MySQL Version, App Server, OS, Machine Architecture, All Unit Tests Passed?, Test Deployment Succeeded?

Completion

The upgrade was completed on 29-FEB-2008, committed as revision 12340.