Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0028875 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] A. Platform | major | always | 2015-02-05 16:57 | 2024-05-28 10:46 | ||||||
| Reporter | malsasua | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | high | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_18 | ||||||
| OS Version | Community Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | ||||||
| Product Version | SCM revision | ||||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0028875: Class "CallStoredProcedure" does not support parameters of type out | ||||||||||
| Description | with the class "CallStoredProcedure" if the stored procedure have got parameters of type out, it is not possible to read them, they are not returned Also, in oracle, it is not possible to call a database stored procedure when the procedure have got parameters of type "out". Error is returned | ||||||||||
| Steps To Reproduce | . in oracle and Web POS . in OrderLoader.java the called to M_GET_STOCK_PARAM procedure: error is returned: Caused by: java.lang.IllegalStateException: java.sql.SQLSyntaxErrorException: ORA-00904: "M_GET_STOCK_PARAM": invalid identifier [junit] [junit] at org.openbravo.service.db.CallStoredProcedure.call(CallStoredProcedure.java:142) [junit] at org.openbravo.retail.posterminal.OrderLoader.callProcessGetStock(OrderLoader.java:1795) [junit] at org.openbravo.retail.posterminal.OrderLoader.createShipmentLines(OrderLoader.java:860) [junit] at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:243) | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0074331) alostale (manager) 2015-02-10 17:30 |
Moving to design defect. Current implementation supports to invoke procedures for which does not expect any return object or function in which case it expects an object to be returned. In this case it is invoking a procedure as a function throwing an error. See 0028909 for more details. What needs to be checked/refactored: * There are different ways of invoking procedures/functions: unify them * Proper support for output parameters being DB agnostic |
|
(0075168) hgbot (developer) 2015-03-04 18:23 |
Repository: erp/pmods/org.openbravo.warehouse.pickinglist Changeset: 24c46fe2335224c9ec749634d9223a9742da982a Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Wed Mar 04 18:21:18 2015 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.pickinglist/rev/24c46fe2335224c9ec749634d9223a9742da982a [^] Related to issue 28875 Class "CallStoredProcedure" does not support parameters of type out in oracle --- M src/org/openbravo/warehouse/pickinglist/Utilities.java --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-02-05 16:57 | malsasua | New Issue | |
| 2015-02-05 16:57 | malsasua | Assigned To | => AugustoMauch |
| 2015-02-05 16:57 | malsasua | Modules | => Core |
| 2015-02-05 16:57 | malsasua | Regression level | => Automated tests |
| 2015-02-05 16:57 | malsasua | Triggers an Emergency Pack | => No |
| 2015-02-05 16:57 | malsasua | Description Updated | View Revisions |
| 2015-02-05 17:11 | AugustoMauch | Summary | Class "CallSotredProcedure" does not support parameters of type out => Class "CallStoredProcedure" does not support parameters of type out |
| 2015-02-10 11:04 | alostale | Status | new => scheduled |
| 2015-02-10 11:04 | alostale | fix_in_branch | => pi |
| 2015-02-10 11:04 | alostale | Assigned To | AugustoMauch => alostale |
| 2015-02-10 11:04 | alostale | Relationship added | related to 0028834 |
| 2015-02-10 17:17 | alostale | Issue cloned | 0028909 |
| 2015-02-10 17:19 | alostale | Relationship added | related to 0028909 |
| 2015-02-10 17:30 | alostale | Note Added: 0074331 | |
| 2015-02-10 17:30 | alostale | Status | scheduled => acknowledged |
| 2015-02-10 17:30 | alostale | Type | defect => design defect |
| 2015-02-10 17:30 | alostale | Target Version | 3.0PR15Q2 => |
| 2015-02-10 17:30 | alostale | fix_in_branch | pi => |
| 2015-02-24 11:12 | alostale | Relationship added | related to 0017018 |
| 2015-02-24 11:12 | alostale | Relationship replaced | duplicate of 0017018 |
| 2015-02-24 11:13 | alostale | Relationship replaced | has duplicate 0017018 |
| 2015-03-04 18:23 | hgbot | Checkin | |
| 2015-03-04 18:23 | hgbot | Note Added: 0075168 | |
| 2015-03-06 11:27 | eduardo_Argal | Assigned To | alostale => marvintm |
| 2015-03-06 11:27 | eduardo_Argal | Assigned To | marvintm => alostale |
| 2015-10-19 12:16 | vmromanos | Relationship added | related to 0031121 |
| 2017-04-10 14:35 | alostale | Assigned To | alostale => platform |
| 2017-06-30 14:40 | caristu | Relationship added | has duplicate 0036186 |
| 2022-02-01 08:08 | alostale | Assigned To | platform => Triage Platform Base |
| 2024-05-28 10:46 | alostale | Regression level | Automated tests => |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |