Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012638Openbravo ERPA. Platformpublic2010-03-10 17:262010-03-12 22:41
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version2.50MP14Fixed in Version2.50MP14 
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
Summary0012638: On oracle the metadata queries in the SessionFactoryController read all tables, resulting in strange results
DescriptionThe SessionFactoryController contains several queries to read database metadata. These queries do not filter by database owner. So if a user has access to many databases then the queries will read information from all the databases the user has access to.

This can result in strange results if the user has access to multiple Openbravo databases with different versions of Openbravo. For example that columns are assigned to be mandatory while they are not in the intended database.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-03-10 17:26mtaalNew Issue
2010-03-10 17:26mtaalAssigned To => mtaal
2010-03-10 17:26mtaalOBNetwork customer => No
2010-03-10 17:37hgbotCheckin
2010-03-10 17:37hgbotNote Added: 0025215
2010-03-10 17:37hgbotStatusnew => resolved
2010-03-10 17:37hgbotResolutionopen => fixed
2010-03-10 17:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d0de798fac8ef03386b581b0f290f1b523241946 [^]
2010-03-11 10:36alostaleStatusresolved => closed
2010-03-11 10:36alostaleFixed in Version => 2.50MP14
2010-03-12 00:00anonymoussf_bug_id0 => 2969007
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025416

Notes
(0025215)
hgbot   
2010-03-10 17:37   
Repository: erp/devel/pi
Changeset: d0de798fac8ef03386b581b0f290f1b523241946
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Mar 10 17:42:54 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d0de798fac8ef03386b581b0f290f1b523241946 [^]

Fixes issue 12638: On oracle the metadata queries in the SessionFactoryController read all tables, resulting in strange results

---
M src/org/openbravo/base/session/SessionFactoryController.java
---
(0025416)
hudsonbot   
2010-03-12 22:41   
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/d0de798fac8e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]