Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002073Openbravo ERP01. General setuppublic2007-10-11 02:452008-06-12 09:43
Reporteruser71 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.35 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002073: Time in background scheduler
DescriptionWhen you create a new entry in process scheduler window the time that is stored, is always 00:00:00. I think it happens in all time fields in the application.
I try in an installation based in oracle and it works fine.

Openbravo 2.34
Tomcat 5.5
Postgre 8.2.4
Jdk 1.5.0_12
Ant 1.7.0
Gentoo
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0005662)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1811231 [^]
(0002340)
user71   
2007-10-11 09:13   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1737231
Originator: NO

I just found this bug too

Environment
OS: Linux - Centos 4 (test/prod) & Windows XP (dev)
DB: Postgres 8.1.9 (test/prod) & 8.2.4 (dev)
Release: 2.34
Browser: Firefox 2.0.0.6, IE 7

The problem is that the generated xsqlc converts the time string using TO_DATE function. In Postgres at least that will just give a date. It needs to use TO_TIMESTAMP to get a time data type.
(0002341)
cromero   
2007-10-16 16:30   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1500614
Originator: NO

This bug has been fixed. We have modified Wad.java in order to transform to_date to to_timestamp for ALL time fields.
It will be included into next release.

Carlos Romero
Openbravo Team