Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016541Openbravo ERPA. Platformpublic2011-03-29 16:022011-05-03 11:02
Reporteradrianromero 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP27 
Target Version2.50MP30Fixed in Version2.50MP30 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016541: Cannot use null in a BaseOBObject parameter when calling a procedure
DescriptionWhen using the class CallStoredProcedure to call a procedure and passing NULL in a parameter of type BaseOBObject an error is returned. If the value is not null it works
Steps To ReproduceWhen calling a procedure pass a parameter using the following code:

types.add(org.openbravo.model.common.currency.ConversionRate.class);
parameters.add(null);

The problem is in the method getSQLType that raises an exception. In this particular case VARCHAR must be returned.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0016531 closed dalsasua Cannot use null in a BaseOBObject parameter when calling a procedure 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-29 16:02adrianromeroNew Issue
2011-03-29 16:02adrianromeroAssigned To => mtaal
2011-03-29 16:02adrianromeroModules => Core
2011-03-29 16:02adrianromeroOBNetwork customer => Yes
2011-03-29 16:02adrianromeroIssue generated from0016531
2011-03-29 16:02adrianromeroRelationship addeddepends on 0016531
2011-03-29 16:03adrianromeroTarget Version2.50MP31 => 2.50MP30
2011-03-31 17:13adrianromeroAssigned Tomtaal => adrianromero
2011-03-31 17:24adrianromeroStatusnew => scheduled
2011-04-01 12:33hgbotCheckin
2011-04-01 12:33hgbotNote Added: 0035456
2011-04-01 12:33hgbotStatusscheduled => resolved
2011-04-01 12:33hgbotResolutionopen => fixed
2011-04-01 12:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/ec9f5d609ce062db3856c4bf33d7523b547fa518 [^]
2011-05-03 11:02jonalegriaesarteNote Added: 0036300
2011-05-03 11:02jonalegriaesarteStatusresolved => closed
2011-05-03 11:02jonalegriaesarteFixed in Version => 2.50MP30

Notes
(0035456)
hgbot   
2011-04-01 12:33   
Repository: erp/stable/2.50
Changeset: ec9f5d609ce062db3856c4bf33d7523b547fa518
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Mar 31 17:14:46 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/ec9f5d609ce062db3856c4bf33d7523b547fa518 [^]

Fixes issue 0016541: Cannot use null in a BaseOBObject parameter when calling a procedure
It has been modified the code to detect nulls when assigning as a procedure parameter a BaseOBObject

---
M src/org/openbravo/service/db/CallStoredProcedure.java
---
(0036300)
jonalegriaesarte   
2011-05-03 11:02   
Verified