[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title Vishwas Babu A J updated an issue Mifos X / MIFOSX-1959 Timezone related issues in the platform Change By: Vishwas Babu A J Labels: introductory volunteer Add Comment This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa) -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title Vishwas Babu A J updated an issue Mifos X / MIFOSX-1959 Timezone related issues in the platform Change By: Vishwas Babu A J Fix Version/s: 15.06 Release Add Comment This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa) -- BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title
Vishwas Babu A J created an issue
Mifos X / MIFOSX-1959
Timezone related issues in the platform
Issue Type:
Bug
Assignee:
Unassigned
Created:
11/Apr/15 9:05 AM
Priority:
Major
Reporter:
Vishwas Babu A J
A number of timezone related issues exist in the mifos-platform
1) Many SQL queries use now(), this would lead to potential errors when the timezone of the mysql database is different from the timezone of the tenant
A possible fix might be to set the timezone with the tenant specific mysql connection itself
2) Date formatters are used in multiple places, formatting a Timezone specific locale date with this date formatter (the timezone isn't set in the date formatter) would result in the dates being parsed based on the default format of the application server.
Ensure that all Date formatter (java.util and joda have timezone set)
code //java util final DateFormat df = new SimpleDateFormat("-MM-dd"); df.setTimeZone(DateUtils.getTimeZoneOfTenant());
//joda final DateTimeFormatter fmt = DateTimeFormat.forPattern("dd MM "); fmt.withZone(DateUtils.getDateTimeZoneOfTenant()); code
3) Ensure that all times/ date times used in the code are set with the right Timezone
In general, while getting a date in the system, ensure that you get them from org.mifosplatform.infrastructure.core.service.DateUtils.java class (returns the date/ local date based on the timezone of the tenant)
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title
Vishwas Babu A J updated an issue
Mifos X / MIFOSX-1959
Timezone related issues in the platform
Change By:
Vishwas Babu A J
A number of timezone related issues exist in the mifos-platform1) Many SQL queries use now(), this would lead to potential errors when the timezone of the mysql database is different from the timezone of the tenantA possible fix might be to set the timezone with the tenant specific mysql connection itself2) Date formatters are used in multiple places, formatting a Timezone specific locale date with this date formatter (the timezone isn't set in the date formatter) would result in the dates being parsed based on the default format of the application server.Ensure that all Date formatter (java.util and joda have timezone set){{code}}/ / * java util */ final DateFormat df = new SimpleDateFormat("-MM-dd"); df.setTimeZone(DateUtils.getTimeZoneOfTenant());/ / * joda */ final DateTimeFormatter fmt = DateTimeFormat.forPattern("dd MM "); fmt.withZone(DateUtils.getDateTimeZoneOfTenant());{{code}}3) Ensure that all times/ date times used in the code are set with the right TimezoneIn general, while getting a date in the system, ensure that you get them from org.mifosplatform.infrastructure.core.service.DateUtils.java class (returns the date/ local date based on the timezone of the tenant)
Add Comment
This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa)
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title
Vishwas Babu A J updated an issue
Mifos X / MIFOSX-1959
Timezone related issues in the platform
Change By:
Vishwas Babu A J
A number of timezone related issues exist in the mifos-platform1) Many SQL queries use now(), this would lead to potential errors when the timezone of the mysql database is different from the timezone of the tenantA possible fix might be to set the timezone with the tenant specific mysql connection itself2) Date formatters are used in multiple places, formatting a Timezone specific locale date with this date formatter (the timezone isn't set in the date formatter) would result in the dates being parsed based on the default format of the application server.Ensure that all Date formatter (java.util and joda have timezone set){ { code} } /*java util*/ final DateFormat df = new SimpleDateFormat("-MM-dd"); df.setTimeZone(DateUtils.getTimeZoneOfTenant());/*joda*/ final DateTimeFormatter fmt = DateTimeFormat.forPattern("dd MM "); fmt.withZone(DateUtils.getDateTimeZoneOfTenant());{ { code} } 3) Ensure that all times/ date times used in the code are set with the right TimezoneIn general, while getting a date in the system, ensure that you get them from org.mifosplatform.infrastructure.core.service.DateUtils.java class (returns the date/ local date based on the timezone of the tenant)
Add Comment
This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa)
--
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in a
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title
Vishwas Babu A J updated an issue
Mifos X / MIFOSX-1959
Timezone related issues in the platform
Change By:
Vishwas Babu A J
A number of timezone related issues exist in the mifos-platform1) Many SQL queries use now(), this would lead to potential errors when the timezone of the mysql database is different from the timezone of the tenantA possible fix might be to set the timezone with the tenant specific mysql connection itself2) Date formatters are used in multiple places, formatting a Timezone specific locale date with this date formatter (the timezone isn't set in the date formatter) would result in the dates being parsed based on the default format of the application server.Ensure that all Date formatter (java.util and joda have timezone set){code}/*java util*/ final DateFormat df = new SimpleDateFormat("-MM-dd"); df.setTimeZone(DateUtils.getTimeZoneOfTenant());/*joda*/ final DateTimeFormatter fmt = DateTimeFormat.forPattern("dd MM "); fmt.withZone(DateUtils.getDateTimeZoneOfTenant());{code}3) Ensure that all times/ date times used in the code are set with the right TimezoneIn general, while getting a date in the system, ensure that you get them from org.mifosplatform.infrastructure.core.service.DateUtils.java class (returns the date/ local date based on the timezone of the tenant) {code} final LocalDate transactionDate = DateUtils.getLocalDateOfTenant(); final Date todaysDate = DateUtils.getDateOfTenant() {code}
Add Comment
This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa)
---
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title
Vishwas Babu A J updated an issue
Mifos X / MIFOSX-1959
Timezone related issues in the platform
Change By:
Vishwas Babu A J
A number of timezone related issues exist in the mifos-platform1) Many SQL queries use now(), this would lead to potential errors when the timezone of the mysql database is different from the timezone of the tenantA possible fix might be to set the timezone with the tenant specific mysql connection itself2) Date formatters are used in multiple places, formatting a Timezone specific locale date with this date formatter (the timezone isn't set in the date formatter) would result in the dates being parsed based on the default format of the application server.Ensure that all Date formatter formatters (java.util and joda ) have timezone set ) {code}/*java util*/ final DateFormat df = new SimpleDateFormat("-MM-dd"); df.setTimeZone(DateUtils.getTimeZoneOfTenant());/*joda*/ final DateTimeFormatter fmt = DateTimeFormat.forPattern("dd MM "); fmt.withZone(DateUtils.getDateTimeZoneOfTenant());{code}3) Ensure that all times/ date times used in the code are set with the right TimezoneIn general, while getting a date in the system, ensure that you get them from org.mifosplatform.infrastructure.core.service.DateUtils.java class (returns the date/ local date based on the timezone of the tenant){code} final LocalDate transactionDate = DateUtils.getLocalDateOfTenant(); final Date todaysDate = DateUtils.getDateOfTenant() {code}
Add Comment
This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa)
---
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title
Vishwas Babu A J updated an issue
Mifos X / MIFOSX-1959
Timezone related issues in the platform
Change By:
Vishwas Babu A J
A number of timezone related issues exist in the mifos-platform (can be seen only when you have the app server and db running on a timezone and a tenant using a different timezone) . We need to have a relook at the same, a few items that come to mind are listed below 1) Many SQL queries use now(), this would lead to potential errors when the timezone of the mysql database is different from the timezone of the tenantA possible fix might be to set the timezone with the tenant specific mysql connection itself2) Date formatters are used in multiple places, formatting a Timezone specific locale date with this date formatter (the timezone isn't set in the date formatter) would result in the dates being parsed based on the default format of the application server.Ensure that all Date formatters (java.util and joda) have timezone set{code}/*java util*/ final DateFormat df = new SimpleDateFormat("-MM-dd"); df.setTimeZone(DateUtils.getTimeZoneOfTenant());/*joda*/ final DateTimeFormatter fmt = DateTimeFormat.forPattern("dd MM "); fmt.withZone(DateUtils.getDateTimeZoneOfTenant());{code}3) Ensure that all times/ date times used in the code are set with the right TimezoneIn general, while getting a date in the system, ensure that you get them from org.mifosplatform.infrastructure.core.service.DateUtils.java class (returns the date/ local date based on the timezone of the tenant){code} final LocalDate transactionDate = DateUtils.getLocalDateOfTenant(); final Date todaysDate = DateUtils.getDateOfTenant() {code}
Add Comment
This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa)
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title
Vishwas Babu A J updated an issue
Mifos X / MIFOSX-1959
Timezone related issues in the platform
Change By:
Vishwas Babu A J
A number of timezone related issues exist in the mifos-platform (can be seen only when you have the app server and db running on a timezone and a tenant using a different timezone) . We need to have a relook at the same, a few items that come to mind are listed below1) Many SQL queries use date functions like now() etc , this would lead to potential errors when the timezone of the mysql database is different from the timezone of the tenantA possible fix might be to set the timezone with the tenant specific mysql connection itself2) Date formatters are used in multiple places, formatting a Timezone specific locale date with this date formatter (the timezone isn't set in the date formatter) would result in the dates being parsed based on the default format of the application server.Ensure that all Date formatters (java.util and joda) used while generating dates on the server side have timezone set (move these functions to DateUtils.java) {code}/*java util*/ final DateFormat df = new SimpleDateFormat("-MM-dd"); df.setTimeZone(DateUtils.getTimeZoneOfTenant());/*joda*/ final DateTimeFormatter fmt = DateTimeFormat.forPattern("dd MM "); fmt.withZone(DateUtils.getDateTimeZoneOfTenant());{code}3) Ensure that all times/ date times used generated in the code are set with the right TimezoneIn general, while getting a date in the system, ensure that you get them from org.mifosplatform.infrastructure.core.service.DateUtils.java class (returns the date/ local date based on the timezone of the tenant){code} final LocalDate transactionDate = DateUtils.getLocalDateOfTenant(); final Date todaysDate = DateUtils.getDateOfTenant() {code}
Add Comment
This message was sent by Atlassian JIRA (v6.4-OD-16-006#64014-sha1:e47e3fa)
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title subramanya updated an issue Mifos X / MIFOSX-1959 Timezone related issues in the platform Change By: subramanya Fix Version/s: 15.06.RELEASE Fix Version/s: 15.08.RELEASE Add Comment This message was sent by Atlassian JIRA (v7.0.0-OD-02-247#70102-sha1:09808d3) -- ___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title subramanya updated an issue Mifos X / MIFOSX-1959 Timezone related issues in the platform Change By: subramanya Fix Version/s: 15.08.RELEASE Fix Version/s: 15.06.RELEASE Add Comment This message was sent by Atlassian JIRA (v7.0.0-OD-02-247#70102-sha1:09808d3) -- ___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
[Mifos-issues] [JIRA] (MIFOSX-1959) Timezone related issues in the platform
Title: Message Title dh...@mifos.org updated an issue Mifos X / MIFOSX-1959 Timezone related issues in the platform Change By: dh...@mifos.org Fix Version/s: ImmediateBacklog Fix Version/s: Immediate_bug_fix Add Comment This message was sent by Atlassian JIRA (v7.0.0-OD-06-002#70102-sha1:82bb17d) -- ___ Mifos-issues mailing list Mifos-issues@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-issues
