[jira] Created: (OFBIZ-3145) Useless EntitySubSelect warning message.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (OFBIZ-3145) Useless EntitySubSelect warning message.

Nicolas Malin (Jira)
Useless EntitySubSelect warning message.
----------------------------------------

                 Key: OFBIZ-3145
                 URL: https://issues.apache.org/jira/browse/OFBIZ-3145
             Project: OFBiz
          Issue Type: Improvement
    Affects Versions: SVN trunk
            Reporter: Matarazzo Angelo
            Priority: Minor
             Fix For: SVN trunk
         Attachments: SubSelectWarningMess.patch

When you use EntityConditionSubSelect
a warning message  uselessly  fill ofbiz.log everytime.

Test it
Go  
https://localhost:8443/catalog/control/advancedsearch ,

choose
"Feature Category IDs:" (eg.10000)  
choose
 "Exclude"

In ofiz.log appears

2009-11-03 20:47:47,453 (http-0.0.0.0-8443-4) [      ProductSearch.java:624:INFO ] topCond=(mainProductId <>  ALL(SELECT PFA.PRODUCT_ID FROM OFBIZ.PRODUCT_FEATURE PF INNER JOIN OFBIZ.PRODUCT_FEATURE_APPL PFA ON PF.PRODUCT_FEATURE_ID = PFA.PRODUCT_FEATURE_ID WHERE ((PFA.THRU_DATE IS NULL OR PFA.THRU_DATE > ?) AND PFA.FROM_DATE < ? AND PF.PRODUCT_FEATURE_CATEGORY_ID IN (?))))
2009-11-03 20:47:47,468 (http-0.0.0.0-8443-4) [         EntityExpr.java:288:WARN ]
---- exception report ----------------------------------------------------------
=-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-= In entity field [DynamicViewEntity.mainProductId] set the value passed in [org.ofbiz.entity.condition.EntityConditionSubSelect] is not compatible with the Java type of the field [String]
Exception: java.lang.Exception
Message: Location of database type warning

The patch resolves this small problem.


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-3145) Useless EntitySubSelect warning message.

Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matarazzo Angelo updated OFBIZ-3145:
------------------------------------

    Attachment: SubSelectWarningMess.patch

> Useless EntitySubSelect warning message.
> ----------------------------------------
>
>                 Key: OFBIZ-3145
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3145
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Matarazzo Angelo
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: SubSelectWarningMess.patch
>
>
> When you use EntityConditionSubSelect
> a warning message  uselessly  fill ofbiz.log everytime.
> Test it
> Go  
> https://localhost:8443/catalog/control/advancedsearch ,
> choose
> "Feature Category IDs:" (eg.10000)  
> choose
>  "Exclude"
> In ofiz.log appears
> 2009-11-03 20:47:47,453 (http-0.0.0.0-8443-4) [      ProductSearch.java:624:INFO ] topCond=(mainProductId <>  ALL(SELECT PFA.PRODUCT_ID FROM OFBIZ.PRODUCT_FEATURE PF INNER JOIN OFBIZ.PRODUCT_FEATURE_APPL PFA ON PF.PRODUCT_FEATURE_ID = PFA.PRODUCT_FEATURE_ID WHERE ((PFA.THRU_DATE IS NULL OR PFA.THRU_DATE > ?) AND PFA.FROM_DATE < ? AND PF.PRODUCT_FEATURE_CATEGORY_ID IN (?))))
> 2009-11-03 20:47:47,468 (http-0.0.0.0-8443-4) [         EntityExpr.java:288:WARN ]
> ---- exception report ----------------------------------------------------------
> =-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-= In entity field [DynamicViewEntity.mainProductId] set the value passed in [org.ofbiz.entity.condition.EntityConditionSubSelect] is not compatible with the Java type of the field [String]
> Exception: java.lang.Exception
> Message: Location of database type warning
> The patch resolves this small problem.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Closed: (OFBIZ-3145) Useless EntitySubSelect warning message.

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Le Roux closed OFBIZ-3145.
----------------------------------

    Resolution: Fixed
      Assignee: Jacques Le Roux

Thanks Angelo,

Your patch is in trunk at r832880  


> Useless EntitySubSelect warning message.
> ----------------------------------------
>
>                 Key: OFBIZ-3145
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-3145
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Matarazzo Angelo
>            Assignee: Jacques Le Roux
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: SubSelectWarningMess.patch
>
>
> When you use EntityConditionSubSelect
> a warning message  uselessly  fill ofbiz.log everytime.
> Test it
> Go  
> https://localhost:8443/catalog/control/advancedsearch ,
> choose
> "Feature Category IDs:" (eg.10000)  
> choose
>  "Exclude"
> In ofiz.log appears
> 2009-11-03 20:47:47,453 (http-0.0.0.0-8443-4) [      ProductSearch.java:624:INFO ] topCond=(mainProductId <>  ALL(SELECT PFA.PRODUCT_ID FROM OFBIZ.PRODUCT_FEATURE PF INNER JOIN OFBIZ.PRODUCT_FEATURE_APPL PFA ON PF.PRODUCT_FEATURE_ID = PFA.PRODUCT_FEATURE_ID WHERE ((PFA.THRU_DATE IS NULL OR PFA.THRU_DATE > ?) AND PFA.FROM_DATE < ? AND PF.PRODUCT_FEATURE_CATEGORY_ID IN (?))))
> 2009-11-03 20:47:47,468 (http-0.0.0.0-8443-4) [         EntityExpr.java:288:WARN ]
> ---- exception report ----------------------------------------------------------
> =-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-= In entity field [DynamicViewEntity.mainProductId] set the value passed in [org.ofbiz.entity.condition.EntityConditionSubSelect] is not compatible with the Java type of the field [String]
> Exception: java.lang.Exception
> Message: Location of database type warning
> The patch resolves this small problem.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.