Hi Pramod, Can you also email us the example query that is not working? Then it should be very easy to reproduce the problem.
Cheers Chico Pramod Biligiri <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/07/2008 12:27 PM Please respond to Developer <[email protected]> To Developer <[email protected]> cc Nandini Yadalam <[EMAIL PROTECTED]> Subject Re: [Mifos-developer] Issue with new Mysql Connector - Date comparison [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/
------------------------------------------------------------------------- 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/
