Details
-
Bug
-
Resolution: Resolved Locally
-
Low
-
None
-
2.6.1 Enterprise
-
jakarta-tomcat-5.0.25
j2sdk1.4.2_05
postgresql-7.4.2
Redhat 9
kernel 2.4.20-31.9
-
2.06
-
Description
I made the change recommended in http://jira.atlassian.com/browse/JRA-3514 to remove Ofbiz entity engine warnings for Postgres 7.4.2. Now I get the following errors at startup:
2004-07-19 16:06:19,174 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "CREATED" of table "public.jiraaction" of entity
"Action" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,175 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "CREATED" of table "public.changegroup" of entit
y "ChangeGroup" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,179 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "DATEVALUE" of table "public.customfieldvalue" o
f entity "CustomFieldValue" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definit
ion.
2004-07-19 16:06:19,181 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "CREATED" of table "public.fileattachment" of en
tity "FileAttachment" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,182 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "LAST_RUN" of table "public.filtersubscription"
of entity "FilterSubscription" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity defi
nition.
2004-07-19 16:06:19,184 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "CREATED" of table "public.jiraissue" of entity
"Issue" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,184 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "UPDATED" of table "public.jiraissue" of entity
"Issue" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,184 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "DUEDATE" of table "public.jiraissue" of entity
"Issue" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,230 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "START_DATE" of table "public.OS_CURRENTSTEP" of
entity "OSCurrentStep" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,230 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "DUE_DATE" of table "public.OS_CURRENTSTEP" of e
ntity "OSCurrentStep" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,230 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "FINISH_DATE" of table "public.OS_CURRENTSTEP" o
f entity "OSCurrentStep" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition
.
2004-07-19 16:06:19,231 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "START_DATE" of table "public.OS_HISTORYSTEP" of
entity "OSHistoryStep" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,232 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "DUE_DATE" of table "public.OS_HISTORYSTEP" of e
ntity "OSHistoryStep" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,232 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "FINISH_DATE" of table "public.OS_HISTORYSTEP" o
f entity "OSHistoryStep" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition
.
2004-07-19 16:06:19,233 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "PROPERTYVALUE" of table "public.propertydate" o
f entity "OSPropertyDate" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definitio
n.
2004-07-19 16:06:19,249 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "FIRED_TIME" of table "public.qrtz_fired_trigger
s" of entity "QRTZFiredTriggers" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity de
finition.
2004-07-19 16:06:19,252 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "NEXT_FIRE" of table "public.qrtz_triggers" of e
ntity "QRTZTriggers" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,252 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "START_TIME" of table "public.qrtz_triggers" of
entity "QRTZTriggers" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,253 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "END_TIME" of table "public.qrtz_triggers" of en
tity "QRTZTriggers" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.
2004-07-19 16:06:19,255 ERROR [core.entity.jdbc.DatabaseUtil] WARNING: Column "CREATED" of table "public.trackback_ping" of en
tity "TrackbackPing" is of type "TIMESTAMP" in the database, but is defined as type "TIMESTAMPTZ" in the entity definition.