Hi,
how can i be taken off this list?
Cheers
Chico Charlesworth <[EMAIL PROTECTED]> wrote:
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/
---------------------------------
Rise to the challenge for Sport Relief with Yahoo! for Good-------------------------------------------------------------------------
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/
