Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005843Openbravo ERPY. DBSourceManagerpublic2008-11-06 11:132009-05-21 16:37
Reporterpsarobe 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005843: Treatment for null and '' values in columns
DescriptionDBSource manager manage in a different way the columns with values '' and null. For Oracle is transparent so when running ant export.database either the value is null or '' they doesn't appear in the xml files

But PostgreSQL doesn't so, when the value is '' it appears in the .xml file but when is null it does not appear.

An example during the upgrader MP4-MP5

Upgrade M4-MP5
  <AD_ELEMENT_TRL AD_ELEMENT_ID="367" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-09-26 12:55:53.0" CREATEDBY="100" UPDATED="2003-09-26 12:55:53.0" UPDATEDBY="100" NAME="Repartido-Entregado" PRINTNAME="Repartido-Entregado" DESCRIPTION="" HELP="" ISTRANSLATED="Y" />

Tag MP5

  <AD_ELEMENT_TRL AD_ELEMENT_ID="367" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-09-26 12:55:53.0" CREATEDBY="100" UPDATED="2003-09-26 12:55:53.0" UPDATEDBY="100" NAME="Repartido-Entregado" PRINTNAME="Repartido-Entregado" ISTRANSLATED="Y" />

Steps To Reproduce
Proposed Solution
Additional Information
Tagsdbsm_migrate
Relationships
blocks defect 0005002 closed marvintm Treatment for null and '' values in columns 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-06 11:13marvintmNew Issue
2008-11-06 11:13marvintmAssigned To => marvintm
2008-11-06 11:13marvintmStatusnew => scheduled
2008-11-06 11:14svnbotCheckin
2008-11-06 11:14svnbotNote Added: 0010021
2008-11-06 11:14svnbotStatusscheduled => resolved
2008-11-06 11:14svnbotResolutionopen => fixed
2008-11-06 11:14svnbotsvn_revision => 164
2008-11-06 11:15svnbotCheckin
2008-11-06 11:15svnbotNote Added: 0010022
2008-11-06 11:15svnbotsvn_revision164 => 9730
2008-11-20 23:00svnbotCheckin
2008-11-20 23:00svnbotNote Added: 0010484
2008-11-20 23:00svnbotsvn_revision9730 => 10371
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-05-21 16:37psarobeStatusresolved => closed

Notes
(0010021)
svnbot   
2008-11-06 11:14   
Repository: dbsourcemanager
Revision: 164
Author: marvintm
Date: 2008-11-06 11:14:33 +0100 (Thu, 06 Nov 2008)

Fixed issue 5843. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products.

---
U branches/r0.8x/src/org/apache/ddlutils/io/DataWriter.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=164&sc=1 [^]
(0010022)
svnbot   
2008-11-06 11:15   
Repository: openbravo
Revision: 9730
Author: marvintm
Date: 2008-11-06 11:15:04 +0100 (Thu, 06 Nov 2008)

Fixed issue 5843. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products. Also, fixed a blank space in a function file.

---
U branches/r2.40/src-db/database/lib/dbsourcemanager.jar
U branches/r2.40/src-db/database/model/functions/GET_PARETO_ABC.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9730&sc=1 [^]
(0010484)
svnbot   
2008-11-20 23:00   
Repository: openbravo
Revision: 10371
Author: villind
Date: 2008-11-20 23:00:11 +0100 (Thu, 20 Nov 2008)

Merged r9730. Fixed issue 5843. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products. Also, fixed a blank space in a function file.

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
U branches/bonware/r2.40/src-db/database/lib/dbsourcemanager.jar
_U branches/bonware/r2.40/update.database.launch
---

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