DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In entity field [TaxAuthorityRateProduct.minPurchase] - r718913

[Grant Edwards-2]

Hi

In TaxAuthorityServices.getTaxAdjustments(...) the conditions set on the
delegator.findList("TaxAuthorityRateProduct", ....) are of type
BigDecimal, however the entitymodel for TaxAuthorityRateProduct has
minPurchase defined as a currency-amount, java Double.

The error seems to make sense to me, but I could be missing something.

Cheers

Grant

         
---- exception report
----------------------------------------------------------
=-=-=-=-=-=-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In
entity field [TaxAuthorityRateProduct.minPurchase] set the value passed
in [java.math.BigDecimal] is not compatible with the Java type of the
field [Double]
Exception: java.lang.Exception
Message: Location of database type error
---- stack trace
---------------------------------------------------------------
java.lang.Exception: Location of database type error
org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267)
org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167)
org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:54)
org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:170)
org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67)
org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89)
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676)
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140)
org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273)
org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314)
org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:312)
org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:185)

[Jacques Le Roux]

These are only warnings recently and intentionnaly set in Revision: 706842 http://svn.apache.org/viewvc?rev=706842&view=rev

Jacques

From: "Grant Edwards" <[hidden email]>

> Hi
>
> In TaxAuthorityServices.getTaxAdjustments(...) the conditions set on the
> delegator.findList("TaxAuthorityRateProduct", ....) are of type
> BigDecimal, however the entitymodel for TaxAuthorityRateProduct has
> minPurchase defined as a currency-amount, java Double.
>
> The error seems to make sense to me, but I could be missing something.
>
> Cheers
>
> Grant
>
>        
> ---- exception report
> ----------------------------------------------------------
> =-=-=-=-=-=-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-= In
> entity field [TaxAuthorityRateProduct.minPurchase] set the value passed
> in [java.math.BigDecimal] is not compatible with the Java type of the
> field [Double]
> Exception: java.lang.Exception
> Message: Location of database type error
> ---- stack trace
> ---------------------------------------------------------------
> java.lang.Exception: Location of database type error
> org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267)
> org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167)
> org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:54)
> org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:170)
> org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67)
> org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89)
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676)
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140)
> org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273)
> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314)
> org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:312)
> org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:185)
>

[Adrian Crum]

For anyone else who may be seeing this error message:

It would be helpful for the development team if these errors are
reported when they are encountered - just like Grant did. The developers
need to know what calling code needs to be corrected
(TaxAuthorityServices.java in this case).

-Adrian

Jacques Le Roux wrote:

> These are only warnings recently and intentionnaly set in Revision:
> 706842 http://svn.apache.org/viewvc?rev=706842&view=rev
>
> Jacques
>
> From: "Grant Edwards" <[hidden email]>
>> Hi
>>
>> In TaxAuthorityServices.getTaxAdjustments(...) the conditions set on
>> the delegator.findList("TaxAuthorityRateProduct", ....) are of type
>> BigDecimal, however the entitymodel for TaxAuthorityRateProduct has
>> minPurchase defined as a currency-amount, java Double.
>>
>> The error seems to make sense to me, but I could be missing something.
>>
>> Cheers
>>
>> Grant
>>
>>         ---- exception report
>> ----------------------------------------------------------
>> =-=-=-=-=-=-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-=
>> In entity field [TaxAuthorityRateProduct.minPurchase] set the value
>> passed in [java.math.BigDecimal] is not compatible with the Java type
>> of the field [Double]
>> Exception: java.lang.Exception
>> Message: Location of database type error
>> ---- stack trace
>> ---------------------------------------------------------------
>> java.lang.Exception: Location of database type error
>> org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267)
>> org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167)
>>
>> org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:54)
>>
>> org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:170)
>>
>> org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67)
>>
>> org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89)
>>
>> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676)
>>
>> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140)
>>
>> org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273)
>> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314)
>> org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:312)
>>
>> org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:185)
>>
>

[Jacques Le Roux]

We could even open a Jira issue for this...

Jacques

From: "Adrian Crum" <[hidden email]>

