Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0007708Openbravo ERPA. Platformpublic2009-02-20 10:452009-04-22 00:00
marvintm 
mtaal 
normalmajorhave not tried
closedfixed 
5
 
2.50beta 
Core
No
0007708: generate.entities fails if an ad_column has default_value 00:00:00
ant generate.entities fails if an ad_column has default_value 00:00:00

Basically, it generates java classes that have incorrect statements, and when it tries to compile them, the following error appears:

 [javac] /mnt2/svn/montblanc/branches/2.50/Oracle/OpenbravoERP/AppsOpenbravo/src-gen/org/openbravo/model/materialmgmt/transaction/ProductionTransaction.java:70: ')' expected
432 [javac] »···»···»···setDefaultValue(PROPERTY_ENDINGTIME, 00:00:00);
433 [javac] »···»···»··· ^
434 [javac] /mnt2/svn/montblanc/branches/2.50/Oracle/OpenbravoERP/AppsOpenbravo/src-gen/org/openbravo/model/materialmgmt/transaction/ProductionTransaction.java:70: not a statement
435 [javac] »···»···»···setDefaultValue(PROPERTY_ENDINGTIME, 00:00:00);
[17:37:10] … 436 [javac] »···»···»··· ^
437 [javac] /mnt2/svn/montblanc/branches/2.50/Oracle/OpenbravoERP/AppsOpenbravo/src-gen/org/openbravo/model/materialmgmt/transaction/ProductionTransaction.java:70: ';' expected
438 [javac] »···»···»···setDefaultValue(PROPERTY_ENDINGTIME, 00:00:00);
439 [javac] »···»···»··· ^
440 [javac] /mnt2/svn/montblanc/branches/2.50/Oracle/OpenbravoERP/AppsOpenbravo/src-gen/org/openbravo/model/materialmgmt/transaction/ProductionTransaction.java:71: ')' expected
441 [javac] »···»···»···setDefaultValue(PROPERTY_STARTINGTIME, 00:00:00);
442 [javac] »···»···»··· ^
443 [javac] /mnt2/svn/montblanc/branches/2.50/Oracle/OpenbravoERP/AppsOpenbravo/src-gen/org/openbravo/model/materialmgmt/transaction/ProductionTransaction.java:71: not a statement
444 [javac] »···»···»···setDefaultValue(PROPERTY_STARTINGTIME, 00:00:00);
445 [javac] »···»···»··· ^
446 [javac] /mnt2/svn/montblanc/branches/2.50/Oracle/OpenbravoERP/AppsOpenbravo/src-gen/org/openbravo/model/materialmgmt/transaction/ProductionTransaction.java:71: ';' expected
447 [javac] »···»···»···setDefaultValue(PROPERTY_STARTINGTIME, 00:00:00);
448 [javac] »···»···»··· ^
449 [javac] 6 errors
450
451 BUILD FAILED


Apparently, 00:00:00 is supposed to be a correct value for the default_value column. If it's not, however, this bug doesn't make sense and it should rejected. However, if it actually is a correct value, then it should be fixed because customers currently have values like this in their databases.
No tags attached.
Issue History
2009-02-20 10:45marvintmNew Issue
2009-02-20 10:45marvintmAssigned To => mtaal
2009-02-20 10:45marvintmRegression testing => No
2009-02-20 16:40mtaalNote Added: 0013855
2009-02-23 18:03svnbotCheckin
2009-02-23 18:03svnbotNote Added: 0013965
2009-02-23 18:03svnbotStatusnew => resolved
2009-02-23 18:03svnbotResolutionopen => fixed
2009-02-23 18:03svnbotsvn_revision => 13547
2009-04-21 10:54psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777978

Notes
(0013855)
mtaal   
2009-02-20 16:40   
Hi Antonio,
Is the endingtime/startingtime here a time (no date) or a timestamp (which also has a date)?

gr. Martin
(0013965)
svnbot   
2009-02-23 18:03   
Repository: openbravo
Revision: 13547
Author: mtaal
Date: 2009-02-23 18:03:35 +0100 (Mon, 23 Feb 2009)

Fixes issue 7708, generate.entities fails if an ad_column has default_value 00:00:00, default values other than sysdate are ignored for now

---
U trunk/src/org/openbravo/base/model/Property.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=13547&sc=1 [^]