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?

    15-FEB-2008, Adam Monsen, 5.0.45, Tomcat 6.0.14, Ubuntu 7.10, Intel x86, Cannot test (not enough RAM), Yes 15-FEB-2008, Adam Monsen, 5.0.45, n/a, Fedora 8, Intel x86, Yes, not tested 18-FEB-2008, Stephen Horgan, 5.0.51a, Jetty 6.1.7, Windows XP, Intel x86, Yes, Yes 19-FEB-2008, Jeff Brewster, 5.0.51a, Tomcat 5.5.26, Windows XP, Intel x86, Yes, Yes 25-FEB-2008, Chico Charlesworth, 5.0.51a, Tomcat 6.0.14, Windows XP, Intel x86, Yes, Yes


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