> For anyone else who may be seeing this error message:
>
> It would be helpful for the development team if these errors are
> reported when they are encountered - just like Grant did. The developers
> need to know what calling code needs to be corrected
> (TaxAuthorityServices.java in this case).
>
> -Adrian
>
> Jacques Le Roux wrote:
>> These are only warnings recently and intentionnaly set in Revision:
>> 706842 http://svn.apache.org/viewvc?rev=706842&view=rev
>>
>> Jacques
>>
>> From: "Grant Edwards" <[hidden email]>
>>> Hi
>>>
>>> In TaxAuthorityServices.getTaxAdjustments(...) the conditions set on
>>> the delegator.findList("TaxAuthorityRateProduct", ....) are of type
>>> BigDecimal, however the entitymodel for TaxAuthorityRateProduct has
>>> minPurchase defined as a currency-amount, java Double.
>>>
>>> The error seems to make sense to me, but I could be missing something.
>>>
>>> Cheers
>>>
>>> Grant
>>>
>>>         ---- exception report
>>> ----------------------------------------------------------
>>> =-=-=-=-=-=-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-=-=
>>> In entity field [TaxAuthorityRateProduct.minPurchase] set the value
>>> passed in [java.math.BigDecimal] is not compatible with the Java type
>>> of the field [Double]
>>> Exception: java.lang.Exception
>>> Message: Location of database type error
>>> ---- stack trace
>>> ---------------------------------------------------------------
>>> java.lang.Exception: Location of database type error
>>> org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:267)
>>> org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:167)
>>>
>>> org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:54)
>>>
>>> org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:170)
>>>
>>> org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67)
>>>
>>> org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89)
>>>
>>> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676)
>>>
>>> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140)
>>>
>>> org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273)
>>> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:2314)
>>> org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:312)
>>>
>>> org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:185)
>>>
>>
>

[David E Jones-3]

It would also be great to get some help with the type cleanup branch  
that Scott and I have been working on.

Here is the SVN URL:

http://svn.apache.org/repos/asf/ofbiz/branches/typecheckcleanup200810 
(https for committers)

-David


On Nov 24, 2008, at 11:04 AM, Adrian Crum wrote:

> For anyone else who may be seeing this error message:
>
> It would be helpful for the development team if these errors are  
> reported when they are encountered - just like Grant did. The  
> developers need to know what calling code needs to be corrected  
> (TaxAuthorityServices.java in this case).
>
> -Adrian
>
> Jacques Le Roux wrote:
>> These are only warnings recently and intentionnaly set in Revision:  
>> 706842 http://svn.apache.org/viewvc?rev=706842&view=rev
>> Jacques
>> From: "Grant Edwards" <[hidden email]>
>>> Hi
>>>
>>> In TaxAuthorityServices.getTaxAdjustments(...) the conditions set  
>>> on the delegator.findList("TaxAuthorityRateProduct", ....) are of  
>>> type BigDecimal, however the entitymodel for  
>>> TaxAuthorityRateProduct has minPurchase defined as a currency-
>>> amount, java Double.
>>>
>>> The error seems to make sense to me, but I could be missing  
>>> something.
>>>
>>> Cheers
>>>
>>> Grant
>>>
>>>        ---- exception report  
>>> ----------------------------------------------------------
>>> =-=-=-=-=-=-=-=-= DATABASE TYPE ERROR in EntityExpr =-=-=-=-=-=-=-
>>> =-= In entity field [TaxAuthorityRateProduct.minPurchase] set the  
>>> value passed in [java.math.BigDecimal] is not compatible with the  
>>> Java type of the field [Double]
>>> Exception: java.lang.Exception
>>> Message: Location of database type error
>>> ---- stack trace  
>>> ---------------------------------------------------------------
>>> java.lang.Exception: Location of database type error
>>> org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:
>>> 267)
>>> org
>>> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
>>> 167)
>>> org
>>> .ofbiz
>>> .entity
>>> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
>>> 54)
>>> org
>>> .ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:
>>> 170)
>>> org
>>> .ofbiz
>>> .entity
>>> .condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:
>>> 67)
>>> org
>>> .ofbiz
>>> .entity
>>> .condition
>>> .EntityConditionListBase
>>> .makeWhereString(EntityConditionListBase.java:89)
>>> org
>>> .ofbiz
>>> .entity
>>> .datasource
>>> .GenericDAO.selectListIteratorByCondition(GenericDAO.java:676)
>>> org
>>> .ofbiz
>>> .entity
>>> .datasource
>>> .GenericHelperDAO
>>> .findListIteratorByCondition(GenericHelperDAO.java:140)
>>> org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:2273)
>>> org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:
>>> 2314)
>>> org
>>> .ofbiz
>>> .accounting
>>> .tax
>>> .TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:
>>> 312)
>>> org
>>> .ofbiz
>>> .accounting
>>> .tax
>>> .TaxAuthorityServices.rateProductTaxCalc(TaxAuthorityServices.java:
>>> 185)