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. |
[ 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. |
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. |
Free forum by Nabble | Edit this page |