0031645: It is not possible to use the character ' on warehouse name

Description

When using a name that contains the character ', you can not login on the mobile procurement terminal using the warehouse with that name.

Steps To Reproduce

Change the name of the warejhouse used by the dafult by a user for the terminal by adding the charecter ' on the name.

When loggin the terminal you get the following error:

b17d993 2015-12-02 12:37:48,039 [ajp-bio-127.0.0.1-8009-exec-1] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.mobile.procurement.term.Terminal: Error when generating query: null (expecting 'd', found '0' [select pop.id as id, '517C7BAD1822443E945017F6A97FD531' as businessPartner, pop.commercialName as _identifier, pop.searchKey as searchKey, pop.defaultTab as defaultTab, '89303CB25A4B4422B3C921BB4E4C0848' as organization, 'DGO1' as organization$_identifier, '36837D3A6CDA46729E9199228B2316A9' as client, 'RegionWallonne' as client$_identifier, 'B2AAE2BE034C4F6CAC7D3C292D464A30' as warehouse, 'Local d'entreposage DG01' as warehouse$_identifier, '0B06C1B512E742628D23F296DA31CE7D' as priceList, '102' as currency, pop.documentType.id as documentType, COALESCE(false, false) as enableOrderWeightControl, TO_NUMBER('0') as minimumOrderWeight, COALESCE(false, false) as blockUnderWeightOrder, TO_NUMBER('0') as maximumOrderWeight, COALESCE(false, false) as blockOverWeightOrder, 'null' as regionId, '103' as countryId from OBMPR_CONFIGURATION AS pop where ( (pop.client.id in ('36837D3A6CDA46729E9199228B2316A9', '0')) and (pop.organization.id in ('132B6125AFAE40068532AF10F02AE1B5', '0', '133D7D2AA6BD4696ACCFBB94508DBAB0', 'C9BE4470D800486F8D77E3C4AEB27C88', '89303CB25A4B4422B3C921BB4E4C0848')) ) and (pop.active = 'Y') and pop.searchKey = 'DGO1-1'])
org.hibernate.QueryException: expecting 'd', found '0' [select pop.id as id, '517C7BAD1822443E945017F6A97FD531' as businessPartner, pop.commercialName as _identifier, pop.searchKey as searchKey, pop.defaultTab as defaultTab, '89303CB25A4B4422B3C921BB4E4C0848' as organization, 'DGO1' as organization$_identifier, '36837D3A6CDA46729E9199228B2316A9' as client, 'RegionWallonne' as client$_identifier, 'B2AAE2BE034C4F6CAC7D3C292D464A30' as warehouse, 'Local d'entreposage DG01' as warehouse$_identifier, '0B06C1B512E742628D23F296DA31CE7D' as priceList, '102' as currency, pop.documentType.id as documentType, COALESCE(false, false) as enableOrderWeightControl, TO_NUMBER('0') as minimumOrderWeight, COALESCE(false, false) as blockUnderWeightOrder, TO_NUMBER('0') as maximumOrderWeight, COALESCE(false, false) as blockOverWeightOrder, 'null' as regionId, '103' as countryId from OBMPR_CONFIGURATION AS pop where ( (pop.client.id in ('36837D3A6CDA46729E9199228B2316A9', '0')) and (pop.organization.id in ('132B6125AFAE40068532AF10F02AE1B5', '0', '133D7D2AA6BD4696ACCFBB94508DBAB0', 'C9BE4470D800486F8D77E3C4AEB27C88', '89303CB25A4B4422B3C921BB4E4C0848')) ) and (pop.active = 'Y') and pop.searchKey = 'DGO1-1']
    at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:229)
    at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
    at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
    at org.openbravo.mobile.core.process.ProcessHQLQuery.exec(ProcessHQLQuery.java:114)
    at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:42)
    at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:167)

Issue History
Date Modified	Username	Field	Change
2015-12-02 14:17	egoitz	New Issue
2015-12-02 14:17	egoitz	Assigned To	=> Retail
2015-12-02 14:17	egoitz	Triggers an Emergency Pack	=> No
2017-02-20 18:44	rqueralta	Assigned To	Retail => rqueralta

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.