[
https://issues.apache.org/jira/browse/OLIO-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12759181#action_12759181
]
James Zubb commented on OLIO-109:
---------------------------------
I am not able to get the OLIO-118 changes to work with the current Java DB
schema, the error I get seems to imply to me that there needs to be a TIMEZONE
field in DB, but you mention it is not needed, did I configure something
incorrectly?
I get the error:
Exception [EclipseLink-4002] (Eclipse Persistence Services -
1.1.2.v20090612-r4475): org.eclipse.persistence.exceptions.
DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Unknown column 'TIMEZONE' in 'field list'
Error Code: 1054
Call: SELECT SOCIALEVENTID AS SOCIALEVENTID1, SUMMARY AS SUMMARY2, TOTALSCORE
AS TOTALSCORE3, CREATEDTIMESTAMP AS CREATE
DTIMESTAMP4, EVENTTIMESTAMP AS EVENTTIMESTAMP5, IMAGETHUMBURL AS
IMAGETHUMBURL6, NUMBEROFVOTES AS NUMBEROFVOTES7, TITLE
AS TITLE8, TIMEZONE AS TIMEZONE9, DESCRIPTION AS DESCRIPTION10, TELEPHONE AS
TELEPHONE11, LITERATUREURL AS LITERATUREURL
12, SUBMITTERUSERNAME AS SUBMITTERUSERNAME13, DISABLED AS DISABLED14, IMAGEURL
AS IMAGEURL15, ADDRESS_ADDRESSID AS ADDRE
SS_ADDRESSID16 FROM SOCIALEVENT WHERE (EVENTTIMESTAMP >= CURRENT_TIMESTAMP)
ORDER BY EVENTTIMESTAMP ASC LIMIT ?, ?
bind => [0, 10]
Query: ReadAllQuery(referenceClass=SocialEvent sql="SELECT SOCIALEVENTID AS
SOCIALEVENTID1, SUMMARY AS SUMMARY2, TOTALSC
ORE AS TOTALSCORE3, CREATEDTIMESTAMP AS CREATEDTIMESTAMP4, EVENTTIMESTAMP AS
EVENTTIMESTAMP5, IMAGETHUMBURL AS IMAGETHUM
BURL6, NUMBEROFVOTES AS NUMBEROFVOTES7, TITLE AS TITLE8, TIMEZONE AS TIMEZONE9,
DESCRIPTION AS DESCRIPTION10, TELEPHONE
AS TELEPHONE11, LITERATUREURL AS LITERATUREURL12, SUBMITTERUSERNAME AS
SUBMITTERUSERNAME13, DISABLED AS DISABLED14, IMAG
EURL AS IMAGEURL15, ADDRESS_ADDRESSID AS ADDRESS_ADDRESSID16 FROM SOCIALEVENT
WHERE (EVENTTIMESTAMP >= CURRENT_TIMESTAMP
) ORDER BY EVENTTIMESTAMP ASC LIMIT ?, ?")
...
Backing out the changes made in OLIO-118 fixed the errors I was getting.
> 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.
