Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038705
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] Y. DBSourceManagerminorhave not tried2018-06-05 17:022018-08-24 10:38
ReportercaristuView Statuspublic 
Assigned Toplatform 
PriorityhighResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038705: DB Functions returning CLOB type are not supported in Oracle

DescriptionCurrently it is possible to define functions that return the text type in PostgreSQL. When exporting such functions in Oracle, this return type is stored as CLOB within the xml definition.

But when installing a function like that in Oracle an error is thrown during update.database task.
Steps To Reproduce1) Apply the attached patch
2) Using PostgreSQL, execute ant smartbuild -Dlocal=no. OK
3) Using Oracle, execute ant smartbuild -Dlocal=no. It fails.
Proposed SolutionThe return type is exported as CLOB. This type is currently not being mapped properly for Oracle by DBSM.

- Postgres type mapping: https://code.openbravo.com/erp/devel/dbsm-main/file/tip/src/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java#l69 [^]
- Oracle type mapping: https://code.openbravo.com/erp/devel/dbsm-main/file/8d1a581a7dcb/src/org/apache/ddlutils/platform/oracle/OraclePlatform.java#l87 [^]

Decide how to map it
TagsNo tags attached.
Attached Filesdiff file icon dbfunction.diff [^] (498 bytes) 2018-06-05 17:07 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
causes defect 0038691 new Openbravo Localizations France Professional Localization Pack incompatible with Oracle 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2018-06-05 17:02 caristu New Issue
2018-06-05 17:02 caristu Assigned To => platform
2018-06-05 17:02 caristu Modules => Core
2018-06-05 17:02 caristu Triggers an Emergency Pack => No
2018-06-05 17:02 caristu Category A. Platform => Y. DBSourceManager
2018-06-05 17:07 caristu File Added: dbfunction.diff
2018-06-05 17:16 caristu Summary DB Functions returning text type are not supported in Oracle => DB Functions returning CLOB type are not supported in Oracle
2018-06-05 17:16 caristu Description Updated View Revisions
2018-06-06 09:59 psanjuan Relationship added causes 0038691
2018-06-15 11:01 alostale Status new => acknowledged
2018-06-15 11:01 alostale Type defect => feature request
2018-08-24 10:38 caristu Proposed Solution updated


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker