Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009224Openbravo ERPY. DBSourceManagerpublic2009-05-28 13:342009-06-27 00:00
Reporteriperdomo 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version2.6.28-gentoo-r5
Product Versionpi 
Target VersionFixed in Versionmain 
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
Summary0009224: Data record insertion fails when using a CLOB column
DescriptionAfter creating the database in the, dbsm makes an insert for each record on the xml. If you have data on a CBLOB column it fails.

Error while inserting into the database: Cannot cast an instance of java.lang.String to type Types.CLOB

Attached a full install.source log
Steps To ReproduceUsing a CLOB column, try to create a database.

Constraints:
* You must have data to insert in that column
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0008917 closed iperdomo Error Message when set org. as ready 
Attached Fileslog install.source.log (2,497) 2009-05-28 13:34
https://issues.openbravo.com/file_download.php?file_id=1354&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-05-28 13:34iperdomoNew Issue
2009-05-28 13:34iperdomoAssigned To => marvintm
2009-05-28 13:34iperdomoFile Added: install.source.log
2009-05-28 13:34iperdomoOBNetwork customer => No
2009-05-28 13:35iperdomoRelationship addedblocks 0008917
2009-05-28 18:42hgbotCheckin
2009-05-28 18:42hgbotNote Added: 0016735
2009-05-28 18:42hgbotStatusnew => resolved
2009-05-28 18:42hgbotResolutionopen => fixed
2009-05-28 18:43hgbotCheckin
2009-05-28 18:43hgbotNote Added: 0016736
2009-05-28 18:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8ba943961ec56031685295603bc55ed887edcd16 [^]
2009-05-28 19:50hgbotCheckin
2009-05-28 19:50hgbotNote Added: 0016741
2009-05-28 19:50hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/8ba943961ec56031685295603bc55ed887edcd16 [^] => http://code.openbravo.com/erp/devel/pi/rev/061c1311beb720be628037b90462488711d3f3d9 [^]
2009-06-22 11:09psarobeFixed in Version => main
2009-06-26 18:40psarobeStatusresolved => closed
2009-06-27 00:00anonymoussf_bug_id0 => 2813022

Notes
(0016735)
hgbot   
2009-05-28 18:42   
Repository: dbsourcemanager
Revision: 327
Author: marvintm
Date: 2009-05-28 18:42:01 +0200 (Thu, 28 May 2009)

Fixed issue 9224. Now data for CLOB columns should be handled correctly by dbsm.

---
U trunk/src/org/apache/ddlutils/platform/PlatformImplBase.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=327&sc=1 [^]
(0016736)
hgbot   
2009-05-28 18:43   
Repository: erp/devel/pi
Changeset: 8ba943961ec56031685295603bc55ed887edcd16
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu May 28 18:43:02 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8ba943961ec56031685295603bc55ed887edcd16 [^]

Fixed issue 9224. Now data for CLOB columns should be handled correctly by dbsm.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0016741)
hgbot   
2009-05-28 19:50   
Repository: erp/devel/pi
Changeset: 061c1311beb720be628037b90462488711d3f3d9
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Thu May 28 19:50:12 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/061c1311beb720be628037b90462488711d3f3d9 [^]

Added support for CLOB columns. Related to issue 9224

---
M src/org/openbravo/service/system/DatabaseValidator.java
---