Pramod, I could not reproduce the problem. I followed your instructions, starting with revision 12427, and the unit tests ran successfully.
Keith On Fri, Mar 7, 2008 at 7:27 AM, Pramod Biligiri <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] wrote on 03/04/2008 07:57:59 > PM: > > > Could you describe the problem exactly? I'm not convinced what you're > > seeing is related to the version of MySQL Connector/J we're using. > > > Adam Monsen > > Hi Adam, > One of the queries in our Branch Report retrieves all records matching a > user entered > date, which is the date when the batch job was run. As soon as we upgraded > to the > new Mysql Connector/J, this query started returning an empty list. > Therefore we created > the testcase (that I had attached earlier in this thread). The testcase > uses a Date > comparison on one of the existing Mifos tables (We chose the START_DATE > column of MEETING > table for our testcase). > > Here are the set of steps you can follow to reproduce > the error. Keith has said he will be trying it out in his system too. So > we are > waiting for his test results. > > 1) Apply the mysql-date-test.patch attached to this mail to any recent > mifos revision > (containing Connector/J 5) > 2) Run ant build_test_db > 3) Run NewMeetingPersistenceTest - You should see the > testSaveAndRetrieveMeetingsForGivenDate() testcase failing. > 4) Change your Eclipse classpath to use the old Mysql Connector/J > (mysql-connector-java-3.1.13-bin.jar). > 5) Do ant_build_test_db (just to be on the safe side) > 6) Run NewMeetingPersistenceTest. The testcase should pass, > > Please let us know if you are able to reproduce the problem using the > above instructions. > We will look up the MySQL documentation too, as suggested on this list > earlier. > > Pramod Biligiri, > ThoughtWorks
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
