[ http://issues.apache.org/jira/browse/OFBIZ-248?page=comments#action_12435317 ] Jacques Le Roux commented on OFBIZ-248: ---------------------------------------
I think that this http://lists.ofbiz.org/pipermail/users/2006-April/011600.html is related > Exception on checkout with apostrophe in address > ------------------------------------------------ > > Key: OFBIZ-248 > URL: http://issues.apache.org/jira/browse/OFBIZ-248 > Project: OFBiz (The Open for Business Project) > Issue Type: Bug > Components: order > Reporter: Jacopo Cappellato > Priority: Minor > Attachments: patch.patch > > > Copy of an old issue from Ray Barlow: > Create an order that contains an apostrophe in address line 1 i.e. > "Gardener's Cottage" > The exception below is thrown during the order creation stage of checkout, > the order is created and no error is visible to the customer, but blacklist > check is failing. > You can see from this extract of the exception the cause of the problem: > WHERE ((UPPER('blacklistString') = UPPER('GARDENER'S COTTAGE') > Exception: > 179768[ ServiceEcaRule.java:122:INFO ] Running Service ECA Service: > resetGrandTot > al, triggered by rule on Service: storeOrder > 179808[ RequestHandler.java:297:INFO ] [RequestHandler.doRequest]: Response > is a > chained request. > 179808[ RequestHandler.java:116:INFO ] [RequestHandler]: Chain in place: > requestU > ri=checkBlacklist nextView=null > 179818[ RequestHandler.java:199:INFO ] [Processing Request]: checkBlacklist > 179838[ CheckOutHelper.java:955:ERROR] > ---- exception report > ---------------------------------------------------------- > Problems with OrderBlacklist lookup. > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:SELECT BLACKLIST_STRING, > ORDER_B > LACKLIST_TYPE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, > CREATED_T > X_STAMP FROM ORDER_BLACKLIST WHERE ((UPPER('blacklistString') = > UPPER('GARDENER'S COT > TAGE') AND ORDER_BLACKLIST_TYPE_ID = ?)) (Unexpected token in statement > [SELECT BLACK > LIST_STRING, ORDER_BLACKLIST_TYPE_ID, LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, CREA > TED_STAMP, CREATED_TX_STAMP FROM ORDER_BLACKLIST WHERE > ((UPPER('blacklistString') = U > PPER('GARDENER'S COTTAGE') AND ORDER_BLACKLIST_TYPE_ID = ?))]) > ---- stack trace > --------------------------------------------------------------- > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing > the follow > ing:SELECT BLACKLIST_STRING, ORDER_BLACKLIST_TYPE_ID, LAST_UPDATED_STAMP, > LAST_UPDATE > D_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM ORDER_BLACKLIST WHERE > ((UPPER('black > listString') = UPPER('GARDENER'S COTTAGE') AND ORDER_BLACKLIST_TYPE_ID = ?)) > (Unexpec > ted token in statement [SELECT BLACKLIST_STRING, ORDER_BLACKLIST_TYPE_ID, > LAST_UPDATE > D_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM > ORDER_BLACKLIST > WHERE ((UPPER('blacklistString') = UPPER('GARDENER'S COTTAGE') AND > ORDER_BLACKLIST_TY > PE_ID = ?))]) > org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:386) > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java: > 747) > org.ofbiz.entity.datasource.GenericDAO.selectByCondition(GenericDAO.java:618) > org.ofbiz.entity.datasource.GenericHelperDAO.findByCondition(GenericHelperDAO.java:16 > 9) > org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1016) > org.ofbiz.entity.GenericDelegator.findByOr(GenericDelegator.java:967) > org.ofbiz.order.shoppingcart.CheckOutHelper.checkOrderBlacklist(CheckOutHelper.java:9 > 53) > org.ofbiz.order.shoppingcart.CheckOutEvents.checkOrderBlacklist(CheckOutEvents.java:4 > 88) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > All Comments Work Log Change History > Sort Order: [navigator.ascending.order] > Comment by Guy Gershoni [05/Aug/05 11:28 AM] > [ Permlink ] > Please note that the attached diff files are based on svn release 5458. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira