Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039095Openbravo ERPZ. Otherspublic2018-08-06 20:372018-08-20 09:57
Reportercollazoandy4 
Assigned Tocollazoandy4 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039095: Update modules to SQLFunctionRegister
DescriptionThe OBDal.registerSQLFunction allows to register SQL functions at runtime in order to make them available in HQL queries.

In the latest Hibernate releases this is no longer possible, and it is only possible to register such functions when Hibernate is being set up

The following modules should refactor to register the SQL functions when Dal is being initialized.

 - org.openbravo.module.invoiceTaxReportEnhanced30.cashvat
 - org.openbravo.module.aeat340.es
Steps To ReproduceIn Description
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0038520 closed caristu Openbravo ERP Deprecate OBDal.registerSQLFunction 
causes defect 0039150 closed collazoandy4 Localization Pack: Spain 3.6.400 version of this module fails to install with ERP 18Q3 version as accidentally contains changes for Q4 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-08-06 20:37collazoandy4New Issue
2018-08-06 20:37collazoandy4Assigned To => platform
2018-08-06 20:37collazoandy4Modules => Core
2018-08-06 20:37collazoandy4Triggers an Emergency Pack => No
2018-08-06 20:39collazoandy4Assigned Toplatform => collazoandy4
2018-08-06 20:40collazoandy4Statusnew => scheduled
2018-08-06 20:40collazoandy4CategoryA. Platform => Z. Others
2018-08-06 21:42collazoandy4Relationship addedrelated to 0038520
2018-08-07 14:55hgbotCheckin
2018-08-07 14:55hgbotNote Added: 0106176
2018-08-08 10:00hgbotCheckin
2018-08-08 10:00hgbotNote Added: 0106180
2018-08-08 10:03SandrahuguetNote Added: 0106181
2018-08-08 10:03SandrahuguetStatusscheduled => resolved
2018-08-08 10:03SandrahuguetFixed in SCM revision => https://code.openbravo.com/erp/pmods/org.openbravo.module.aeat340.es/rev/9ea7361c226af4e96542eee9eee5b7bd25a8be9e [^]
2018-08-08 10:03SandrahuguetResolutionopen => fixed
2018-08-08 10:03SandrahuguetReview Assigned To => Sandrahuguet
2018-08-08 10:03SandrahuguetNote Added: 0106182
2018-08-08 10:03SandrahuguetStatusresolved => closed
2018-08-17 12:42shuehnerRelationship addedcauses 0039150
2018-08-20 09:09hgbotCheckin
2018-08-20 09:09hgbotNote Added: 0106399
2018-08-20 09:57hgbotCheckin
2018-08-20 09:57hgbotNote Added: 0106405

Notes
(0106176)
hgbot   
2018-08-07 14:55   
Repository: erp/pmods/org.openbravo.module.aeat340.es
Changeset: 9ea7361c226af4e96542eee9eee5b7bd25a8be9e
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Mon Aug 06 17:33:43 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat340.es/rev/9ea7361c226af4e96542eee9eee5b7bd25a8be9e [^]

Related to issue 39095: Update modules to SQLFunctionRegister

Updated code to fully support the new mechanismo of register function in
DAL

---
M src/org/openbravo/module/aeat340/es/api/year2012/AEAT340Report_2012APRMDao.java
A src/org/openbravo/module/aeat340/es/util/AEAT340SQLFunctionRegister.java
---
(0106180)
hgbot   
2018-08-08 10:00   
Repository: erp/pmods/org.openbravo.module.aeat340.es
Changeset: 5a4d9223272a820d8b59d340efc2eda418d4ee48
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Aug 08 09:20:13 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat340.es/rev/5a4d9223272a820d8b59d340efc2eda418d4ee48 [^]

Related to issue 39095: Update modules to SQLFunctionRegister

Updated code to fully support the new mechanismo of register function in
DAL

---
M src/org/openbravo/module/aeat340/es/api/year2012/AEAT340Report_2012APRMDao.java
A src/org/openbravo/module/aeat340/es/util/AEAT340SQLFunctionRegister.java
---
(0106181)
Sandrahuguet   
2018-08-08 10:03   
org.openbravo.module.invoiceTaxReportEnhanced30.cashvat already fixed in:

org.openbravo.module.invoiceTaxReportEnhanced30.cashvat
https://code.openbravo.com/erp/pmods/org.openbravo.module.invoiceTaxReportEnhanced30.cashvat/rev/0e0bd3d653997e0db05d293b82c89198e65ba5bf [^]
(0106182)
Sandrahuguet   
2018-08-08 10:03   
Code review + testing OK
(0106399)
hgbot   
2018-08-20 09:09   
Repository: erp/pmods/org.openbravo.module.aeat340.es
Changeset: 5b195178e0ad26ccd052d0446d4f437676ba3d94
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Fri Aug 17 19:56:35 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat340.es/rev/5b195178e0ad26ccd052d0446d4f437676ba3d94 [^]

Fixes issue 39150:Removed changes of 18Q4

The fix for issue 39095 accidentally mixes the fix with an api chan of hibernate
upgrade project from 18Q4

The upgrades changes was removed.

---
M src/org/openbravo/module/aeat340/es/api/year2012/AEAT340Report_2012APRMDao.java
---
(0106405)
hgbot   
2018-08-20 09:57   
Repository: erp/pmods/org.openbravo.module.aeat340.es
Changeset: b4e12ccaefacf703dc650dc0e1102546bedb237a
Author: Armaignac <collazoandy4 <at> gmail.com>
Date: Fri Aug 17 20:12:56 2018 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat340.es/rev/b4e12ccaefacf703dc650dc0e1102546bedb237a [^]

Fixes issue 39150:Removed changes of 18Q4

The fix for issue 39095 accidentally mixes the fix with an api chan of hibernate
upgrade project from 18Q4

The upgrades changes was removed.

---
M src/org/openbravo/module/aeat340/es/api/year2012/AEAT340Report_2012APRMDao.java
---