[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/
