You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jan Valkovic (JIRA)" <ji...@apache.org> on 2009/02/16 17:34:59 UTC
[jira] Created: (OFBIZ-2192) GenericDataSourceException in
ViewFacilityInventoryByProduct.bsh on pgSQL 8.3
GenericDataSourceException in ViewFacilityInventoryByProduct.bsh on pgSQL 8.3
-----------------------------------------------------------------------------
Key: OFBIZ-2192
URL: https://issues.apache.org/jira/browse/OFBIZ-2192
Project: OFBiz
Issue Type: Bug
Components: product
Affects Versions: Release Branch 4.0
Environment: SQL: PostgreSQL 8.3.5
JDBC Driver: postgresql-8.3-603.jdbc4.jar
Reporter: Jan Valkovic
Priority: Minor
Script: [OFBIZ_HOME]/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh throws an exception:
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PROD.INTERNAL_NAME, PROD.IS_VIRTUAL, PROD.SALES_DISCONTINUATION_DATE, PROD.PRODUCT_TYPE_ID, PRFA.PRODUCT_ID, PRFA.FACILITY_ID, PRFA.MINIMUM_STOCK, PRFA.REORDER_QUANTITY, PRFA.DAYS_TO_SHIP FROM public.PRODUCT PROD INNER JOIN public.PRODUCT_FACILITY PRFA ON PROD.PRODUCT_ID = PRFA.PRODUCT_ID WHERE ((PRFA.FACILITY_ID = ? AND PROD.PRODUCT_TYPE_ID = ?) AND (PROD.IS_VIRTUAL IS NULL OR PROD.IS_VIRTUAL <> ?) AND (PROD.SALES_DISCONTINUATION_DATE IS NULL OR PROD.SALES_DISCONTINUATION_DATE > ?)) ORDER BY PRFA.PRODUCT_ID ASC (ERROR: operator does not exist: timestamp with time zone > character varying)
I fixed this error by add explicit conversion to Timestamp in line 112:
new EntityExpr("salesDiscontinuationDate", EntityOperator.GREATER_THAN, Timestamp.valueOf(productsSoldThruTimestamp)))
I tested this only on Derby and pgSQL.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-2192) GenericDataSourceException in
ViewFacilityInventoryByProduct.bsh on pgSQL 8.3
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Le Roux closed OFBIZ-2192.
----------------------------------
Resolution: Fixed
Fix Version/s: Release Branch 4.0
Assignee: Jacques Le Roux
Thanks Jan,
Yes, this is a known bug. Hopefully we have fixed all occurences in trunk some months ago. The recommended way of fixing it is to put something like
<set field="productsSoldThruTimestamp" from-field="parameters.productsSoldThruTimestamp" type="Timestamp"/>
in FacilityScreens.xml#ViewFacilityInventoryByProduct
Done in revision 744964.
> GenericDataSourceException in ViewFacilityInventoryByProduct.bsh on pgSQL 8.3
> -----------------------------------------------------------------------------
>
> Key: OFBIZ-2192
> URL: https://issues.apache.org/jira/browse/OFBIZ-2192
> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: Release Branch 4.0
> Environment: SQL: PostgreSQL 8.3.5
> JDBC Driver: postgresql-8.3-603.jdbc4.jar
> Reporter: Jan Valkovic
> Assignee: Jacques Le Roux
> Priority: Minor
> Fix For: Release Branch 4.0
>
> Original Estimate: 0.08h
> Remaining Estimate: 0.08h
>
> Script: [OFBIZ_HOME]/product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh throws an exception:
> Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PROD.INTERNAL_NAME, PROD.IS_VIRTUAL, PROD.SALES_DISCONTINUATION_DATE, PROD.PRODUCT_TYPE_ID, PRFA.PRODUCT_ID, PRFA.FACILITY_ID, PRFA.MINIMUM_STOCK, PRFA.REORDER_QUANTITY, PRFA.DAYS_TO_SHIP FROM public.PRODUCT PROD INNER JOIN public.PRODUCT_FACILITY PRFA ON PROD.PRODUCT_ID = PRFA.PRODUCT_ID WHERE ((PRFA.FACILITY_ID = ? AND PROD.PRODUCT_TYPE_ID = ?) AND (PROD.IS_VIRTUAL IS NULL OR PROD.IS_VIRTUAL <> ?) AND (PROD.SALES_DISCONTINUATION_DATE IS NULL OR PROD.SALES_DISCONTINUATION_DATE > ?)) ORDER BY PRFA.PRODUCT_ID ASC (ERROR: operator does not exist: timestamp with time zone > character varying)
> I fixed this error by add explicit conversion to Timestamp in line 112:
> new EntityExpr("salesDiscontinuationDate", EntityOperator.GREATER_THAN, Timestamp.valueOf(productsSoldThruTimestamp)))
> I tested this only on Derby and pgSQL.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.