Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0018033Openbravo ERPY. DBSourceManagerpublic2011-07-19 17:062011-08-06 05:32
malsasua 
marvintm 
highminoralways
closedfixed 
20Community Appliance
 
3.0MP23.0MP2 
Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
Core
No
0018033: "null pointer exception" is returned when a function parameter does not have a name
to run "update.database", if a function parameter does not have a name, error is returned:
     [java] 385992 ERROR -
     [java] java.lang.NullPointerException
     [java] at org.apache.ddlutils.model.Parameter.getName(Parameter.java:53)
create function with this header:
CREATE OR REPLACE FUNCTION nombreFuncion (numeric)
  RETURNS character varying AS
.....

run update.database
No tags attached.
Issue History
2011-07-19 17:06malsasuaNew Issue
2011-07-19 17:06malsasuaAssigned To => marvintm
2011-07-19 17:06malsasuaWeb browser => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2011-07-19 17:06malsasuaModules => Core
2011-07-19 17:06malsasuaResolution time => 1316728800
2011-07-19 17:11marvintmWeb browserApple Safari, Google Chrome, Internet Explorer, Mozilla Firefox => Apple Safari, Google Chrome, Internet Explorer, Mozilla Firefox
2011-07-19 17:11marvintmTarget Version => 3.0MP2
2011-07-19 17:13marvintmNote Added: 0039243
2011-07-27 13:00hgbotCheckin
2011-07-27 13:00hgbotNote Added: 0039442
2011-07-27 13:00hgbotStatusnew => resolved
2011-07-27 13:00hgbotResolutionopen => fixed
2011-07-27 13:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/dbsm-main/rev/aa695d8e9913f684979f1f4ed67e56c609547193 [^]
2011-07-27 13:00hgbotCheckin
2011-07-27 13:00hgbotNote Added: 0039444
2011-07-27 13:00hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/dbsm-main/rev/aa695d8e9913f684979f1f4ed67e56c609547193 [^] => http://code.openbravo.com/erp/devel/pi/rev/3a620590bef8eb6e40d84e110b6e787f3427626e [^]
2011-08-01 14:21hudsonbotCheckin
2011-08-01 14:21hudsonbotNote Added: 0039707
2011-08-03 12:59hgbotCheckin
2011-08-03 12:59hgbotNote Added: 0039814
2011-08-03 12:59hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/3a620590bef8eb6e40d84e110b6e787f3427626e [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/a740f01cdc4c7280653249b19d5547d69fb37bee [^]
2011-08-03 13:02hgbotCheckin
2011-08-03 13:02hgbotNote Added: 0039815
2011-08-03 13:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/dbsm-main/rev/a740f01cdc4c7280653249b19d5547d69fb37bee [^] => http://code.openbravo.com/erp/devel/pi/rev/7f10ae8a4377cb288bec825b46c064de1e9ce2b6 [^]
2011-08-03 13:06malsasuaNote Added: 0039818
2011-08-03 13:06malsasuaStatusresolved => closed
2011-08-03 13:06malsasuaFixed in Version => 3.0MP2
2011-08-06 05:32hudsonbotCheckin
2011-08-06 05:32hudsonbotNote Added: 0039947

Notes
(0039243)
marvintm   
2011-07-19 17:13   
This header doesn't comply with the standard dbsm expects, so it's normal that it fails. However, the error log needs to be improved, because currently it's impossible for the developer to find out which function failed, and why.

So the fix for this issue will be to improve the log so that it's meaningful for the developer.
(0039442)
hgbot   
2011-07-27 13:00   
Repository: erp/devel/dbsm-main
Changeset: aa695d8e9913f684979f1f4ed67e56c609547193
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Jul 27 12:37:49 2011 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/aa695d8e9913f684979f1f4ed67e56c609547193 [^]

Fixed issue 18033. If a function parameter cannot be read, a nice, intelligible exception will be thrown

---
M src/org/apache/ddlutils/model/Database.java
---
(0039444)
hgbot   
2011-07-27 13:00   
Repository: erp/devel/pi
Changeset: 3a620590bef8eb6e40d84e110b6e787f3427626e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Jul 27 12:42:25 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3a620590bef8eb6e40d84e110b6e787f3427626e [^]

Fixed issue 18033. If a function parameter cannot be read, a nice, intelligible exception will be thrown

---
M src-db/database/lib/dbsourcemanager.jar
---
(0039707)
hudsonbot   
2011-08-01 14:21   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf2afed6e8ef [^]

Maturity status: Test
(0039814)
hgbot   
2011-08-03 12:59   
Repository: erp/devel/dbsm-main
Changeset: a740f01cdc4c7280653249b19d5547d69fb37bee
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Aug 03 12:59:05 2011 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/a740f01cdc4c7280653249b19d5547d69fb37bee [^]

Fixed issue 18033. Will also work if the bad function is only in the db.

---
M src/org/apache/ddlutils/model/Function.java
---
(0039815)
hgbot   
2011-08-03 13:02   
Repository: erp/devel/pi
Changeset: 7f10ae8a4377cb288bec825b46c064de1e9ce2b6
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Aug 03 12:59:55 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7f10ae8a4377cb288bec825b46c064de1e9ce2b6 [^]

Fixed issue 18033. Will also work if the bad function is only in the db.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0039818)
malsasua   
2011-08-03 13:06   
verified
(0039947)
hudsonbot   
2011-08-06 05:32   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5744448753e7 [^]

Maturity status: Test