[
https://issues.apache.org/jira/browse/OLIO-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12755274#action_12755274
]
Kim LiChong commented on OLIO-109:
----------------------------------
For the Java application, a Java TimeStamp is used for the createdTimestamp and
the eventTimestamp which is a wrapper class for java.util.Date which
encompasses timezone information. As such, it does not require a separate
timezone database field in the database. The application accepts the desired
timezone and sets this in the Timestamp object. Related is bug OLIO-118 where
the socialevent timezone was always being stored as the system default and the
user was incapable of setting the appropriate timezone.
The timezone field in Java has been corrected and will be checked in with the
loader integration in 0.2 release.
The event times should be displayed according to the timezone stored for the
Person object. This needs to be corrected in the java application based on bug
OLIO-118 since a current scan of the DB shows all person have a PST as the
timezone.
> timezone fields in schema are inconsistent
> ------------------------------------------
>
> Key: OLIO-109
> URL: https://issues.apache.org/jira/browse/OLIO-109
> Project: Olio
> Issue Type: Bug
> Components: generic
> Affects Versions: 0.1
> Reporter: Shanti Subramanyam
> Assignee: Shanti Subramanyam
> Priority: Minor
> Fix For: 0.3
>
>
> Jim Larus reports:
> In the schema for the DB, the timezone in the PERSON class is a 25-char
> string, while the timezone field in SOCIALEVENT is 100-char string. Some of
> the timezones in includes/timezones.html are longer than 25 char, so I
> suspect the latter is correct.
> Both the php and rails schema use a 25-char string in PERSON, where as the
> Java app uses 255 (which is probably an overkill). Only the PHP app has
> timezone in the SOCIALEVENT table - the other two apps don't.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
