Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013799Openbravo ERPY. DBSourceManagerpublic2010-06-28 12:432010-07-06 00:00
Reportermarvintm 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
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
Summary0013799: DBSM doesn't manage CLOB columns correctly when updating the value of the column
DescriptionWhen executing update.database, dbsourcemanager checks whether the value of each column changed for each row. For each changed value, it executes a "UPDATE" statement for the column

This UPDATE fails in the case of CLOB columns.
Steps To Reproduce
Change the value of the "VALUE" column of one AD_PREFERENCE in src-db/database/sourcedata
Execute update.database. It will fail.
Proposed SolutionDBSM needs to be changed to fix this problem.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-28 12:43marvintmNew Issue
2010-06-28 12:43marvintmAssigned To => marvintm
2010-06-28 16:21shuehnerIssue Monitored: shuehner
2010-06-29 10:37hgbotCheckin
2010-06-29 10:37hgbotNote Added: 0028844
2010-06-29 10:37hgbotStatusnew => resolved
2010-06-29 10:37hgbotResolutionopen => fixed
2010-06-29 10:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/66e4c103df95ba3642d196fc9f795e2d8742b881 [^]
2010-06-29 12:06hgbotCheckin
2010-06-29 12:06hgbotNote Added: 0028853
2010-06-29 12:06hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/66e4c103df95ba3642d196fc9f795e2d8742b881 [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/80603542f7ffd0d8e2597ad3685a4b0cf36c3dec [^]
2010-07-02 14:50hudsonbotCheckin
2010-07-02 14:50hudsonbotNote Added: 0028992
2010-07-05 12:00mtaalNote Added: 0029048
2010-07-05 12:00mtaalStatusresolved => closed
2010-07-06 00:00anonymoussf_bug_id0 => 3025609

Notes
(0028844)
hgbot   
2010-06-29 10:37   
Repository: erp/devel/pi
Changeset: 66e4c103df95ba3642d196fc9f795e2d8742b881
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Jun 28 16:45:41 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/66e4c103df95ba3642d196fc9f795e2d8742b881 [^]

Fixed issue 13799. CLOBs will now be updated correctly

---
M src-db/database/lib/dbsourcemanager.jar
---
(0028853)
hgbot   
2010-06-29 12:06   
Repository: erp/devel/dbsm-main
Changeset: 80603542f7ffd0d8e2597ad3685a4b0cf36c3dec
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Jun 28 16:35:42 2010 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/80603542f7ffd0d8e2597ad3685a4b0cf36c3dec [^]

Fixed issue 13799. CLOBs will now be updated correctly

---
M src/org/apache/ddlutils/platform/PlatformImplBase.java
---
(0028992)
hudsonbot   
2010-07-02 14:50   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/66e4c103df95 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8fd5a427789e [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17797.obx [^]
(0029048)
mtaal   
2010-07-05 12:00   
Works fine now